we are using smartsheet to keep track of community park passes. i have a column for name, account #, tag # and pass #. I need to be notified / alerted if an account gets more than one pass. Is there a formula that can check for a duplicate account number when the pass # cell is not blank? In the below picture, I sorted by division-block-lot; however, normally this will not be sorted in this way. I wanted to show that 6-39 was issued 2 different Annual Passes and should not have. I need an alert that will help prevent this, if possible.
Thank you in advance.
Help Article Resources
Check out the Formula Handbook template!