Support weekends, holidays field reference in WORKDAYS(), WORKDAYS_DIFF()
T
Tully Lanter
The ability to specify weekends and holiday through Workspace Administration is terrific. However, we sometimes have different working days for different purposes (e.g., M-F in the office vs. M-Sa at project sites).
It would be terrific if WORKDAYS()/WORKDAYS_DIFF() supported weekend and holiday parameters, similar to WORKDAY.INTL() and NETWORKDAYS.INTL() in Excel and Sheets.
Better still, the holidays parameter could accept a column reference (something like [Holiday Calendar].[Date]) that covers an arbitrary number of years into the past/future.
Jon Darbyshire
Hello Tully Lanter! I have a few more questions for you:
- Can you provide examples of different working day schedules you use for various purposes?
- How do you currently manage different holiday schedules across your projects?
- Would you need the ability to update these schedules frequently, or are they relatively static?
T
Tully Lanter
Hey Jon Darbyshire! Happy to elaborate:
- The basic difference is that office staff work Monday–Friday whereas our on-site people work Monday–Saturday. I'm told that different project sites _could_ observe different weekends, but I haven't personally seen that.
- We store holidays in a named range in Google Sheets, then pass that range as a parameter to WORKDAY.INTL() and NETWORKDAYS.INTL(). This works great since we often need to generate schedules 3+ years in advance. (We're in commercial construction, so project timelines are quite long.)
- It depends. Office weekends won't change; project site weekends could change but normally don't (per point #1). Holidays should be the same for everyone, unless/until the government declares another.
Hope that helps!
R
Rebecca Kempfer
Jon Darbyshire
In addition to what Tully Lanter proposes I'd love to see the possibility to create custom work day / work hour models, that could be adpoted by the different Smartsuite users. In my company every employee has the ability to choose on which day of the week he or she wants to work how many hours. A new model or a switch of models doesn't occur too often, but it can change from one week to another.