Questions tagged [if-statement]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
0
votes
1answer
21 views

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 ...
0
votes
1answer
17 views

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 ...
1
vote
2answers
16 views

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 ...
1
vote
2answers
39 views

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 ...
0
votes
1answer
27 views

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 ...
0
votes
1answer
241 views

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 ...
0
votes
1answer
99 views

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 $...