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

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?

Find more posts tagged with

Project Management

Comments

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

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

Sign in to join the conversation!

Quick Links

Trending discussions