How can I make some data on a Google Sheets auto-sorting?
Aug 1, 2012 · Let's say I want Google Sheets to automagically sort some data, for example column C. How do I do that? I know that I can manually sort data by right-clicking and …
Google Sheet combine rows with same date
Dec 27, 2023 · I'm loosing my mind with problem in Google Sheets. We are using Appsheet to insert data for daily revenue for different services. So rows are days and columns are services …
Writing an Array from Apps Script to Google Sheets
Feb 19, 2023 · I have been out of coding for a while and have forgotten much. I am attempting to read data from a selection of cells from one page and then write it to another section if it meets …
Setting up decimal separator, thousand separator and date in …
Dec 22, 2017 · Is there a way to change settings of decimal separator, thousand separator and date format in Google Sheets? I would like to have: dots for decimal, space for thousand date …
How to generate a random string? - Web Applications Stack …
Feb 9, 2015 · I need to create a random string of 8 characters for every row in Google Spreadsheet. Basically string should contain letters and numbers upper and low case only, …
Insert image from Google Drive into Google Sheets
Oct 30, 2015 · How do I insert/link to images existing in a folder in Google Drive into a Google Sheets spreadsheet? There is the image () function, I imagine using it something like this: …
google sheets - Web Applications Stack Exchange
Apr 11, 2023 · I am cataloging items in a spreadsheet using Google Sheets. Every item needs a unique ID, which is a sequential code formatted like ABxxxxxx, where AB000000 < …
Can I have a drop-down list appear in a cell only if another cell ...
Oct 31, 2021 · What I mean by this is that I want a cell to show a drop-down list (the only kind I know of is from Data Validation) only if another cell (NOT containing Data Validation/drop …
Is it possible to refer to a whole column in Google Spreadsheets …
No, but you can work around it, by knowing which row is the last row with data in a column, using the COUNTA function. INDIRECT("A1:A") could be written something like …
Convert all text to UPPERCASE in a Google Spreadsheet
Aug 19, 2018 · I have a spreadsheet I'm sharing with others to collect some data. Each person is just (supposed to be) putting a single character in any of a range of cells. How can I cause …