How to create a Nested IF formulae for the detailed below :
Options
Gaurav Chauhan
✭✭✭✭✭✭
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
-
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
-
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.
-
Thank you. I replicated and it worked
Help Article Resources
Categories
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!