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:
image

What I want:
image

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.

image

Thanks!

1 Like

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

2 Likes