Using Bridge and Conditional Junction to evaluate if a Checkbox is Checked

I'm trying to set up a conditional junction in Bridge to evaluate whether a checkbox is checked. The checkbox is not manually selected; it's calculated using a formula in the Smartsheet row (e.g., =IF(COUNT(CHILDREN()) > 0, 1, 0).
When I use Get Row in the workflow, the checkbox field displays true when checked and false when unchecked, as expected.
However, when I try to evaluate this using an equal conditional junction with the following setup:
- First value: true
- Second value: the cell reference for the checkbox field
…it doesn't work as expected. Swapping the values (putting the cell reference first and true second) also doesn't change the result; it's still not evaluating correctly.
Has anyone else encountered this issue when working with formula-generated checkboxes? Is there a known limitation or workaround for evaluating formula-based values in Bridge conditions?
Frank Smith, PMP
Assistant Director | IT Special Projects Mgr.
Oregon Parks & Recreation Department
If my response helps, please mark it as an accepted answer. 😎
Best Answer
-
You'll have to use the "Match" junction. The "Equals" junction doesn't work for checkboxes.
So, switch out your junction for the Match and you'll be good to go.
Darren Mullen, Author of: Smartsheet Architecture Solutions
Get my 7 Smartsheet tips here
Take your Smartsheet knowledge to the next level and become an expert. Join the Smartsheet Guru Elite
Answers
-
You'll have to use the "Match" junction. The "Equals" junction doesn't work for checkboxes.
So, switch out your junction for the Match and you'll be good to go.
Darren Mullen, Author of: Smartsheet Architecture Solutions
Get my 7 Smartsheet tips here
Take your Smartsheet knowledge to the next level and become an expert. Join the Smartsheet Guru Elite
-
That's the ticket. I knew it was something simple, and I appreciate the help.
Frank Smith, PMP
Assistant Director | IT Special Projects Mgr.
Oregon Parks & Recreation Department
If my response helps, please mark it as an accepted answer. 😎
-
@Frank S. Thanks for the follow up. Yes, I've made the same mistakes with those junctions. "Equals" isn't the same as "Match" even though intuitively it seems like it would be ;)
Darren Mullen, Author of: Smartsheet Architecture Solutions
Get my 7 Smartsheet tips here
Take your Smartsheet knowledge to the next level and become an expert. Join the Smartsheet Guru Elite