CONFLICT COLUMN (Shows where issues are when scheduling)

Paul Incitti 123

I have started to develop a CONFLICT column, that is, a column to show/ highlight where the same ASSIGNED TO/ RESOURCE/ MACHINE has been allocated on the same day, thus identifying potential conflicts in the schedule.

The columns counts the number of instances where the START DATE and ASSIGNED TO are the same and only for certain status's.

=COUNTIFS([Start Date]:[Start Date], [Start Date]@row, [Assigned To]:[Assigned To], [Assigned To]@row, [Start Date]:[Start Date], ISDATE(@cell ), Status:Status, "Not Started")

The only issue w/ this formula is that it does not show where ( I resolve this by filtering out to see which rows/ ops/ instances are causing 'conflicts'.

It would be nice to have a rows reference but I am not sure how to build this in.

However, the idea of a CONFLICT column would be a great function/ add on to have build in to smartsheets.