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/
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, '[', ''))))
> 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!
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.