Google Sheets - Limited # to choose from?

I have a Google Sheet that I am monitoring. When a row is updated, it uses values from that row to look up a row in a different sheet. (Totally different file.) I got the first part squared away - no issue. But I cannot find the second sheet in the spreadsheet box. I made sure that:

  • the account I am using has access
  • the sheet is in MY Drive, not a team drive

It’s in the same folder as the sheet I am using in the first step, but it just doesn’t show up as an option.

I figured out that I could get around this by going in and editing my sheet. It then popped up in the search box as an option!

This topic was automatically closed 24 hours after the last reply. New replies are no longer allowed.