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:
What I want:
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.
Thanks!
You can use emoji, but that’s the only option for including symbols in textual values.
User | Count |
---|---|
18 | |
15 | |
10 | |
7 | |
4 |