IF Statement with Dates

Need help with a nested IF statement?

Please see attached, I need to automatically change the ACTUAL DATE column by adding the number of days in the DAYS column to the ESTIMATED DATE column based on the TEAM column?

Any help is appreciated!

Thx


Best Answer

  • Kimberly Loveless
    Kimberly Loveless ✭✭✭✭✭✭
    Answer ✓

    if I am understanding correctly you would do something like

    =IF(TEAM@row = "DOP", [Estimated Date]@row +90 ,IF(TEAM@row ="IOP", [Estimated Date]@row+60,IF(TEAM@row = "LEAN", [Estimated Date]@row+30

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!