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.
Populate Date Column Based on Primary Date Column (taking into consideration workdays)
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
Comments
-
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
-
Shaine! You're my hero!
I cannot use these for dependencies, but can I create update requests based on this column?
-
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
