Formula to populate a cell from 1 of many populated columns

Detrie Zacharias
Detrie Zacharias ✭✭✭✭✭
edited 12/09/19 in Formulas and Functions

I have 5 columns.

Only 1 of the 5 will ever be populated per row 

I need help with a formula to populate a cell with the value of the column that has a value. 

I tried =([Cell1]@row+[Cell2]@row+[Cell3]@row+[Cell4]@row+[Cell5]@row)

It seems to work but it gives me a leading zero


Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!