How to create a Nested IF formulae for the detailed below :

If Type is Option A, then Target Completion is Assigned Date + 7

if Type is option B, then Target Completion is Assigned Date + 15

Tags:

Best Answer

  • Sameer Karkhanis
    Sameer Karkhanis ✭✭✭✭✭✭
    Answer ✓

    IF([Type]@row = "Option A", [Assigned Date]@row + 7, IF( [Type]@row = "Option B", [Assigned Date]@row + 15)) . Make sure the column where you use this formula is of type date otherwise you may get error.

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!