Formula Help!! Trying to pull text from a non-lank cell into helper column

Kishan Naik RA

Hey Smartsheets community! I am struggling on what I thought was an easy formula but I am completely stumped. Essentially I am trying to write a formula in the 'Current Statement' column that would look at the 5 statement columns to the right and pull in the comment from the most far right column with text

In the example in the screenshot, I would want the text in 'Community Statement' to show in the 'Current Response' column. If there was a row that had text in the 'Voice Statement' column, then I would want that to show up and so on. Any help would be appreciated, thanks!

Screen Shot 2023-04-04 at 4.39.08 PM.png

Andrée Starå

Hi @Kishan Naik RA

I hope you're well and safe!

Try something like this.

=IF([Heart Statement]@row <> "", [Heart Statement]@row, IF([Race & Ethnicity Statement]@row <> "", [Race & Ethnicity Statement]@row, IF([Voice Statement]@row <> "", [Voice Statement]@row, IF([Community Statement]@row <> "", [Community Statement]@row, IF([Intro and Values Statement]@row <> "", [Intro and Values Statement]@row)))))

Did that work/help?

I hope that helps!

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!

Kishan Naik RA

Thank you for the help Andree, that worked! I had the same example but in the IF statement I had = <>"" instead of just the <>"". Any idea why the equal sign is not needed and breaks the equation?

Andrée Starå

@Kishan Naik RA

Excellent!

Happy to help!

Yes, it's because the = is equal, and the <> is not equal. They contradict each other.

✅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!