I need to calculate the number of days a ticket was open, but excluding weekends.However, Airtable wont let me change my work days to be Sunday-Thursday.What formula can I use as a workaround, to count all days of the week minus every Friday and Satu...
I am trying to create a formula to calculate the number of days a specific status is active. For example, how many days the ticket is "On Hold". The need is to calculate the number of days the ticket was actually active, in other words the difference...
@TheTimeSavingCo - So the ticket can go into an "on hold" status multiple times. I've managed to create a new record in a separate table with the date the on hold was created, each time the "on hold" status was chosen. However, I am struggling to fi...
