Questions tagged [if-statement]
The if-statement tag has no usage guidance.
9
questions
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 $...