Identifying Duplicate Values through Conditional Formatting

Smartsheet Community Members -

I'm using Smartsheet (Forms) to manage system access requests. Users provide their Username and to which System(s) they need access.

I'm trying to employ conditional formatting so I can easily identify which requests are duplicative based on whether a request already exists for the same Username AND for the same System(s).

Experts of Smartsheet - What is the best way to approach this? IF + COUNTIF?

Cheers & Thanks in advance for your help!



Best Answers