Formula or Conditional Formatting for Double Booking Staff on Gantt chart
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;
- Highlight both jobs and the fields which are causing the problem or;
- 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
Answers
-
You are going to have to use a formula on the sheet anyway to get Conditional Formatting to work, so we may as well leverage the "Valid" column.
=IF(COUNT(CHILDREN([Task Name]@row)) = 0, IF(COUNTIFS(Start:Start, @cell<= Finish@row, Finish:Finish, @cell>= Start@row, [Assigned To]:[Assigned To], @cell = [Assigned To]@row)> 1, "Red"))
From there you would set up conditional formatting to trigger off of the Valid column.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.8K Get Help
- 406 Global Discussions
- 218 Industry Talk
- 457 Announcements
- 4.7K Ideas & Feature Requests
- 141 Brandfolder
- 136 Just for fun
- 57 Community Job Board
- 459 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 297 Events
- 37 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!