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

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

Sameer Karkhanis

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.

Sameer Karkhanis

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.

Gaurav Chauhan

Thank you. I replicated and it worked