Notice: As a way to use ImportRange, you must have already been included for a viewer or collaborator for the spreadsheet from which ImportRange is pulling the data. In any other case, you'll get this mistake: "#REF! error: The requested spreadsheet critical, sheet title, or mobile selection wasn't observed." كما https://casestudyhelp81667.csublogs.com/44629594/detailed-notes-on-case-analysis