I recently built new features into my project tracking base using Timeline view and WORKDAY calculation. In both cases the ability to include holiday dates is very useful. However I quickly found two cumbersome things about using this:
What would really help would be a feature where I could define lists of dates, then use the list references in my timeline views and workday calcs.
Thanks for considering it.
Solved! Go to Solution.
I just tried that for my workday formulas, but couldn't get it to work. The Time Off table is a nice enhancement on its own though just as a place to keep those standard lists.
With a lookup field referenced in the formula:
Back to using the text string in the formula:
Am not sure what I'm missing here. Tried putting both single and double quotes around the dates string, but that didn't help.