Identifying who is double booked in a meeting at a specific time and date

So I am trying to identify how to see who is duplicated and double booked at specific meeting slots. In the first two rows, you can see the duplicate flag shows up because it is the same exact people in the same order, but when i add "Jordan" on the 3rd row its not showing people are duplicate.

Is there a way to show who exactly is double booked at specific times? Like I want it to say return that at 3 -4 PM, Alex is in multiple meetings, so is Cami, and so on. We will be adding a ton more people to the list so this is just a basic version of it.

Answers

  • ro.fei
    ro.fei ✭✭✭✭✭✭

    To be honest, I recommend using another tool for this (Outlook, etc.) There might be a way to do what you're asking in Smartsheet, but it'll probably be complicated & tedious, & there are better tools out there for this. If you still want to integrate that information into Smartsheet, I'd look into Power Automate--they have flows that connect Smartsheet to a bunch of different applications!

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!