Picking next populated cell with formula

I'm trying to populate a cell (current email) using a formula with only one column being populated.


Populate cell "Current email" with either "email 1" @ row or "email 2" @ row or "email 3" @ row...

Thank you.

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!