Populate Date Column Based on Primary Date Column (taking into consideration workdays)

saltyblueocean

I am attempting to automatically populate a date column when a "due date" column is filled out. The dependent date column would always be a date 3 working days after the due date unless manually changed. I have been scouring dependency columns and if then statements but I can't seem to figure out something that seems like it would be simple.

 

Any help would be greatly appreciated!

 

Cheers

Shaine Greenwood

Hello!

 

You can place a formula in your date column that adds three days to that of your due date column like the following example:

 

=[Due Date]1 + 3

 

It appears that you're wanting another layer on top of that, which is to create a date that is three working days after your due date. You can use the WORKDAY function for this:

 

=WORKDAY([Due Date]1, 3)

 

One important note on this is that formulas cannot be placed in date columns already being used for dependencies, as calculations are being performed on the backend.

 

More on the WORKDAY function is available in our Help Center: https://help.smartsheet.com/articles/775363-using-formulas#workday

saltyblueocean

Shaine! You're my hero! 

 

I cannot use these for dependencies, but can I create update requests based on this column?

J. Craig Williams

Salty,

 

Update Requests are not automated, you might instead look at Reminders which are based on date columns.

The person getting the reminder must be shared to the sheet.

 

https://help.smartsheet.com/articles/542913-using-reminders

 

Hpe this helps.

 

Craig