Get the column or collection index of a Matched value

earl_bennett
earl_bennett ✭✭✭✭✭✭


In the example below I am trying to get the array index of the matched value. I'm looking for the number in columns Jan - Dec where it equals the value in Current Month. I can find the value, but I need the position so I can derive the financial period the entry falls into.

Or better yet, how would I get the position of the last populated column?

image.png

Thank you,

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!