Formula: Track progress of checklists in a rich text field

[Martin_Malinda]

Hi! here's a formula that I used for tracking progress in a rich text field, maybe someone will find it useful, cheers!

( (LEN({Checklist}) - LEN(SUBSTITUTE({Checklist}, "[x]", ""))) / LEN("[x]") + (LEN({Checklist}) - LEN(SUBSTITUTE({Checklist}, "[X]", ""))) / LEN("[X]") ) / (LEN({Checklist}) - LEN(SUBSTITUTE({Checklist}, "[", "")))

https://www.linkedin.com/feed/update/urn:li:activity:7266910744263168000/

[Alexey_Gusev]

Hi,
similar topic discussed somewhere in the past, but it was several years ago, so it's a good time to review and remember simple but useful formula.
I just curious - what is the purpose of part  with 'upper X' ? To be honest, I didn't remember text sequence for enabled checkbox, just tried and get [x]. Do you know when [X] can be returned?


Anyway, I would simplify it from one side, but check for list to avoid NaN

IF(FIND('[',Checklist),
(LEN(Checklist) - LEN(SUBSTITUTE(LOWER(Checklist), '[x]', '[]'))) /
(LEN(Checklist) - LEN(SUBSTITUTE(Checklist, '[', ''))))

[Martin_Malinda]

> I just curious - what is the purpose of part  with 'upper X' ? To be honest, I didn't remember text sequence for enabled checkbox, just tried and get [x]. Do you know when [X] can be returned?

@Alexey_Gusev I included this so that you can also type `[X]`. It's unlikely scenario, most likely people would just type `[x]` but in theory someone could confuse the percentage by typing `[X]`. Unless I'm wrong and airtable converts that to `[x]` but I don't think that's the case!

---

---