Hello - I could use some help with a formula or automation to get what I'm trying to achieve to happen.We have job numbers that are coded as follows:23 = year1 or 2 = office identifier0001 = job number for the yearExample: 2310023 What I need to happ...

I have this formula to pull the time from a date/time column… DATETIME_FORMAT(SET_TIMEZONE({Submitted at}, ‘America/Chicago’),‘h:mm’) Is there a way to have AirTable recognize this as a number?

Here’s what I need, if someone would be so kind as to assist… I have a Submitted at column which tags the date/time the record was created from a form entry. I have a Completed column which tags the date/timestamp when the Completed box is checked, w...