Dependency Setting

Greetings,
I have a Smartsheet (Smartsheet A) with multiple date columns. These dates have been added using various formulae. I also link some of these dates into a master sheet (Mastersheet A)Β that consists of a Gantt Chart.Β
The dependency settings on the Mastersheet AΒ with the Gantt chart is such that there are only 5 working days (Monday through Friday). However, the dependencies on Smartsheet A have not been enabled. Adding dates in Smartsheet A using a formula also takes weekends into account.Β
Now when I link the dates to the Mastersheet A, only weekdays appear. To work around this, I enabled the dependencies on Smartsheet A,Β selected only 5 working days and re entered all my formulae (refer to picture: dependency setting). in the date columns. I also have two temporary date columns in the same sheet,Β temp s and temp e, where dates can be entered manually.Β
However, on entering the formulae after changing the dependencies, weekends still appear (picture: weekend_dependency). How do I stop this from happening ?
The next issue I have is, with the dependency enabled, Weekends appear on the temp s (in smartsheet A) column even though they shouldn't. (refer to picture: Weekend_start_date).Β
Β
I really need for weekends to NOT be taken into account in my primary sheets, so that the dates in them can match the dates when I link them on the Mastersheet.Β
Β
Is there any work around ?
Β
Thank you
Β
Β
Β
Comments
-
Hello,
Non-working days will still appear in the calendar picker, but non-working days and holidays aren't included in duration calculations. Also, tasks and milestones can be scheduled manually to start on a non-working or holiday, but end dates can't occur on these types of days.
I'd suggest submittingΒ aΒ Product Enhancement RequestΒ to let our Product team know that you'd like to have this functionality in Smartsheet.