Questions tagged [if-statement]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
0 votes
1 answer

If statement comparing a calculated result to a number returns false even if they're the same

Number field "QuantiteStockageConteneur" = 7922.55 Currency field "TauxStockageConteneur" = 0.28 Currency field "StockageDeConteneur_ParPiedCube" = 2218.31 I have tried: ...
Daniel Dumaresq's user avatar
0 votes
1 answer

Getting part of the value from a column title

Silly question. We have a Document library and basically we are saving emails in a *.msg format. where the title is the subject of the email. I would like to save part of the title as an additional ...
sajarac's user avatar
0 votes
1 answer

3 IF Statements

I have a calculated column which should return DepA, DepB or DepC according to the multiple IF statement which I cannot work out correctly!!! I have a DateRequest which is entered by the user. I then ...
mtagliaferri's user avatar
1 vote
2 answers

Calculated column using 4 different columns to derive an "approve" or "Decline" answer

I would like to use an IF function to obtain an answer to "Approve" or "Decline" within a SharePoint list. My formula works in Excel but not in SharePoint. I have 4 SharePoint ...
Kelley's user avatar
  • 13
1 vote
2 answers

SP 2013 - What is the correct syntax to add the results of 2 or more If statements?

I want to create a "scorecard" where the user simply selects "yes" or "no" for each field in the list. Then, I want to assign a point value to "yes" or "no values and add the point values together in ...
Howard Waxman's user avatar
0 votes
1 answer

If ELSE / ELSE statement is not showing up

I want to use IF ELSE statement in the SharePoint designer 2013 but it is not showing up I am trying to get else by pressing Alt + W + B but sometimes it works, other times it doesn't. Any idea what ...
Noman's user avatar
  • 151
0 votes
1 answer

Does Sharepoint allow IFS formula

I tested this on excel but can not translated to Sharepoint. I am trying to test for example if Column C has date that is greater than the one in column D = Submitted on time, if column C's date is ...
Luis's user avatar
  • 3
0 votes
1 answer

if statement being disregarded in a PnPPowerShell loop

I am trying to iterate through a collection of document libraries and run code on the ones that are of a particular Content-Type. The if statement is being disregarded entirely and the write-host $...
Martin Muldoon's user avatar