Welcome to the Smartsheet Forum Archives


The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.

Date Formulas

Options
April Rosier
edited 12/09/19 in Archived 2017 Posts

Is there a way to start a date in one cell in one columns and it add x amount of days to it is sequential columns?

Ex:

Row1: Name of group; Kick-off date; 14 days after kickoff date; 20 days after kickoff date, etc....

Advance thanks!

Comments

  • Mike Wilday
    Mike Wilday ✭✭✭✭✭✭
    Options

    Do you want work days or calendar days? 

    =[Kickoff Date Column]1+15  --- will give you 15 calendar days after the kickoff

    =Workday([Kickoff Date Column]1, 15) -- will give you 15 business days after the kickoff date column. 

    Those fomulas assume you are using them in the first row. Update the row number to match whichever row you are first using it in... then click on the cell and drag the bottom-right-hand corner down to populate the rest. You will also need to make sure the column type is a date column. 

This discussion has been closed.