Bridge Error: When field from the source sheet is blank

Options
MCorbin
MCorbin Overachievers Alumni
edited 10/19/22 in Add Ons and Integrations

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?



Tags:

Best Answer

  • Genevieve P.
    Genevieve P. Employee Admin
    Answer ✓
    Options

    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