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.....
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?