The Airtable Community will undergo scheduled maintenance on September 17 from 10:00 PM PST to 11:15 PM PST. During this period, you may experience temporary disruptions. We apologize for any inconvenience and appreciate your understanding.
Calculate checkbox (rich text) in Long text field
Topic Labels:
Formulas
Solved
Jump to Solution
3
6671
2
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
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.
