Skip to main content

Questions tagged [if-statement]

Filter by
Sorted by
Tagged with
0 votes
0 answers
20 views

If/Then Python Script for SharePoint

We have thousands of construction blueprints in PDF format, many go back decades. Many blueprints are duplicates created accidentally because we never established a proper naming procedure. So a ...
0 votes
1 answer
186 views

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: ...
0 votes
1 answer
106 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
1 answer
38 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
2 answers
31 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
2 answers
41 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
1 answer
55 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
1 answer
2k 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
1 answer
410 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 $...