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.

Automatically back dating based upon future date

Options

Hello,

 

I would like to update a sheet by putting a date in one field and having serveral date feild updated based upon the first feild. 

 

Now I think that I can do [date] + 15 or [field] + 15 but can't figure out how to set a date and work back 1,2,3, etc weeks from that date. [Field] - 7 day does not appear to work.

 

Basically:

Field 1 = 2/17/17 

Field 2= (formula [field 1] - 45 days) 1/3/17

 

Thank you in advance for your assistance !

 

Tags:

Comments

  • J. Craig Williams
    J. Craig Williams ✭✭✭✭✭✭
    Options

    If your date cell is in the [Due Date] coumn and row 23, then this formula

     

    =[Due Date]23 - 45

     

    should show you the date 45 days before the date in your cell.

    This needs to be in Date type column.

     

    Craig

This discussion has been closed.