1
Your formula seems fine to me.
=IF([Question 1] = "Italy", "1", "0")
Make sure you have below things correctly:
Set The data type returned from this formula is to Single line of text like:
Microsoft documentations:
Calculated Field Formulas
IF function
Note:
Sometimes comma(,) does not work in formula (It is based on ...
1
If [RAG] column is of type Number, try using this:
=IF([RAG] <= 3, "Green", IF(OR([RAG] = 4, [RAG] = 5, [RAG] = 6), "Yellow", IF(OR([RAG] = 8, [RAG] = 9, [RAG] = 10), "Amber", IF([RAG] >= 15, "Red", ""))))
Note:
Sometimes comma(,) does not work in formula (I am not sure but it is based on something ...
Only top voted, non community-wiki answers of a minimum length are eligible
