Use this tag for Google Sheets questions that involve the use of spreadsheet formulas.
In a Google Docs spreadsheet, I'm looking for something like =EVAL(A1) where A1 is set to "=1+2". I found out …
google-apps-script google-sheets google-sheets-formula evaluateI have a large sheet with around 30 importxml functions that obtain data from a website that updates usually twice a …
google-apps-script google-sheets google-sheets-formula google-sheets-importxml gs-installable-triggersI'm trying this function on Google spreadsheet without success in order to gather in a sheet a value after a …
google-sheets google-sheets-formula google-sheets-query gs-vlookup importrangeHow do you get the literal value (the formula) from a cell instead of the result value? EXAMPLE DESIRED: A2: "…
google-sheets google-sheets-formulaI want to highlight the cell in column A if it is repeated anywhere in column B. For example: A | …
google-sheets gs-conditional-formatting google-sheets-formulaLet's say I have a column which has values like: foo/bar chunky/bacon/flavor /baz/quz/qux/bax I.…
regex google-sheets split google-sheets-formula re2Say I have 2 columns: (this is extremely simplified) Data = a number Result = Data * 1.2 I can put B2 = A2*1.2, then drag …
google-sheets google-sheets-formulaI have this spreadsheet with some data in column A - Date, column B (keyword usage on a specific date …
google-sheets google-sheets-formula forecastHere is what the spreadsheet I'm working with looks like: Summary table (top of sheet) Source data (same sheet, below …
google-sheets google-sheets-formula google-sheets-queryI'd like to grab the names in every person's name from this google spreadsheet and put it into a new …
google-sheets google-sheets-formula