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
Need more help? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao! 👋 | Global Discussions
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
Need more help? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao! 👋 | Global Discussions
-
@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! 😊
Need more help? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao! 👋 | Global Discussions
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.5K Get Help
- 424 Global Discussions
- 136 Industry Talk
- 465 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 145 Just for fun
- 62 Community Job Board
- 464 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 301 Events
- 39 Webinars
- 7.3K Forum Archives