Airtable Cobuilder is here! Learn more about our new no-code app creation feature, powered by AI on the Airtable Academy
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!