Hi everyone,
I am trying to use a formula that works for me in GoogleSheets, and convert it to be AirTable friendly. :slightly_smiling_face:
IF({Event Type}=“Pickup”, (IF(TODAY()-{Event Date}<=0,“P/U”, IF(TODAY()>={Return Date},“RET”, “ABS”))),{Eve...
Perfect! I would not have thought to use DATETIME_DIFF. Thanks for the suggestion.
I added a > to the event date portion of the formula so that it would only show ABS between the P/U and RET dates, but other than that, your formula did exactly what I...
Hi Danny,
Thanks so much for the speedy reply! :slightly_smiling_face: Your formula works beautifully, THANK YOU!
I have one more question for you though… when I select “include a time field” in the date column, the results always shows “ABS,” I a...
