- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
โFeb 11, 2023 09:10 AM
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:
- I need to configure the list of dates separately in each place I use them, and since this quickly got employed in a few timeline views and a couple workday calculations there are now over a half dozen places where I need to make a change when adding a new holiday date.
- I am using two separate lists of holiday dates - sometimes I only put in standard US holidays for client facing views, whereas in other places I also include my own planned days off for internal capacity planning.
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.
Accepted Solutions
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
โFeb 11, 2023 07:24 PM
As a workaround, I have a table where each record represents a set of holiday dates and just use linked and lookup fields to pull it over to whichever table needs it, and then get WORKDAY to reference that
Not the prettiest solution but eh
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
โFeb 11, 2023 07:24 PM
As a workaround, I have a table where each record represents a set of holiday dates and just use linked and lookup fields to pull it over to whichever table needs it, and then get WORKDAY to reference that
Not the prettiest solution but eh
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
โFeb 11, 2023 08:32 PM
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.
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
โFeb 11, 2023 08:35 PM
Nevermind, just saw I was missing the workaround detailed in this post:
{Lookup Field}&""