Formula for Calculating Dates

Welcome to the New Smartsheet Online Community

You’ll notice that things have changed a bit. If you need help getting oriented, please take a look at the posts here in the Welcome to the Community category.

Formula for Calculating Dates

This discussion was created from comments split from: Calculate Future Date.


  • I need formula to calculate a date to start checking on a column example

    Installation date, need to add 2 weeks prior to start follow up to upcoming information (This will be on the left of the Installation date column)

  • If I'm understanding your question correctly-- are you saying you need a formula that calculates 2 weeks before the install date?

    =[Installation Date]@row-14

    Should populate your install date - 14 days

  • Paul NewcomePaul Newcome ✭✭✭✭✭

    @Melissa Frost

    I agree with @Spark@Spark's solution. Were you able to get it working?

Sign In or Register to comment.