Can I replace numbers with symbols in an expression?

Hello, I have an inspection checklist and am wondering if I can replace the numbers generated in my expression with a symbol. Each column has it’s own expression that takes into consideration the columns before it. My expressions are doing exactly what I want them to do, I’m just looking to replace the result with a circled number symbol.

Column 1:
IFS
(ISBLANK([Check]),
NUMBER(""),
([Check] = “Yes”), TEXT(“✓”),
([Check] = “No”), 1)

Column 2:
IFS
(ISBLANK([Check 2]),
NUMBER(""),
([Check 2] = “Yes”), TEXT(“✓”),
([Check 2] = “No”), MAX(List([Check 1 Calc])+1)

Column 3:
IFS
(ISBLANK([Check 3]),
NUMBER(""),
([Check 3] = “Yes”), TEXT(“✓”),
([Check 3] = “No”), MAX(LIST([Check 1 Calc], [Check 2 Calc]))+1)

Output:
3X_6_9_69e235d781dac471951e2820cd9a634baf55e8df.png

What I want:
3X_d_b_db4316b798c3e64bf230584479da79417c2b9c95.png

There will be up to 50 potential symbols used. I have these numbers/symbols in another table and I was thinking of using SUBSTITUTE somehow and referencing them but I’m not sure how or if this is the right way to go about it.

3X_7_a_7a4dbd28277fa63ce9520dd681af7999c8a5ffae.png

Thanks!

1 1 455
1 REPLY 1

Steve
Platinum 4
Platinum 4

You can use emoji, but that’s the only option for including symbols in textual values.

Top Labels in this Space