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.
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.
Hi @John Michael (Mike) Munsil
I hope you're well and safe!
Is it one date or a range?
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!
SMARTSHEET EXPERT CONSULTANT & PARTNER
W: www.workbold.com | 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.
Create and edit formulas in Smartsheet
Formula combinations for cross sheet references
Smartsheet functions list
©2022. All Rights Reserved Smartsheet Inc.