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 i get an error every time.
=IF([Project Request Index]>5,"A",IF([Project Request Index]>2,"B","C"))
what is wrong here?
it should be simple
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, EvaNo 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 ;-)
