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.
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).
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
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!
@@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?
@@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.
Very informative tutorial .
Thank you!
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.
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).
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
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!
I have permission to al of the files but It still doesn't work.
Do you see any specific error message?
@@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?
@@coupleracademy do you have an email or support number to help? Call Google, I guess?
@@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.