About 1,580,824 results (3,960 milliseconds)
How do I locating all spreadsheets that are using (IMPORTRANGE ...
https://support.google.com/docs/thread/153211521/how-do-i-locating-all-spreadsheets-that-are-using-importrange-from-a-specific-sheet?hl=en Mar 2, 2022 ... Similar feature I missed from the excel days is tracing dependents of a cell to find where a formula points to, couldn't find that feature ...
Google Sheets function list - Google Docs Editors Help
https://support.google.com/docs/table/25273?hl=en Functions can be used to create formulas that manipulate data and calculate strings and numbers. Here's a list of all the functions available in each category.
How to trace dependents on Google Sheets? - Google Docs Editors ...
https://support.google.com/docs/thread/239805079/how-to-trace-dependents-on-google-sheets?hl=en Oct 18, 2023 ... ... All sheets" and "Also search within formulas" is checked. Click "Find" to find all instances of that cell. You'll have to hit "Find" multiple ...
Find all columns by name/heading? - Google Docs Editors Community
https://support.google.com/docs/thread/129340535/find-all-columns-by-name-heading?hl=en Oct 4, 2021 ... This formula in A1 gets all ... I only try to find this because this is for my friend and she's not well versed with excel/google sheet formulas ...
How to see formula calculation steps in Google Sheets? - Google ...
https://support.google.com/docs/thread/7547557/how-to-see-formula-calculation-steps-in-google-sheets?hl=en Jun 6, 2019 ... Instead, copy the formula to Excel and evaluate it there. Almost all of the formulas work the same or very similar. There are a few ...
Excel Formulas Not Working in Google Sheets - Google Docs ...
https://support.google.com/docs/thread/219934507/excel-formulas-not-working-in-google-sheets?hl=en Jun 8, 2023 ... Hello all,. I was wondering whether I could get some help with my budget spreadsheet. All of the formulas work perfectly in ...
Search and use find and replace - Computer - Google Docs Editors ...
https://support.google.com/docs/answer/62754?hl=en&co=GENIE.Platform%3DDesktop To replace the word every time it's used, click Replace all. Use find and replace in a spreadsheet. On your computer, open a spreadsheet in Google Sheets. Click ...
How do I communicate the request for a spreadsheet function ...
https://support.google.com/docs/thread/26771544/how-do-i-communicate-the-request-for-a-spreadsheet-function?hl=en Jan 26, 2020 ... using AppsScript is very annoying, for example i copy the sheet ,script execution permission required every time!!! ( of course I know it's ...
I am trying to find a formula that will search for information and ...
https://support.google.com/docs/thread/91993080/i-am-trying-to-find-a-formula-that-will-search-for-information-and-transfer-it-to-a-new-sheet?hl=en Jan 4, 2021 ... I would like a formula that found any instance of 'TX' in the 'State' column and add all of the information in that row to a new sheet.
Find and Replace - finds the string but when I want it replaced it says ...
https://support.google.com/docs/thread/39815474/find-and-replace-finds-the-string-but-when-i-want-it-replaced-it-says-that-it-can-t-find-the-strin?hl=en Apr 13, 2020 ... The Spreadsheet I couldn't get it to work had 2 sheets on it ... So, this sheet had formulas in every cell. What I just did was take ...
Google sheets wont display formula results, I only see the formula in ...
https://support.google.com/docs/thread/2758245/google-sheets-wont-display-formula-results-i-only-see-the-formula-in-the-cell?hl=en Mar 20, 2019 ... The issue with formula results not displaying is only happening for cells that reference a particular other spreadsheet. They were displaying earlier and now ...
Auto Update from another Sheet - Google Docs Editors Community
https://support.google.com/docs/thread/299305679/auto-update-from-another-sheet?hl=en Sep 29, 2024 ... It's an excel document ... I have edited the formulas on the sheet that is importing the data by using 1 formula to get all 4 columns of data.
Query function - find multiple names from one column in another ...
https://support.google.com/docs/thread/101461031/query-function-find-multiple-names-from-one-column-in-another?hl=en Mar 9, 2021 ... I am trying to wrap my head around an issue I am facing with the query function. Example Sheet. I want to find all the names in one column where ...
Formulas won't execute automatically after copy/pase - Google Docs ...
https://support.google.com/docs/thread/108993796/formulas-won-t-execute-automatically-after-copy-pase?hl=en May 7, 2021 ... One easy way to refresh all formulas is to use Edit > Find ... For additional tips on how to copy multiple sheets from one spreadsheet file to ...
Formulas not recognizing a certain column?!??? - Google Docs ...
https://support.google.com/docs/thread/58448228/formulas-not-recognizing-a-certain-column?hl=en Jul 11, 2020 ... The new formulas worked to calculate the balances in the other sheets. ... Hoping I find an answer to why the Totals for ALL Troops sheet works ...
How can I duplicate a sheet without losing any formulas and data ...
https://support.google.com/docs/thread/135560037/how-can-i-duplicate-a-sheet-without-losing-any-formulas-and-data-validation?hl=en Nov 16, 2021 ... The only option that I can think of, unless you want to get insto a scripted solution, is to move the second levevl of data validation ...
How do I show formulas in Google Sheets when working on an iPad ...
https://support.google.com/docs/thread/138503152/how-do-i-show-formulas-in-google-sheets-when-working-on-an-ipad?hl=en Dec 3, 2021 ... ... formulas" from the view menu. However, I can't seem to find this option in the app on my iPad. Is there a way to show formulas? Note that I ...
How to find unique values and tally them? - Google Docs Editors ...
https://support.google.com/docs/thread/41180423/how-to-find-unique-values-and-tally-them?hl=en Apr 19, 2020 ... I now have a spreadsheet with hundreds of names scattered in columns C-L. So... how many votes did everyone get? I would like to find all the ...
Formula to find number of times name has been entered into ...
https://support.google.com/docs/thread/119692475/formula-to-find-number-of-times-name-has-been-entered-into-multiple-sheets?hl=en Aug 2, 2021 ... I need to search all columns in the sheet being used, as well as sheets from previous weeks. If I enter Jeff Croswell into Sheet 8/18/21 in L:10 ...
HI!! How do I keep all my formulas when downloading a ...
https://support.google.com/docs/thread/113690173/hi-how-do-i-keep-all-my-formulas-when-downloading-a-spreadsheet-as-an-excel-document?hl=en Jun 15, 2021 ... I'm having trouble when I download a spreadsheet as an excel document. a lot of formulas disappear. Is there any way I can make sure they ...