- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Oct 27, 2023 03:24 PM
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?
Subtasks are all our tasks. Next steps are unchecked tasks. Activity completed should be only checked boxes from the subtasks table.
Thank you!!
Solved! Go to Solution.
Accepted Solutions
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Oct 27, 2023 08:42 PM - edited ‎Oct 27, 2023 08:42 PM
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:
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Oct 27, 2023 08:42 PM - edited ‎Oct 27, 2023 08:42 PM
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:
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Oct 27, 2023 08:47 PM
Thank you!!
