Is there a way to replace text with icon only...

(Jacob Danniel) #1

Is there a way to replace text with icon only?. if text is “YES” show icon only?

not icon AND TEXT


(Aleksi Alkio) #2

Not directly… but you can add that icon to another field and then hide that Y/N column. Is this doable for you?

(Jacob Danniel) #3

@Aleksi_Alkio yep thats fine, how do i go about doing that?

(Aleksi Alkio) #4

Add a new format rule with an expression [ColumnName]=TRUE (if it’s an Y/N field) and then option and column.

(Jacob Danniel) #5

@Aleksi_Alkio still kinda confused. could you break it down for a total noob/novice, thanks

(Aleksi Alkio) #6

Let’s assume you have two columns… [QUESTION] as Y/N field and [USER] as a text field. 1) Create a new format rule UX > Format rule 2) Choose correct table with “For this data” 3) In “If this condition is true” type [QUESTION]=TRUE 4) Choose the correct field from “Format these columns and actions” and in this case you would choose [USER] field 5) Choose the icon and color if needed 6) Save the rule

(Jacob Danniel) #7

Hey Aleksi this works 99%.

the new text field has to have some sort of text input in it to show the icon.

i just put a “.” and set color to white

see here

(Aleksi Alkio) #8

I was thinking you could format the existing column with the icon.

(Jacob Danniel) #9

Oh add the icon to my google sheets?

Ill try that. Thanks

(Jacob Danniel) #10

works like a charm, thanks

(Aleksi Alkio) #11

You’re welcome