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
 All Categories
 14 Welcome to the Community
 10.6K Get Help
 63 Global Discussions
 68 Industry Talk
 385 Announcements
 3.5K Ideas & Feature Requests
 55 Brandfolder
 125 Just for fun
 50 Community Job Board
 464 Show & Tell
 40 Member Spotlight
 44 Power Your Process
 28 Sponsor X
 234 Events
 7.3K Forum Archives
Check out the Formula Handbook template!