Bridge Error: When field from the source sheet is blank
I've created a very simple workflow - copying data from one sheet to another when a row is added (just getting started). And I finally got the darn thing working - Yay!!
BUT: I just got this error - because the date in the source sheet is blank. How do I set it so that if that date is blank (or any field, for that matter), it just puts a blank in the cell in the destination sheet?
Best Answer
-
Hey @MCorbin
Were you able to sort this out?
In the Reference data in the workflow there's a section specifically on Options for empty data references that should help!
In the reference, add || to the end, then add a space. For example:
{{states.GetRow.smartsheet.get_row.row.cells.Licese.Approved.value|| }}
This will tell the reference that if the original cell is blank, look at the other side of the bars (||) and put that value instead. Since you add a space after the bars, then it should input a blank cell again.
Let me know if this works for you 🙂
Genevieve
Answers
-
Hey @MCorbin
Were you able to sort this out?
In the Reference data in the workflow there's a section specifically on Options for empty data references that should help!
In the reference, add || to the end, then add a space. For example:
{{states.GetRow.smartsheet.get_row.row.cells.Licese.Approved.value|| }}
This will tell the reference that if the original cell is blank, look at the other side of the bars (||) and put that value instead. Since you add a space after the bars, then it should input a blank cell again.
Let me know if this works for you 🙂
Genevieve
-
@Genevieve P. You are my hero!!!! Thank You!
(and now to start playing with junctions) :-D Stay tuned for more questions.... hahahaha!
-
Haha, happy I could help! 😊
