How to find if someone is assigned to two tasks on the same day?

FBowman

Good morning,

I have a sheet with due date in one column and team member assigned in another column. I want to ensure no one is assigned two tasks on the same day. I have exhausted my googling abilities and have come up empty. Any ideas here?

Paul Newcome

You are basically looking for duplicates. Try something like this in a flag type column:

=IF(COUNTIFS([Assigned To]:[Assigned To], @cell = [Assigned To]@row, [Due Date]:[Due Date], @cell = [Due Date]@row)> 1, 1)

Paul Newcome

You are basically looking for duplicates. Try something like this in a flag type column:

=IF(COUNTIFS([Assigned To]:[Assigned To], @cell = [Assigned To]@row, [Due Date]:[Due Date], @cell = [Due Date]@row)> 1, 1)

FBowman

Paul, thank you so much. That got me where I need to be.

Paul Newcome

Happy to help. 👍️

Lylikoi

I am new to Smartsheet, so I am still learning the ropes - can someone share a screenshot of the steps for completing the above suggestion for identifying if someone is assigned more than one task on the same day?

I tried just copying and pasting into a cell but received an error. TY!

Paul Newcome

@Lylikoi What error exactly are you getting?

Lylikoi

Hi Paul,

I am receiving #UNPARSEABLE. Given my newness to using this tool, I feel it is an error I am making when trying to use formulas. :)

Andrée Starå

Hi @Lylikoi

I hope you're well and safe!

Can you share some screenshots? (Delete/replace any confidential/sensitive information before sharing) That would make it easier to help.

I hope that helps!

Be safe, and have a fantastic week!

Best,

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, Awesome, or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

Paul Newcome

@Lylikoi Can you share a screenshot of the formula open in the sheet as if you are about to edit it?