Index and Match formula issue

Roland Schroder
edited 03/07/23 in Formulas and Functions

Hi All,

My colleague and I are trying to find the first occurrence of non-zero in a table and then return the corresponding month.

Example table

The formula that we are trying to work with is below, but whatever we try we keep getting an error of #UNPARSEABLE

=IFERROR(INDEX(January31:December31, MATCH(True, INDEX(January2:December2> 0, ), 0)), "")

Any help would be appreciated.


Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!