Indexing Stops Retrieving Data After Line 50


I have a master project directory that gets linked out to individual project schedules. One of the sheets that links data from the directory is for metadata only. The below formula has worked for the first 50 lines, but is now giving me #INVALID VALUE. I have verified with in the sheet I'm having issues that I can pull in data from the first 50 lines, but it will not retrieve data starting on line 51. Anyone have any ideas?

=INDEX({Portfolio Summary Data}, MATCH($[Project ID]@row, {Project ID}, 0), MATCH([Project Name]$1, {Portfolio Summary Header Row}, 0))

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!