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

hclacken · 08/09/22

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.

Dan W · 08/09/22

=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 · 08/10/22

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 · 08/10/22

@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 · 08/10/22

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

Dan W · 08/10/22

@hclacken Capital N in the "No"

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

hclacken · 08/10/22

@Dan W

Thank you so much!!

Dan W · 08/10/22

Happy to help!

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

Answers

Help Article Resources

Categories