Duplicate Helper column with filter
I'm trying to build a formula where I search for duplicates within one column (Job Numbers) but only if "Invoice" has been selected in another column (Deliverable Type). I was able to get a formula to search for duplicates working but it is searching all the deliverable types, but I just need to know if there is more than one invoice submitted with the same job number. Thank you!
Help Article Resources
Check out the Formula Handbook template!