All Questions
30,858
questions
0
votes
1answer
40 views
Sum values across multiple Sheets IDs automatically by creating a formula?
I used this post to have all Google Sheets IDs in a folder
Getting all files' file-id from a folder in Google Drive
I would like to make a formula or script to sum values in table across all these ...
0
votes
0answers
5 views
How to find Udacity course creation date
Any idea of how to find the creation date of an Udacity course?
0
votes
0answers
4 views
Pre-cache a complete website and force offline access even when I'm online [migrated]
During work there are a lot of documentations and references on various websites that I have constantly opening during the day.
Is there a way in chrome to pre-cache a full website so it becomes ...
0
votes
1answer
20 views
Can you filter a column in size order of an imported HTML? I have tried using query with no success
Using the below importhtml I'm hoping to order the numerical data of the third column in size order, but it seems I have lost my way on the model I was following. Any help greatly appreciated.
=...
0
votes
0answers
32 views
Why does the archive.org of most YouTube videos fail with “Sorry the Wayback Machine does not have this video (<id>) archived (or not indexed yet)”?
I have seen several videos which show as archived, and video metadata does show up, but the video itself doesn't with a magic error hacked into the rendered page:
Sorry the Wayback Machine does not ...
0
votes
0answers
13 views
I need help with my comments on YouTube
So these past couple of days whenever I try to reply to someone's comment on YouTube, I can see my reply when I'm logged in but when I log out or when I try to view it from a secondary account the ...
0
votes
0answers
31 views
I have a Google Form that feeds into a Google Sheet. I need to pipe that information into another tab/cell in a dynamic way based on a data validation
Lets see if I can explain this well enough...
I have a spreadsheet "Main_page" that is dynamically pulling information from a secondary sheet, "All_shots". I also have 2 google ...
0
votes
0answers
7 views
Can we define our G-suite admin to be local admin inside all the managed devices and login without using Google credential provider for windows [closed]
We have the following:-
G-Suite Basic edition.
55 windows 10 pro machines.
now we have installed Google credential provider for windows inside the windows 10 PCs so users are accessing their PCs ...
1
vote
0answers
13 views
Within a “Shared Drive” in Google Workspace, how can I share a video that starts at a specified time?
Within a "Shared Drive" in Google Workspace, how can I share a video that starts at a specified time? Solutions posted previously on this forum do not work.
I have uploaded a video to a ...
0
votes
1answer
30 views
Sum over a formula in Google Sheets
I have a Google Sheet and I need to add a lot of stuff like
(ABS(A1)+A1)/A1+ (ABS(A2)+A2)/A2+...+ (ABS(A10)+A10)/A10
but I don't want to write out the sum each time for each term A1,A2,A3,..., A10
Is ...
0
votes
0answers
12 views
Can not write on Facebook Wall of ANY of my 284 FB friends from iPhone
I am not any to write on any of the walls of my 284 FB friends from my iPhone, but I am able to write on their walls from my PC. Is there a setting on the iPhone or in FB to fix this?
0
votes
1answer
39 views
In Google Sheets, how would I go about finding column header of a filter result from another tab?
I have a simple form in one tab with a couple entries.
On another tab there is a filter that automatically populates array based on form tab.
Is there a simple way to reference a column header of a ...
0
votes
0answers
5 views
After installing Google Credential provider for windows, the user is getting this on the login screen "This device is not yet enrolled [migrated]
We install Google Credential Provide for Windows inside Windows 10 pro >> but when the user login to the PC the user will get this error/message:
any Advice? and it is normal to get this error/...
1
vote
1answer
38 views
AVERAGEIF on last N rows
This seems pretty simple but I can't find how to do it.
I keep a Google Sheet where I add several times a day new lines as following :
| A | B | C |
| --- | --- | --- |
1 | John | 10 | ...
2
votes
2answers
22 views
Is there a way to “mark as read” or “important” in Google Drive?
I've been given shared access to a Google Drive folder that contains a large number of subfolder and files. Most of this is electrotechnical documentation.
However there's so much to read and not all ...
0
votes
0answers
29 views
Forward an email without creating a new message in the thread about the email being forwarded
I'm automatically forwarding all my emails from my secondary Gmail account to my main one, using the feature in the "Forwarding and POP/IMAP" setting page.
My secondary account received a ...
1
vote
1answer
20 views
Add '/' character in between a number (which should be formatted as a date) and turn it to a date
I have received a spreadsheet which has the dates formatted with only numbers without separators and I would like to transform them into a date format. For example, I would like to change the number ...
-1
votes
0answers
13 views
How to stop spammers comments on my WordPress blogs?
I have WordPress blogs, and found so many comments posted by spammers. How can stop this?
1
vote
0answers
22 views
How to add labels and forward an incoming email in one click?
I forward every invoice received by email (in Gmail) to my accounting platform. Also, I add a couple of labels/tags to these emails to keep track of the processing.
Does Gmail allow me to create some ...
1
vote
0answers
60 views
How can I find my Outlook account using phone number only
I have created my Outlook mail before 2.5 years. Now I have forgot the email and password. I have only mobile number with me what I used while created account.
I have tried this link:
https://account....
0
votes
0answers
7 views
How to set Twitter trends in Ukrainian language?
I am geographically in Ukraine and I tried to set trends settings "Show content in this location" "Trends for you", but I only see trends in Russian. I do not follow any accounts ...
-2
votes
0answers
4 views
Am a beginner and I want to get an API template on banking website, with the features of Crypto trading in it [closed]
Please kindly help with an API template on a banking website that will have features for Crypto trading too
1
vote
0answers
14 views
Google Sheets: a cell calls an API for a changing currency price, but sometimes returns an error. How do I keep the last non-error price?
I'm using importJSON to grab a number that represents the current price of a currency. Sometimes, the API isn't available and returns an error message. Is there a way for me to record the last non-...
-1
votes
0answers
6 views
Help Need: HTML Canvas dynamic chess board; Algorithm problem [closed]
So, I'm learning image manipulation with canvas, so I decided to make a simple chess board with simple scalping dynamics. There seems to be a logical error somewhere cause this is the result of the ...
0
votes
1answer
24 views
Too Many IF Statements in Google Sheets
I am trying to get this formula to not come back with an error. As far as I know, I cannot make a VLOOKUP chart in Google Sheets because of it looking at multiple cells to give out the value. It ...
0
votes
0answers
11 views
What are the mobile devices and EndPoints inside our Google admin site [closed]
We have G Suite Basic subscription, and we have 55 users registered inside the G suite. now today using the G suite Admin I access the Google admin page and I found that we have endpoints and Mobile ...
-1
votes
0answers
10 views
Can i use Google Credential Provider for Windows (GCPW) with windows 10 home edition [duplicate]
We are a startup company and we have the following:-
we have around 50++ PCs which use Windows 10 home edition.
we have google G-Suite Basic subscription as follow:-
and we want to install Google ...
0
votes
0answers
19 views
Is “Google Credential Provider for Windows (GCPW)” available for G Suite Basic [closed]
We have G-suite basic :-
so i am not sure if i can use "Google Credential Provider for Windows (GCPW)" ? or i need to upgrade the subscription to be able to benefit from "Google ...
0
votes
0answers
12 views
How to send an automated response to a blocked email in Yahoo!
I am currently using Yahoo! mail. Once I block someone, I don't receive an email from them. However, I want to send an automated reply to them as well to let them know that I have not received the ...
0
votes
0answers
21 views
Reading an address function in an offset function
I'm having trouble with the offset function, it doesn't seem to read address functions.
Prompt:
Read down the health column of the Monster Statistics by Level table until you find your monster's HP. ...
0
votes
0answers
3 views
Looking for Google Calendar & iPhone
I now have an iPhone XR and I am sharing Google Calendar with a friend, that person also has the iPhone XR. I seem to have everything working, other than my "Reminders". We both previously ...
0
votes
0answers
19 views
Using WHERE VLOOKUP in QUERY function in Google Sheets
I have a big table which is composed of a bunch of date-stamped data sets (monthly reports). I want to compare products' metrics between last time it was updated and the time before that. However I ...
0
votes
0answers
6 views
How to conditionally lock the result of a formula in Google Sheets
I've got a formula that uses data that frequently changes.
Is there a possibility to conditionally lock the result, so that even if references of the formula changes, the result does not change?
So ...
0
votes
0answers
5 views
How AUTO ROUTE between source(your location) & destination when lose blue path in google maps [migrated]
I am using google maps installed on my android's phone in my car.
I chose blue icon on right bottom of google maps.
I set my location as source & my friend's home address as destination.
After ...
-1
votes
0answers
3 views
How can I see who a file or folder is shared with on Amazon Drive [closed]
On Amazon Drive I have shared some folders and files with others but I cannot remember with who - how can I find out who I shared these files and folders with on Amazon Drive?
0
votes
0answers
19 views
How to change language of location names in Google Maps [migrated]
It seems Google Maps recognizes my Android's phone language & configs itself based on that language.
My phone language is English.(But this is not my local language).
So Google Maps shows all ...
0
votes
0answers
9 views
Issue in importing citations to EndNote via Google Scholar
I am trying to import citations from Google Scholar to End note using this.
All worked well except the last step of importing, where Google Scholar is giving an Error 403.
Your client does not have ...
1
vote
0answers
21 views
How can I stabilize several of my YouTube videos at once? [closed]
I uploaded 100 .mp4 video files on YouTube. I now want to stabilize all of them using the YouTube video stabilizer feature. Is there any way I can stabilize all of them at once?
I tried searching the ...
1
vote
0answers
29 views
How to limit selection of dropdown list to single/multiple items based on value of a cell?
I have a spreadsheet of the list of patients daily.
Each patient has been classified in disposition column(Q) as Admission, Consultation or others...
Column R is Specialty. Column S is Services
There ...
0
votes
0answers
13 views
Why can't I upload a small .mov file to my Facebook story?
I created a .mov file with final cut pro (720x1280|30p), exported with H.264. Now when I follow these instructions for adding a video to my story, when I click on Create a Photo Story, I'm presented ...
0
votes
1answer
34 views
Sum Last 12 Columns In Google Sheets
I'm trying to track my recent 12 months spend on an ongoing basis. Each month a new column is added for the new month, but I want Column B to show the sum of the most recent 12 months.
I've set up a ...
0
votes
0answers
17 views
Get YEAR Month# MonthName from DayOfWeek
This results in a nice table of sorted weekday, number of those weekdays and total from values in column A like 01/01/21 and column D like 123
=QUERY(Query(A2:D, "select (A), sum(D)
...
0
votes
0answers
14 views
Submission time removal
I am looking for a way to remove the submission date/time from the items seen when looking at entries in the Cognito forms. I have multiple employees that I am ok with them working after hours but the ...
0
votes
0answers
14 views
query: SELECT something WHERE [an array] CONTAINS something else in Google Sheets
I'm using Google Sheets as the backend for a no-code dev environment (Glide). I am trying to query an array rather than a single column.
Here's my formula that works for looking in just one column (L):...
0
votes
1answer
33 views
How to not show order summaries on top of Gmail emails
Gmail has started showing what it thinks is a useful summary at the top of emails which contain online order info. Usually this is just visual clutter to me and I have to scroll past it to see what I ...
0
votes
1answer
14 views
How can I highlight a column of cells (H) if the date in the cell is more than a week old, and the cell next to it (I) is blank?
I'm trying to make a spread sheet to track open purchase orders. One PO per row. One column has the order date in it, and the next column has the receive date for the order. I'd like the cell with the ...
1
vote
0answers
23 views
Keep cell value same if condition is not met
Set-up
I have 2 Google sheets.
Sheet 1 imports a cell value from Sheet 2 using the IMPORTRANGE function.
The cell value in Sheet 2 is updated automatically each day, 365 days a year.
Sheet 1 contains ...
1
vote
0answers
6 views
How to turn off Chrome's auto highlight? [migrated]
When I click on a link in chrome, it often auto-highlights some text in yellow, which I hate. How to turn that off? Please provide a step by step guide as I do not know much about modifying browsers ...
-1
votes
0answers
36 views
I have forgotten my old Gmail password, how to regain access? [duplicate]
I have an old Gmail account but I have 0 access to it I have tried to do the recovery email but it does not work as it says that it cannot confirm that my account belongs to me. I really need this ...
1
vote
1answer
18 views
Can I upload similar videos in different languages on YouTube?
I have a video, and I want to put different dubs or subtitles on different channels for different languages. In other words, I want to run different channels for different languages.
Google is saying:
...