Formula stopped working
I have a formula that was working and all of a sudden stopped working but no changes were made other than new rows added. The formula looks for duplicates in either the employee name or employee ID:
=IF(OR(COUNTIF([Employee Name]:[Employee Name], [Employee Name]@row) > 1, COUNTIF([Emp ID for duplicates]:[Emp ID for duplicates], [Emp ID for duplicates]@row) > 1), 1).
It works perfectly in our test environment but stopped working in our live production environment and now gives a #INVALID VALUE result. I've tried deleting the column, recreating it and copy/paste the formula from our test environment that is working and I still get the same invalid value message.
Any help or guidance would be greatly appreciated.
Help Article Resources
Check out the Formula Handbook template!