Forum Discussion
Solved
IF Formula trouble SharePoint Column
Hi I have a column (Project Request) with numbers from 0-7 My Formula should give the Output like this A= >5 B= >2 C= <2 i try to create a new calculated column with this Formula, but...
No unfortunately not
But i found my mistake.
I must use ; between the Expressions.
I think my Problem is here i switch from englisch - german and back ;-)
H! I assume your Project request column is a number column. And the result type of your calculated column should be a text column.
With a flow in ms flow you could also do a switch action for your sp column, without that nested if functions. In my eyes it is more reliable than a calculated file. Trigger could be when an item is created or changed. And calculation could be written in variable so it’s more performant.
Greets, Eva
With a flow in ms flow you could also do a switch action for your sp column, without that nested if functions. In my eyes it is more reliable than a calculated file. Trigger could be when an item is created or changed. And calculation could be written in variable so it’s more performant.
Greets, Eva
No unfortunately not
But i found my mistake.
I must use ; between the Expressions.
I think my Problem is here i switch from englisch - german and back ;-)