
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Jul 15, 2020 06:14 AM
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 ?
Solved! Go to Solution.
Accepted Solutions

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Jul 24, 2020 07:09 PM
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.

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Jul 24, 2020 07:09 PM
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.

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Dec 07, 2022 05:41 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:
