Skip to main content


I have a sub-task field (long text with rich text format- check box format)

I wanna Insert a field called “Processing” to calculate the % of sub task I have done (checked), which formula should i use for that ?

Sorry that this hasn’t had a response yet. Here’s a formula that will work:


IF(Subtasks, (LEN({Subtasks}) - LEN(SUBSTITUTE({Subtasks}, "}x", """))) / (LEN({Subtasks}) - LEN(SUBSTITUTE({Subtasks}, "}", ""))))

Format the field to show a percentage.


Sorry that this hasn’t had a response yet. Here’s a formula that will work:


IF(Subtasks, (LEN({Subtasks}) - LEN(SUBSTITUTE({Subtasks}, "}x", """))) / (LEN({Subtasks}) - LEN(SUBSTITUTE({Subtasks}, "}", ""))))

Format the field to show a percentage.



BTW, I recently released a video showing how this formula came together. Check it out to see some other options if the percentage isn't what you want:

https://www.youtube.com/watch?v=tTa5rwgOMwY

Reply


Terms & Conditions