count the total of requisitions

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


  • 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
    heyjay ✭✭✭✭
    =COUNT(DISTINCT(COLLECT([requisitions #s]:[requisitions #s], [requisitions #s]:[requisitions #s], ISNUMBER(@cell))))


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!