Multiple IF statements

deb_63_hydracor · 06/15/22

Hello,

I'm trying to populate a follow-up date depending upon the status. My formula works for one criteria:

=IF([Sales Status]@row="Hold for Future Follow-up", 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 Follow-up", TODAY + 90)

Thanks for your help!

Jeff Reisman · 06/15/22

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.

deb_63_hydracor · 06/16/22

That worked! Thanks so much Jeff!

Jeff Reisman · 06/16/22

https://community.smartsheet.com/discussion/comment/333088#Comment_333088

Happy to help!

Multiple IF statements

Answers

Help Article Resources

Categories