Formula to pull the next populated cell in a column

Options

I am trying to have a formula pull in data from the next populated cell, I currently have a formula that pulls in by row. This sheet has rows that get copied over from different sheets and sometimes there are blank rows so I am trying to have a formula that takes that into account.

My current formula is =INDEX({Work Order Range 1}, 1) which returns "372" trying to figure out a way to write a formula to return 645. Any help is greatly appreciated. Thank you,

Brandon

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!