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

Options
Gaurav Chauhan
Gaurav Chauhan ✭✭✭✭✭✭
in Formulas and Functions

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:
· Share on FacebookShare on Twitter

Best Answer

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

    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.

    · Share on FacebookShare on Twitter

Answers

Help Article Resources

Create and edit formulas in Smartsheet

Formula combinations for cross sheet references

Smartsheet functions list

Categories

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!