CountIF but not blanks

Hi everyone - sorry if this has already been asked and answered. But, i am trying to have a box checked if there is a duplicate entry. This is the formula i am using:

=IF(COUNTIF([FA Peoplesoft ID]:[FA Peoplesoft ID], [FA Peoplesoft ID]@row) > 1, 1, 0)

It works, but when i add the formula to the duplicate column all the way down the sheet it marks all blanks as duplicate - is there a way to exclude it counting blanks? We will be adding entries in time that we want the formula to apply to.


Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!