Automação #Pluga 2 - #GoogleForms & #GoogleSheets (Cadastros): https://youtu.be/NDCx5o9N4L0
Automação #Pluga 2 - #GoogleForms & #GoogleSheets (Cadastros): https://youtu.be/NDCx5o9N4L0
I used Google Sheets as a free VA. Here's how:
Read more https://lttr.ai/AgtvE
HYPERLINK! #Tip77 #excel #spreadsheet #googlesheets #sheet #cheat #usefultips #exceltips #hyperlink
Shorts HYPERLINK! #Tip77 #excel #spreadsheet #googlesheets #sheet #cheat #usefultips #exceltips #hyperlink Welcome to our ... source
Calishat: Temporary Obsessions RSS Feed Reader Updated and Now Available. “The Temporary Obsessions RSS Feed Reader is a Google Sheets-based tool that lets you schedule your RSS feeds and give them expiration dates. I have used TOFR for monitoring breaking news topics over the short-term, scheduling feeds in advance for a known business-/stock- related deadline, and to ‘audition’ keywords I […]
Fun with #AI:
I have a spreadsheet containing assignees, with various values on each line. I needed to calculate the sum of certain values for one assignee. This would normally be a simple query in #LibreOffice, but let's try using AI instead. I uploaded the spreadsheet to #GoogleSheets and entered a simple prompt in #Gemini: 'Give me the sum of XY values for assignee "name"' No result.
So I tried a more algorithmic prompt: 'Go through each line, and if the value in column XX is "name", count the value in column XY to the sum, and give me the total sum for all lines'.
The result? 150.
That's nice, but the simple query in LibreOffice gave me 27, which was the correct answer.
No matter how much I try, Gemini is completely useless in Google Sheets.
Structured tables YES but INSTEAD OF spreadsheets please, not overlaid
Für die Tabelle nehme ich noch Tipps entgegen. Ich baue das ja in #GoogleSheets, aber ich bekomme das nicht in #Airtable oder #Grist.
Versuche jetzt noch, was mit #DataTables zu bauen, aber wahrscheinlich scheitere ich. Am besten ein Tool, das #GoogleDocs einlesen und synchronisieren kann, aber hübscher aussieht. Sollte filtern und sortieren können, Gruppieren wäre auch noch cool.
Q: How does one change the *default* locale for newly created
#GoogleSheets in #GoogleDrive? I did a long-ish research and none of the advices on internet forums seem to help. I did change my preferred language & country for whole #Google account, but still see "Locale: United Kingdom" and "Time Zone: nothing" when creating new sheets.
(One of the) related #StackExchange questions: https://webapps.stackexchange.com/questions/142006/how-does-one-set-the-default-locale-for-each-new-spreedsheet-in-google-sheets