Is there a way to identify and highlight that a particular contact has overlapping dates?

Staff assignment sheet

I want to be able to highlight rows that have the same person assigned to overlapping dates. Assignment is a Contact list dropdown and the dates is a Date column.

Making mistakes is the fastest path to excellence.


  • Dave from JBM
    Dave from JBM ✭✭✭✭✭✭

    That's a tough one! the only solution I can think of is to use Gantt so you can visually inspect if there is any overlapping dates.

  • Andrée Starå
    Andrée Starå ✭✭✭✭✭✭

    Hi @John Michael (Mike) Munsil

    I hope you're well and safe!

    Is it one date or a range?

    • Have you explored using the Resource Management feature?

    Would that work/help?

    I hope that helps!

    Be safe and have a fantastic weekend!


    Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

    Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!


    Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

    W: | E: [email protected] | P: +46 (0) - 72 - 510 99 35

    Feel free to contact me about help with Smartsheet, integrations, general workflow advice, or something else entirely.

Help Article Resources