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.

Auto Populate Due date

Options
Quece Goh
Quece Goh
edited 12/09/19 in Archived 2017 Posts

Hi,

 

I manage to get SS auto populate the due-date base on the start date. But is it possible to make the due date calculation is not including the weekend?

Example:

Start Date = 19 May 2017, Friday

Due Date is after 4 day of the start date, it should be 23 May 2017.

But becasue of the Sat & Sun, the due date should delay another 2 more days. So it should be  25 May 2017. 

Now i am using this formula to get my due date : =DATEONLY([Date Confirm]5 + 4).

Please help. Thanks

 

Cheers

Quece

 

Comments

This discussion has been closed.