Finding duplicates and checcking blank cells

Hi there,

I am at my wits end and I think it is a very easy solution, however I cant see it.

I have a column of project numbers, and I am trying to see if there are any duplicates, as well as if the project number cell is black, to leave it blank. What I have done is sort the project number column in ascending order and in another column I did e.g: =IF([Project Number]17 = [Project Number]18, "Duplicate"). This works fine, however I would also like to add a condition to check if the project number cell is blank. I have tried the formula in the picture, but the result is unparseable. Am I formatting he two conditions in a wrong way or what could the problem be?

Could you please help?

Thank you!

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!