Formula to change certain Dates

Leonie Muller
Leonie Muller ✭✭✭
edited 12/09/19 in Formulas and Functions

Hi I am in need of some urgent help.  When the date paid has been changed I want the Company Review date to change by a Full Year and the once that has change I want the due date to change by 2mths.


It would be much appreciated if someone could please help me out.




  • Paul Newcome
    Paul Newcome ✭✭✭✭✭✭

    Are you able to provide some screenshots with sensitive/confidential data hidden or replaced with "dummy data"?


    Just based on your post I would think that entering this into the Company Review Date


    =[Date Paid]@row + 365


    and this in the due date field


    =[Company Review]@row + 60


    Should be a good start.

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!