- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎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.
Accepted Solutions
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎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"))
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎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"))
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Oct 31, 2023 07:47 AM
thanks Bill!
