Save the date! Join us on October 16 for our Product Ops launch event. Register here.
โ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:
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.
โ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
โ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
โ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.
โFeb 11, 2023 08:35 PM
Nevermind, just saw I was missing the workaround detailed in this post:
{Lookup Field}&""