I have two tables:
On Call RosterHolidays
I want to use the values from holidays in some formulas in On Call Roster. The Holidays are defined by Name and Date (no date range). The aim is to get them summed up so that I can use them as a parameter in ...
Support came back with a solution. Behind the scenes, the values from the lookup field are treated as an array, so if you wrap the reference to the lookup field in ARRAYJOIN it works.
So I’ve tried solving this a different way, but now I get a formula error with a description about what’s wrong. I have a lookup field that contains the following values (without quotes): 2019-01-01, 2019-04-22, 2019-05-1, 2019-06-10, 2019-07-21, 201...
