I also have permission to all of the files but It still doesn't work. It says #REF! You don't have permissions to acces that spreadsheet. learn more. Please help me
@coupleracademy2 ай бұрын
Sorry to hear you're having trouble! If you’re getting a #REF! error even with permission, try these steps: - Double-check permissions: Ensure you have "Viewer" or higher access to the linked sheet. - Re-authorize: Sometimes, re-adding the IMPORTRANGE function can prompt the authorization request again. Just enter the formula and allow access when prompted. - Try incognito mode: Sometimes, cache issues can interfere, so try it in an incognito window. If it still doesn’t work, there might be a permissions issue with the specific spreadsheet. Hope this helps!
@SpanishTownPHIZone23 ай бұрын
Hi, Would you be able to help me extract data from one google sheet to another if I have more than one columns with the same name and value? However what I would need to extract would be the most recent data that could be in either columns.
@coupleracademy3 ай бұрын
Hi! To do that, you can use the FILTER and SORT functions. Here’s a quick example: - Identify the columns: Use FILTER to get all relevant rows. - Sort by date: Use SORT to order by the date column, with the most recent first. - Extract the latest: Use INDEX to get the most recent entry. Example: =INDEX(SORT(FILTER(Sheet1!A:C, Sheet1!A:A = "YourValue"), 3, FALSE), 1, 1) This gets the most recent value from columns A to C where column A matches "YourValue" and sorts by the third column (date).
@WorkoutNerd32213 ай бұрын
I have permission to al of the files but It still doesn't work.
@coupleracademy3 ай бұрын
Do you see any specific error message?
@WorkoutNerd32213 ай бұрын
@@coupleracademy no it says "you need permission, learn more" I am the owner of all of the files, but maybe because the google drive is managed by my employer?
@WorkoutNerd32213 ай бұрын
@@coupleracademy do you have an email or support number to help? Call Google, I guess?
@coupleracademy3 ай бұрын
@@WorkoutNerd3221 Google typically does not offer live chat support for general inquiries or customer support issues. However, if you are a Google Workspace (formerly G Suite) customers, there is an option for live chat support available through the Google Admin Console.