Flag for Overlap Meeting Time

I have created a sheet for meeting room reservation purpose with flag function if duplicate section found.

Details shown in picture "Question 1".

Question 1

May I know if there is any formula only flag the duplicate row with higher Row ID number?

Question 2

Current flag function only applicable to duplicate section(criteria is date_start time), i would like to flag it if meeting B overlap meeting A with same date but different start time. Please advise if there is any formula can solve this question.


Thanks

Joseph

Best Answer

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!