Calculating 90 days from a date

How do I calculate 90 days from someone's hire date?

Column Name: Hire date 01/03/2023

Formula I am trying to use: ==[Hire Date]@row + 90

This is coming back as 01/03/202390 which is wrong. It should be 4/3/23


  • Jaime M.
    Jaime M. ✭✭✭


    I would add a helper column for the "Day Until Next Review" and reference this in your equation instead. You could add an automation to automatically put 90 in the "Day Until Next Review" column, or alternatively, make it the default value in a form - depending on how you are entering the information.

    =[Hire Date]@row + [Days Until Next Review]@row

    Hope this helps!

  • Peggy Parchert
    Peggy Parchert ✭✭✭✭✭✭
    edited 07/15/23


    Hello - hope you are well. You show two "=" in your formula above. Is that correct? Is your Hire date column a date column?


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!