Duplicate value formula
I am trying to use a formula that will place a check mark in my duplicate check column if an invoice# in column 8 is a duplicate.
I was using the =IF(COUNTIF format but it doesn't seem to be working for me
Any recommendations
This is the formula I use & I keep getting an error of #UNPARSEABLE
=IF(COUNTIF([Invoice #]:[Invoice #]; [Invoice #]@row8) > 1; 1)
Answers
-
I think you need to give the IF a negative condition. As you have it, you only tell it what to put if the embedded COUNTIF is greater than 1. Also not sure why the you have the 8 in there after {Invoice #]@row.
=IF(COUNTIF([Invoice #]:[Invoice #], [Invoice #]@row > 1), 1, 0)
Regards,
Jeff Reisman
Link: Smartsheet Functions Help Pages Link: Smartsheet Formula Error Messages
If my answer helped solve your issue, please mark it as accepted so that other users can find it later. Thanks!
Help Article Resources
Categories
Check out the Formula Handbook template!