I sent this as a feature request to Airtable support, but I thought I’d post here too. Perhaps there are other workarounds.
The workday_diff function doesn’t handle a blank value for the “holidays” argument. Currently a blank value causes an “#ERROR...
I sort of found a work around for this. You can use the matrix block. Choose your real lookup field for the columns. Then choose a second lookup field for the rows that has the same value for every record in the table. In my case I made a new table ...
I also want this feature. The simple example explains my use case as well.
Another way to look at this feature request:
Why would someone want duplicates in a lookup field?
Another more generic approach which would be cool (but probably would cause ...
