Multiple IF statements
Hello,
I'm trying to populate a followup date depending upon the status. My formula works for one criteria:
=IF([Sales Status]@row="Hold for Future Followup", TODAY() + 90)
When I try to add on another IF statement, I get an error (I have 5 IF statements to combine). Each part of the formula works perfectly on its own.
=IF([Sales Status]@row="Discovery Call  Completed",TODAY() + 2), IF([Sales Status]@row="Hold for Future Followup", TODAY + 90)
Thanks for your help!
Answers

So close! Just one misplaced end parentheses. Move the circled one to the end of the formula.
You don't want to close off the first IF statement until the end, because the second IF statement exists as the negative condition in the first IF statement, so technically it's part of the first IF statement. Having the end parentheses in that spot closes the first IF too early.
Rule of thumb with nested IFs is all IFs stay opened until the end, and then there should be one close parentheses at the very end of the formula corresponding to each IF statement.
Regards,
Jeff Reisman
Link: Smartsheet Functions Help Pages Link: Smartsheet Formula Error Messages
If my answer helped solve your issue, please mark it as accepted so that other users can find it later. Thanks!

That worked! Thanks so much Jeff!

Happy to help!
Regards,
Jeff Reisman
Link: Smartsheet Functions Help Pages Link: Smartsheet Formula Error Messages
If my answer helped solve your issue, please mark it as accepted so that other users can find it later. Thanks!
Help Article Resources
Categories
Check out the Formula Handbook template!