Calendar View - can't drag tasks when Due Date uses WorkDay function?
My SmartSheet has Task Due Dates that are calculated using the WorkDay function. For example, if a recurring monthly task is due on WorkDay 1, that calculated Task Due Date would become Monday, January 3rd, rather than Saturday, January 1st. Approaching the dates in this way makes it easy for us to rollover the Task List to the next month on a recurring basis, as the tasks are all due on a fixed Workday.
When I switch from Task View to CALENDAR VIEW, I'd like to be able to DRAG the various tasks around to different Task Due Dates, rather than having to go into each task to change its Workday, and then have SS auto-calculate the Task Due Date again. In other words, when working in the Calendar View, I want to do the reverse ... I want to change the Task Due Date and have SS in turn auto-calculate the WorkDay it is due.
However I am unable to do that, apparently because the Task Due Date is CALCULATED, rather than being a "hard entered" Task Due Date.
Anyway around this limitation?
I investigated a worksheet automation, but couldn't find a workaround
Help Article Resources
Check out the Formula Handbook template!