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.
Calculating complete dates with calendar days but....
I've brought this up before and at one point I thought that I found a great work-around. I would like to use calendar days in my date dalculations but, not have an end date land on a weekend. I created a complete column and with the use of a formula I tested the end date for a weekend and if it was a weekend I boosted it to Monday. However, the date calculation continues on with using the original end date. I know I can't place a formula on the calculated end date without turning-off Dependencies Enabled. It would be great if we had an option to use calendard days in the calculation and just not end on a weekend.