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.

index formula.JPG

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!