Count unique values from a separate sheet

Options

Hello,

SmartSheet newbie here with my first question for the community.

We were able to build a working formula to count unique tickets in original sheet =COUNT(DISTINCT([Ticket #]:[Ticket #]))

I then took the above formula to my metrics sheet and changed to reference another sheet value and the formula no longer worked

=COUNT(DISTINCT({Unique Ticket #}:{Unique Ticket #}))

Error message received is Unparsable

Thank you all in advance for your help!

Alan

Tags:

Best Answer

  • Mark.poole
    Mark.poole ✭✭✭✭✭✭
    edited 05/31/24 Answer ✓
    Options

    @Alan House

    =COUNT(DISTINCT({Unique Ticket #}))

    The Reference should be the entire column already thus you don't need the :

    If you found this comment helpful. Please respond with any of the buttons below. Awesome🖤, Insightful💡, Upvote⬆️, or accepted answer. Not only will this help others searching for the same answer, but help me as well. Thank you.

Answers

  • Mark.poole
    Mark.poole ✭✭✭✭✭✭
    edited 05/31/24 Answer ✓
    Options

    @Alan House

    =COUNT(DISTINCT({Unique Ticket #}))

    The Reference should be the entire column already thus you don't need the :

    If you found this comment helpful. Please respond with any of the buttons below. Awesome🖤, Insightful💡, Upvote⬆️, or accepted answer. Not only will this help others searching for the same answer, but help me as well. Thank you.

  • Alan House
    Options

    Thank you for the quick reply, this correction helped pull over the total count of unique items.

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!