Hello ~ I am creating a couple columns to be able to identify duplicates with Name entries and Job Posting entries. However, when creating the formula for the "Duplicate" column I see that it is not flagging the duplication. I believe it may be in the way I have written the formula and was hoping for some guidance.
=IF(AND(COUNTIFS([Duplicate Name Check]:[Duplicate Name Check], [Duplicate Name Check]@row, [Duplicate Job Posting Check]:[Duplicate Job Posting Check], <>"") > 0, [Duplicate Job Posting Check]@row = ""), true, false)
The area where I put in bold I think may be my issue but not 100% sure. Below screenshot is where I put the formula (just in case curious).
Thank you!! 😄
Help Article Resources
Check out the Formula Handbook template!