Calculate checkbox (rich text) in Long text field

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.

Screen Shot 2020-07-24 at 7.07.16 PM

1 Like

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.