Flag duplicates with conflicting dates
I have a list of names with a starting date and a finishing date. I am trying to get a formula that flags conflicting dates for the same person (duplicate). On excel I sorted with a SUMPRODUCT that I know smartsheet does not support. I have also tried to break it down so it adjust to smartsheet but I can't solve the problem of comparing 1 cell to a whole column.
Can anyone think of a solution?
Help Article Resources
Check out the Formula Handbook template!