Welcome to the Smartsheet Forum Archives

The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.

Check if cell is empty then join.....

Vicki Alkema
edited 12/09/19 in Archived 2017 Posts

Hello, Friends. 

New user who like Smartsheet very much.  


Situation:  A general user provides input via the smartsheet form.  Once the form is submitted, column B is populated by a Smartsheet number generator (next sequence number).  Works great.  

I have built a JOIN which runs great manually.  I would like to run the JOIN only is column B is populated and the last 6 columns are empty. The JOIN derives what is placed in the last 6 columns.


I can run the join manually when column b is populated but I thought a little automation would be great.  Any help or should I forget about it?Embarassed. Use left and right arrows to navigate.


This discussion has been closed.