Help

Save the date! Join us on October 16 for our Product Ops launch event. Register here.

Re: If this formula help

864 1
cancel
Showing results for 
Search instead for 
Did you mean: 
Chafen_Suttle
5 - Automation Enthusiast
5 - Automation Enthusiast

I need help with a conditional statement working with dates.
So in the table there is a time slot however the conditions lie on the right where the start and end times actually are. So if a slot is taken at 10:30 for instance how would I formulate a statement saying if appointment time is between then “booked”

image

3 Replies 3

Hi @Chafen_Suttle,

Would you like to try:

IF(DATETIME_DIFF({start time},{end time},‘hours’)<DATETIME_DIFF({start time},date, ‘hours’),“No”, “between booked”)

Please text us back if it work finally.

Thanks
Dimitris Goudis

Hi Dimitris,

Thanks for your help. I tried it and I’m getting an error message. I tried to add a checkbox instead of a multi select as well but nothing.

https://airtable.com/shrPu54uRS75dttjZ

Maybe that will help make more sense to actually see it. Basically whatever appointment slot is selected an automation will mark extra time off before and after based on the other two fields so anything between them we need to change to not available or checked or something.

Hi there,

Please, put all your date fields in the same time zone, then check the results :winking_face: