Count unique values from a separate sheet

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

Find more posts tagged with

Formulas

Accepted answers

Mark.poole

@Alan House

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

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

All comments

Mark.poole

@Alan House

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

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

Alan House

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

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.