I need a formula to look at a contact list and a checkbox column and return a flag if the person is
I have a contact list for employee of the month nominations. When the employee is selected for employee of the month, a box is checked. I have another checkbox column set to flag. I need a formula that will flag the rows when a person is selected more than once for employee of the month. I have been racking my brain and tried several different options. I cannot get the flag to work properly. either it flags if the person is in the list more than once, or it flags everyone selected for EOM.
Help Article Resources
Check out the Formula Handbook template!