About 1,833,967 results (2,930 milliseconds)
[SOLVED] Conditional Formatting Formula with Multiple Rules ...
https://support.google.com/docs/thread/59506052/solved-conditional-formatting-formula-with-multiple-rules?hl=en Jul 17, 2020 ... I think I need two formulas for one conditional formatting 'rule.' My sheet, which I cannot share due to privacy information, gathers purchase orders that are ...
How to combine 2 formulas with OR in one cell - Google Docs ...
https://support.google.com/docs/thread/5189281/how-to-combine-2-formulas-with-or-in-one-cell?hl=en Apr 30, 2019 ... I'm looking to combine them together with an "OR" operator (mark "yes" is EITHER condition is met). Whats the best method?
How do I combine multiple results of two filter formulas in Sheets ...
https://support.google.com/docs/thread/83739726/how-do-i-combine-multiple-results-of-two-filter-formulas-in-sheets?hl=en Nov 18, 2020 ... I have a spreadsheet from the Department of Labor. In in is the wages for all the careers they track broken out by state. The careers are signified with a SOC ...
2 Formulas in one cell? - Google Docs Editors Community
https://support.google.com/docs/thread/260333280/2-formulas-in-one-cell?hl=en Feb 23, 2024 ... ... spreadsheet as 14. Really that's all they need to know ... The & signs let you concatenate different sections of text (or formulas).
Apply two conditional formatting rules simultaneously in Google ...
https://support.google.com/docs/thread/13813522/apply-two-conditional-formatting-rules-simultaneously-in-google-sheets?hl=en Sep 7, 2019 ... My custom formula =$E2="Text" works fine but I'm wanting to essentially do the same thing for F2, but having the first rule in place always ...
How to combine two cells with an ARRAYFORMULA or with a ...
https://support.google.com/docs/thread/172052278/how-to-combine-two-cells-with-an-arrayformula-or-with-a-query?hl=en Jul 21, 2022 ... I have a number of columns with data on worksheet "leaf3". · In B7 (and further down) I have a formula that combines column B and C with a dash ...
How can I combine two filters (two different arrays with the same ...
https://support.google.com/docs/thread/201077986/how-can-i-combine-two-filters-two-different-arrays-with-the-same-condition?hl=en Feb 9, 2023 ... EDITED: I had extra clumns for testing, in my sheet, so my first post of the formula was wrong. Corrected now. Thanks, Ed! Thanks for sharing ...
Using Importrange to combine multiple sheets into one - Google ...
https://support.google.com/docs/thread/99340373/using-importrange-to-combine-multiple-sheets-into-one?hl=en Feb 23, 2021 ... I am currently trying to add multiple different sheets into one using the import function. The only problem is, when I do this, it comes up with the Formula ...
New instructions for using images in Autocrat.
https://groups.google.com/g/nv-autocrat-add-on/c/EYK0BONRxKI Then in the second new column put =arrayformula(SPLIT(E:E,", ")) I used two formulas to keep it simple. You could combine as you wish. See Example ...
How to combine two lists, matching some entries with slightly ...
https://support.google.com/docs/thread/159730268/how-to-combine-two-lists-matching-some-entries-with-slightly-different-names?hl=en Apr 13, 2022 ... I'd like to ultimately retain the name in (E:E) if possible, but if truncating the names makes it work, I could run a separate function to ...
How can I combine multiple IMPORTRANGE with QUERY to SUM ...
https://support.google.com/docs/thread/205825089/how-can-i-combine-multiple-importrange-with-query-to-sum-data-from-another-spreadsheet?hl=en Mar 12, 2023 ... I haven't finished looking into this, but the current error in your formula is that you are querying a virtual array that is only 12 columns ...
How to combine multiple (and not continuous) columns into one ...
https://support.google.com/docs/thread/11235039/how-to-combine-multiple-and-not-continuous-columns-into-one?hl=en Aug 3, 2019 ... The second formula does seem to add D3:3 onto A3:A. However, is there a way to ignore the empty fields? The way it's working now is creating ...
I need a formula to collect and combine scores from multiple google ...
https://support.google.com/docs/thread/282323628/i-need-a-formula-to-collect-and-combine-scores-from-multiple-google-forms?hl=en Jun 27, 2024 ... I often have daily exit tickets or bell ringers that I post as individual google forms. I have all the form responses in tabs in 1 ...
How Do I Add Up Multiple COUNTA Values? - Google Docs Editors ...
https://support.google.com/docs/thread/99781703/how-do-i-add-up-multiple-counta-values?hl=en Feb 25, 2021 ... I have been having issues trying to add multiple COUNTA values together. I tried to use SUBTOTAL, SUM, and COUNT formulas however I am running into parsing ...
CONCATENATE function - Google Docs Editors Help
https://support.google.com/docs/answer/3094123?hl=en string2 ... - [ OPTIONAL ] - Additional strings to append in sequence. Notes. When a range with both width and height greater than 1 is specified, cell values ...
Function to Combine Data in Multiple Cells on one Sheet to a Single ...
https://support.google.com/docs/thread/12617867/function-to-combine-data-in-multiple-cells-on-one-sheet-to-a-single-cell-on-another-sheet?hl=en Aug 23, 2019 ... I've tried Importrange, Query, Join, TextJoin. I'm familiar with formulas in Excel, just not these. The first tab is the way I'd like the info ...
How can I merge two cells in Sheets and keep contents of both cells ...
https://support.google.com/docs/thread/52208798/how-can-i-merge-two-cells-in-sheets-and-keep-contents-of-both-cells-with-a-comma-in-between?hl=en Jun 8, 2020 ... *Edited to add* I am not very savvy with formulas, as I almost exclusively use text data in sheets and haven't had much use for them. In ...
Adding a " " space to an ArrayFormula w/ a Concatenation - Google ...
https://support.google.com/docs/thread/113328378/adding-a-space-to-an-arrayformula-w-a-concatenation?hl=en Jun 12, 2021 ... My problem is that I can't figure out how to add the space to either of the two available formulas in Google Sheets (=Concat & = Concatenate) ...
Is there a way to merge spreadsheets (different url's) into one master ...
https://support.google.com/docs/thread/3109422/is-there-a-way-to-merge-spreadsheets-different-url-s-into-one-master-overview?hl=en Mar 27, 2019 ... Yes, you can combine multiple importranges into one formula. Try something like this. =QUERY({IMPORTRANGE("https://docs.google.com ...
How to merge multiple sheets with a query matching multiple dates ...
https://support.google.com/docs/thread/66797836/how-to-merge-multiple-sheets-with-a-query-matching-multiple-dates?hl=en Aug 24, 2020 ... Important to mention that not every sheet contains a record for every date, so the array function seems not the right answer to me (I assume) ...