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!
User | Count |
---|---|
18 | |
14 | |
11 | |
7 | |
4 |