I have column with various duplicate values e.g. Duplicate Transaction ID, Duplicate name in Column
I want to segregate unique records from that column and display in another sheet/column
please guide how to do so ?
Hi @Shashi Yadav -- when you say unique record, are you saying you want to look at a list like this:
A
B
D
and get the unique values "A, B, D"? If that's what you want, then you can use the DISTINCT function. Here's a link to an article about the DISTINCT function:
DISTINCT Function | Smartsheet Learning Center
I hope this helps -- if not, you may want to include some screenshots to help us understand this ask specifically.
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.
