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

Vicki Alkema

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?

Brett Evans

Vicki,

 

It sounds possible - or at least possible to improve the process somewhat.

 

Could you publish your sheet so that the details are apparent?   

 

Thanks,

Brett

J. Craig Williams

Vicki,

 

=IF(NOT(ISBLANK([column B]23)), your-join-formula-here, "")

 

or

 

=IF(ISBLANK([column B]23)), "", your-join-formula-here)

 

for column B, row 23.

Both work. The first looks for non-blanks, the second looks for blanks.

 

Craig

 

Vicki Alkema

Thanks Mr. Williams.  You are so smart. 

V

J. Craig Williams

Vicki,

 

Not as much as it may appear, but thanks for the compliment.

You are welcome. I am glad to help.

 

Craig