Help

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

Formula help for double booking

Topic Labels: Formulas
556 0
cancel
Showing results for 
Search instead for 
Did you mean: 
hockenberry2d
4 - Data Explorer
4 - Data Explorer

Hello!

I am trying to use a formula that will look at the resources that are selected for the job to see if they are double booked.

The formula will need to look at the resources column and then also look at the start and end dates column to see if the resource is booked on two different jobs on the same dates that it marks it as true or something so I can filter for conflicts.

In the attached picture both of those rows should be marked 'TRUE' in the formula field because the gray van is double booked over a period of the same dates.

Can someone help? Thanks!

0 Replies 0