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