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
Trouble with IF
+4Best answer by BillH
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"))
+24You have an extra ")" after the first IF. Try
IF({Sonrise Home} = "CH", "Sonrise Children's Home", IF({Sonrise Home} = "MIR", "Mirembe Cottage for Girls"))
Login to the community
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.