Creating a formula to add data together
The requirements are very much unclear. Based on the limited information available, the best solution I can think of is to use query() … Read more
Web Applications
How to transfer the ownership of a Google Sheets document to another account outside of the Google Workspace organization without losing cell history?
The method of cross-domain transfer with preserving file IDs using Google Shared Drives is well described here. Summary: Setup Google Shared Drive. Neutralize … Read more
Create shared Google calendar, sharing everyone’s events without showing details
Create shared Google calendar, sharing everyone’s events without showing details
Microsoft Account
Microsoft Account
Scripting to make Microsoft online apps talk to eachother
Scripting to make Microsoft online apps talk to eachother
Managing poll answer in a spreadsheet: grouping same questions
Welcome! Such a table transformation is not very complicated, it can be done with three simple formulas. Put the formula ={“User ID”;UNIQUE(A2:A)} in … Read more
Instagram – blocked account due to community guidelines (hacked) – with Facebook login – how to recover account?
Instagram – blocked account due to community guidelines (hacked) – with Facebook login – how to recover account?
IP of the devices that logged into a Google account
IP of the devices that logged into a Google account
Google Photos sometimes not allowing to copy text from picture
Google Photos sometimes not allowing to copy text from picture
Google Sheets Query with multiple and or statements
Named Ranges dates=”Addition Archive”!D:D archive=”Addition Archive”!B3:BC ingredient = C3 start = D3 end = E3 Formula to filter data by date =FILTER(archive, dates>=start, … Read more
