Multiple IFs in If Statement

Hi there -


I'm creating a simple task tracking sheet, but having trouble formulating the correct formula.

I have a TASK, ASSIGNED DATE, and a DUE DATE. I would like the due date to be dependent on the task at hand - a survey would be due 2 days after assigned, permit comments are due 3 days after, and so on (I have 5 tasks total, with differing lengths of time to complete the task).


Here is my formula, i am receiving an "#UNPARSEABLE" error.

=IF(TASK@row = "SURVEY", [DATE ASSIGNED]@row + 2), IF(TASK@row = "PERMIT COMMENTS", [DATE ASSIGNED]@row + 3)

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!