Help

Calculate checkbox (rich text) in Long text field

Topic Labels: Formulas
Solved
Jump to Solution
5072 2
cancel
Showing results for 
Search instead for 
Did you mean: 
Kendy511
6 - Interface Innovator
6 - Interface Innovator

Annotation 2020-07-15 201146

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 ?

1 Solution

Accepted Solutions
Justin_Barrett
18 - Pluto
18 - Pluto

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.

Screen Shot 2020-07-24 at 7.07.16 PM

See Solution in Thread

2 Replies 2
Justin_Barrett
18 - Pluto
18 - Pluto

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.

Screen Shot 2020-07-24 at 7.07.16 PM

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

Need to know how many subtasks are marked as complete in a long text field? Learn the formula that gets the job done!