Index Function Help

I am trying to index data by date and have applied the formula to the column. The problem I am running into is the last data entry is repeating to the end of the dates I have listed for the year even though those dates have not occurred and are not even listed on the sheet I am looking to.

=INDEX({Census}, MATCH(Date@row, {Date}))

What am I doing wrong or is there an easier way to pull this data? I pulled it to a separate sheet so that I could chart it by day without extra noise. Any advice is appreciated.

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!