count the total of requisitions

System

This discussion was created from comments split from: Formula for Duplicates.

Paola Preciado

Hello!

I have a similar question, I have a column that have "requisitions #s" and some of them are in the column more than once. I want to count the total of requisitions. I am new to Smartsheet, so I believe it would be just "count formula" , but how can I write the formula to give me a total of requisitions (leaving duplicates out). For example, If requisition #2353 is in the column 4 times, I want to count it just as 1.

Thank you.

heyjay

=COUNT(DISTINCT(COLLECT([requisitions #s]:[requisitions #s], [requisitions #s]:[requisitions #s], ISNUMBER(@cell))))