I need to combine/create a formula that calls an icon

The below formula searches for duplicates in a column labeled 'pin' and adds a one to a 1 to a column named flag when duplicates are found.

=IF(COUNTIFS(Pin$1:Pin@row, Pin@row) > 1, 1)

I need a formula that does this but turns the 1 into a smartsheets symbol or maybe the word 'duplicate'; I have tried various ways and have yet to find a way that works.

Find more posts tagged with

Formulas

Accepted answers

All comments

Dan W

=IF(COUNTIFS(PIN$1:PIN@row, PIN@row) > 1, "Duplicate")

Or you can change the column the formula is in to a check box/ flag type column and leave it as you had it

hclacken

https://community.smartsheet.com/discussion/comment/339068#Comment_339068

This works, thank you! question: is there a way to change this to a symbol or can I only do words/numbers? Thank you so much

Dan W

@hclacken

You can use this with the symbol type column. When you select what set of symbols you want just pay attention to the "Names" of the symbols.

Example, If you chose the arrow symbols and you wanted it to show arrow up it would be

=IF(COUNTIFS(PIN$1:PIN@row, PIN@row) > 1, "Up")

Hovering your mouse will show you the names of the options,

hclacken

@Dan W , when I do this, it only shows the word, not the actual symbol. Am I doing something wrong?

Dan W

@hclacken Capital N in the "No"

=IF(COUNTIFS(Pin$1:Pin@row, Pin@row) > 1, "No")

hclacken

@Dan W

Thank you so much!!

Dan W

Happy to help!

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.