Help

Extract/filter checked items from a rich text field

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

Hello, 

I'm trying to find a function that will pull all of the long text; rich field checked boxes away from any unchecked boxes. I've found the solution linked below and it worked great for the opposite problem. Does anyone have a formula to solve pulling only checked boxes? 

https://community.airtable.com/t5/automations/extract-filter-unchecked-items-from-a-rich-text-field/...

Subtasks are all our tasks. Next steps are unchecked tasks. Activity completed should be only checked boxes from the subtasks table. 

LindsayRidpath_2-1698445389700.png

 

Thank you!! 

 

@TheTimeSavingCo @Brian_LWA 

1 Solution

Accepted Solutions
Arthur_Tutt
8 - Airtable Astronomer
8 - Airtable Astronomer

Hey @LindsayRidpath ! a minor tweak to the RegEx solution posted by @TheTimeSavingCo  like this should fix it:

 

 

SUBSTITUTE(
  REGEX_REPLACE(
    {Subtasks},
    ".+([[\\s]].+)",
    ''
  ),
  '\n\n',
  '\n'
)

 

 

And a screenshot:

Screenshot 2023-10-27 233400.png

See Solution in Thread

2 Replies 2
Arthur_Tutt
8 - Airtable Astronomer
8 - Airtable Astronomer

Hey @LindsayRidpath ! a minor tweak to the RegEx solution posted by @TheTimeSavingCo  like this should fix it:

 

 

SUBSTITUTE(
  REGEX_REPLACE(
    {Subtasks},
    ".+([[\\s]].+)",
    ''
  ),
  '\n\n',
  '\n'
)

 

 

And a screenshot:

Screenshot 2023-10-27 233400.png

Thank you!!