Oct 31, 2023 07:33 AM
What is wrong with this IF statement?
IF({Sonrise Home} = "CH", "Sonrise Children's Home"), IF({Sonrise Home} = "MIR", "Mirembe Cottage for Girls"))
"Sorry, there was a problem saving this field. Invalid formula. Please check your formula text."
Solved! Go to Solution.
Oct 31, 2023 07:41 AM
You have an extra ")" after the first IF. Try
IF({Sonrise Home} = "CH", "Sonrise Children's Home", IF({Sonrise Home} = "MIR", "Mirembe Cottage for Girls"))
Oct 31, 2023 07:41 AM
You have an extra ")" after the first IF. Try
IF({Sonrise Home} = "CH", "Sonrise Children's Home", IF({Sonrise Home} = "MIR", "Mirembe Cottage for Girls"))
Oct 31, 2023 07:47 AM
thanks Bill!