Bridge Error: When field from the source sheet is blank

MCorbin

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?

Genevieve P.

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.

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

MCorbin

@Genevieve P. You are my hero!!!! Thank You!

(and now to start playing with junctions) :-D Stay tuned for more questions.... hahahaha!

Genevieve P.

Haha, happy I could help! 😊