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!


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


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!