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.