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.
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:
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:
Oct 27, 2023 08:47 PM
Thank you!!