Picking next populated cell with formula

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

Reading:

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

Thank you.

Best Answer

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!