Formula or Conditional Formatting for Double Booking Staff on Gantt chart

JayKPM
JayKPM ✭✭
edited 08/01/22 in Formulas and Functions

Hello

Please find screenshot of the Sheet attached.

I would like to achieve one of the two options below preferably the first!

If one of the staff members is booked for the same day on multiple jobs to;

  1. Highlight both jobs and the fields which are causing the problem or;
  2. To give a red symbol in the "Valid" column

Can someone help me with either a formula or a way of adding this in conditional formatting?

Thanks in advance

Screenshot 2022-08-01 at 14.08.55.png


Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!