Formula to automatically calculate 3 years from a date in another cell

Options

I want to create a formula to automatically calculate 3 years from a date in another cell so that I know when something has to be renewed. Any advice

Best Answer

  • Gregory Watt
    Gregory Watt ✭✭
    Answer ✓
    Options

    This is what I do for notifications.


    Future Colum Cell =[Your Date Row]@row + 1095

    Due Colum Cell =[Your Future Cell]@row - TODAY()

    Then I run a notification email once a week, where Date Until/Over - Is less than

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!