Help with Helper Column

EricC

I am using this formula to populate a summary sheet from a couple other sheets.

=INDEX({02. Bi-Weekly Status Updates Range A}, MATCH(1, {02. Bi-Weekly Status Updates Range 5}, 0), MATCH(Schedule1, {02. Bi-Weekly Status Updates Range 3}, 0))

There are also subsequent ranges associated with this formula. The first range is the one I seem to be struggling with. It references all the current contents of the "searched sheet"… It all works until I enter a new line of data on the "searched sheet" The helper column updates properly but my results show an invalid value until I go back in and select the range of all entries again. How do I make it search for the entire file every time? I have tried selecting row beneath where there is presently data, but that doesn't seem to work either. Thanks - I am not proficient at Smart Sheets obviously….

Paul Newcome

Select the first column header then hold down shift and select the last column header.

Paul Newcome

Select the first column header then hold down shift and select the last column header.

EricC

Thank you Paul… very humbling solution :) I really appreciate it, works perfectly!

Paul Newcome

Happy to help. 👍️