Formula to pull the next populated cell in a column


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,



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!