Formulas and Functions

Formulas and Functions

Ask for help with your formula and find examples of how others use formulas and functions to solve a similar problem.

Searching a series of columns for blanks

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

Trending in Formulas and Functions