I'm getting an invalid Switch formula, even though it's super simple.I have several columns of singular date fields. Each date field is a milestone. I'm writing a simple Switch formula to check if Today() = one of the date fields, then if so say the ...
I can't seem to figure out how to loop a concate formula. I have 2 columns: Show Name and Episode Number. Show is single select and Episode is multi. My desired output is a string that loops the show name before the episode number; instead I only get...
Looking to convert this excel formula into an Airtable formula.
=TODAY()+7-WEEKDAY(TODAY(),16)
Details
We run payroll every 2 weeks, so we’d like to send a reminder on the Friday that timecards are due. So, if today is 7/21, the date in the cell sho...
@Ben_Young1 Thank you for the thoughtful reply.I had a feeling this would not be possible due to the array handling. However, changing the data structure for my use case is something that cannot be done. The input is coming from a Jotform, so if the...
