Lookup & Display First Non Empty Cell In A Range of cells within a column

I am attempting to write a formula in a header cell that returns the first Non-Blank row in a series within the related column.  Excel permits this by using the Index and Match formulas but requires that "CONTROL, SHIFT & ENTER" be pressed for the formula to work.  

When attempting this in SmartSheet, I receive an "#INCORRECT ARGUMENT" error message.  Sigh!

Any help here is appreciated. 

Thank you.

Screenshot 2019-06-11 11.20.50.png

Comments

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!