Google Sheets - Limited # to choose from?

Need help
1

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.

2

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!

3

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