How to pull info into a cell

Beth Fantozzi 1

Hi! I would like to search the columns in a row and return whatever value is found on the row. Then I need to add the word "Project" in front of whatever value is found. What is the formula I would use for that? Here's a snippy of a sample of what I'm working on. What formula would go in the yellow column to return the values in the IL, PA, TX and NM rows?

Andrée Starå

@Beth Fantozzi 1

Try something like this.

=IF(JOIN(IL@row:NM@row) = "", "", "Project" + " " + JOIN(IL@row:NM@row))

Did that work?

✅Remember! Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up/Awesome or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

Andrée Starå

Hi @Beth Fantozzi 1

I hope you're well and safe!

Can there always only be one of the options filled or multiple?

Be safe, and have a fantastic week!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up, Awesome, or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

Beth Fantozzi 1

There will always be only one option that will occur. The information is entered via a form, using logic. If IL, then show those options, if PA, show a different dropdown selection.

Andrée Starå

@Beth Fantozzi 1

Try something like this.

=IF(JOIN(IL@row:NM@row) = "", "", "Project" + " " + JOIN(IL@row:NM@row))

Did that work?

✅Remember! Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up/Awesome or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

Beth Fantozzi 1

That worked great - thank you so much!!!

Andrée Starå

@Beth Fantozzi 1

Excellent!

You're more than welcome!

✅Remember! Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up/Awesome or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!