Searching a series of columns for blanks

Josh Jereczek
Josh Jereczek ✭✭
edited 12/09/19 in Formulas and Functions

Hey all.

I am trying to have a column search a series of columns and return the data from the column that is not blank.

I have started with the following:

=IF(NOT(ISBLANK([Title:]1)), [Title:]1, [Peer to Peer Program Title]1)

Which checks the Title column, and if not blank returns the data from Title: column. If the Title: column is blank it returns the value in the Peer to Peer Program Title column.

This works just fine, but I want to go a step further, and if the Peer to Peer Program Title is also blank, I want it to return a value from a third column. I tried to make this work with nested IF statements, but kept getting errors.

Β 

Thank you!

Comments

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!