Multiple IF statements

deb_63_hydracor ✭✭✭✭✭✭
edited 06/15/22 in Formulas and Functions


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!



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!