I feel like what I'm trying to do is simple but nothing is working.
I'm following this help article:
Copy partial rows to another sheet using a Bridge workflow | Smartsheet Learning Center
What I want to do:
When the column titled "Trigger Workflow" is changed to "Yes" It runs. It checks to make sure that the value is still Yes, and, eventually copies select columns to a new row in another Smartsheet.
What is going wrong
I can't get past the fist Junction. No matter what I do, that junction fails.
What I have tried:
First I had Trigger Workflow as a checkbox. I tried:
- Match: I tried to get it to evaluate against vales set to true, True, "true", and "True". It always detected false when the checkbox was checked.
- Equals: I tried the same, for hours, before reading in this community that Equals doesn't work with checkboxes. It would have saved hours if that fact was included in the documentation.
- Is Empty: It failed both when I tried to check against a checkbox as well as against a Yes option in a drop down. For the dropdown, I confirmed it was empty, with no spaces.
Here is a screenshot of the workflow. The comments are just so I could confirm the check is failing.
It is triggering and completing. Here is the data from Get Row. This is using a drop down and you can see that Trigger Workflow's value is "Yes".
Here is a screenshot of the Junction:
it is cut off in the image but the First Value is {{states.startstate.smartsheet.get_row.row.cells.Trigger Workflow.columnId}}
And the result… Even though the value is Yes, it still fails the check:
Bridge and its extensible and powerful workflows are what drove me toward smartsheet. But I've spent an almost unjustifiably long time on this. If I can't get Bridge to do something this basic, and directly covered in a step-by-step help article, I can't trust that I'll have success with the more interesting and nearly completely undocumented workflows I've got on the roadmap.
Any help would be greatly appreciated. Thanks you very much in advance!
