+5Hello,
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!!
Best answer by Arthur_Tutt
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:
+19Hey @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:
+5Hey @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:
Thank you!!
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.