All Questions

Filter by
Sorted by
Tagged with
0
votes
1answer
7 views

Add all tabs to a script with out having to manually add them to the script

I am trying to make this as simple as possible for users in our office that may not know how to edit script.. right now I have the following code (see below) however I have to list out each sheet name ...
0
votes
0answers
2 views

Google Sheets to output variable to Discord

I am attempting to create a script that outputs a cell in the same row to discord based on a checkbox. I've written up so far the following, although I'm really not very good with javascript/Google ...
0
votes
1answer
261 views

How to disable Google search results in Russian language?

My region is Ukraine so it is not a "mistake" that there are some relevant search results in Russian. However, can I filter out any results in Russian language anyway?
0
votes
0answers
3 views

Google Spreadsheets table and/or data mapping

I am curious to know if it exists any data sheets/table mapping tool for Google Spreadsheets. I know something like that exists for SQL tables but I have not found any free source where I can map how ...
0
votes
1answer
417 views

How to get notifications when a donation is made to my non-profit on Facebook

A donation was made to a non-Profit via a Facebook page I manage and we didn't know about it until over a month later when Facebook sent a "Payments Remittance" email. We would like to be notified the ...
0
votes
0answers
4 views

Google sheets linking between sheets: To and From

It seems there is an undocumented limit on how many sheets can be linked TO a sheet. And that is talked about here https://support.google.com/docs/thread/65482894/importrange-doesn-t-work-because-...
0
votes
1answer
44 views

Time until Specified Date

Looking to add an auto-updated amount of time countdown timer into Google Slides with the working script from this question. Getting Setup Go to Google Slides Create a text box, right click to find ...
0
votes
0answers
4 views

Gmail Inbox Issue

My inbox has been doing something odd that I really need to stop. I've been looking for a job and every response I get from online submissions is showing up in both the primary and the promotions ...
0
votes
0answers
2 views

Do I have to put a tick on “includes paid promotion” for affiliate link

I'm making a video for youtube, which a certain tool is used along the video. If I tell people that they can use the tool to have a better results and tell people where they can buy it, and put an ...
0
votes
0answers
5 views

Use comma as decimal separator in form based on Google Sheets?

I have seen this question but my question is different. My sheet uses comma as decimal separator but when I publish it as a form, dot is used as the decimal separator. How do I change decimal ...
0
votes
1answer
7 views

Play pre-uploaded video on YouTube live

I have a 1-hour YouTube video I uploaded 2 years ago on my channel. I want to play the video during a YouTube live stream. Is this directly possible? Online suggestions are for OBS, but it is an ...
0
votes
0answers
9 views

Google Sheet suddenly “Unable to load file” if I expand my pivot table on desktop

EDIT (next day): I think something may have been going on at Google, as this morning the behavior has changed. On Desktop I can now open the sheet up, and occasionally, with no pattern that I can ...
0
votes
1answer
31 views

“Count” from unspecified starting points in Google Sheets

I'm a baseball coach creating a Google Sheet to help track pitches and results for my college guys during games so they can see a lot of different information. See attached picture. I'd like the chart ...
0
votes
2answers
154 views

Is there a way to protect/copy only some formatting in Google Sheets?

I have a spreadsheet that I use to track customer orders. It has the customer details on a row, their order number and a line of check boxes for the items that they want for that particular order. For ...
0
votes
0answers
4 views

Duplicated transactions on Google Analytics 4

I`m in a process migrating my Ecommerce from UA to GA4. In this process, the system of GA4 start to duplicate some transactions. That happends when a user reload the thank you page. To solve it, I ...
0
votes
0answers
4 views

How do I find the sum of the two lowest values in a data set?

If the values in a set of data are 4,4,5,5,6,6 what formula would provide with the sum of the two lowest values, in this case the 4 and the 4, to equate to 8.
0
votes
2answers
22 views

Multiple choice response in rows without repeating other entries

We have a multiple choice question in our Google Form. We use some other spreadsheets to re-organize questions from the Google Form response sheets. What we need is having multiple choice responses ...
1
vote
1answer
454 views

Compare dates from two years in a graph when dates not identical in Google Sheets

I can’t figure out how to compare two data sets with date intervals form each year. Only the start and end date are the same days, the rest is spread over the period. And there can be more points in ...
4
votes
2answers
1k views

Aggregate strings

Can Google Sheets queries aggregate strings? I want to aggregate all locations for all years, so the following: year location 2013 Sudan 2014 Syria 2012 India 2014 Poland 2014 ...
0
votes
1answer
15 views

How to create a grouped per-30-day total without filling thousands of cells?

I have a Google Spreadsheet that counts a number of events that happened per day. This is what it currently looks like: I would like to have a 30-day total running alongside, i.e., the total events ...
0
votes
1answer
24 views

How can I link local files (Excel Sheets/Word Docs/Videos etc.) saved on my laptop to Diagrams.net/Draw.io

I would like to link some excel tables or even add them on Draw.io. These files are saved on my laptop, but I don't know how to link them to the diagram. Any help would be appreciated.
11
votes
5answers
9k views

Can I hide my favourites on YouTube from the other users?

Can I hide my favourites on YouTube from the other users? I have a normal YouTube account and I realised that everything I add to my favourites is visible to anyone. Can I hide it instead?
2
votes
2answers
319 views

How can I add a link on a MediaWiki message page?

At our company, we have an internal wiki, the access to which is restricted to a specific group. If someone from outside that group attempts access, they will be diverted to the special MediaWiki ...
15
votes
6answers
44k views

How to export Google Slides speaker notes?

Is there a good way to export the speaker notes out of a presentation in Google Slides and keep the formatting? The things I tried are Printing—this works fine only if the notes are short. Longer ...
0
votes
1answer
26 views

QUERY syntax using cell reference more than 1

I'm trying to use a cell reference instead of static values. =QUERY(Responses!B1:I, "Select * where G = '"&B:B&"'") I use code like this because the data is varchar, but ...
29
votes
4answers
92k views

How can I copy cell values rather than references from one sheet to another in Google Sheets

How can I copy cell values rather than references from one sheet to another? Right now using Filter, Query and ArrayFormula creates references which create empty cells and disallow sorting of the ...
1
vote
2answers
61 views

In Google Drive, can I make a file read-only so that not even I can edit it?

I want to make historic files read-only so that no one reading them (even me) can accidentally edit them. I'd like to make this transparent to the users, so having to open them in a different way is ...
0
votes
1answer
5 views

Google sheets “series selector” color doesn't match line color

How do I force the google sheets "series selector" color (in settings for series) to match the color assigned to the lines for the series? In my sheet, when I change the line color, the ...
0
votes
0answers
6 views

Filter out chats in Gmail without “Don't include chats” option

Previously, in Gmail advanced search and when creating filters there was a checkbox called Don't include chats. But it's not there anymore. And now I'm getting chats in my Gmail inbox because of the ...
0
votes
0answers
3 views

New Gmail Chat: How to export a conversation to an external window?

I just got my GMail web version updated to the latest UI, which includes a redesign of the chat, and now I can't open a discussion with someone as an external window like with Hangout. The best I ...
0
votes
1answer
10 views

How to fix white background cell in Google Sheet?

I found it bothersome that my cell look like this after I copied from somebody else spreadsheet. There is no gridline and the color is just plain white. I want to reset the background to be ...
0
votes
0answers
2 views

Find another user's most recent activity in Slack

Our organization has a lot of Slack channels. Is it possible to figure out where a given user has been publicly posting most recently? For example, I'd like to search for user Bob and get a result ...
0
votes
0answers
6 views

How to find someone's email address?

SalesBlink is a business outreach robotization suite that will help you in prospecting, connecting with possibilities and shutting bargains at an easing up quick speed - at the same time place. ...
0
votes
1answer
49 views

How can I show Google Calendar invites from my alternate email address?

I have an alternate email addresses set up in my Google account settings. Now some people frequently sent me Google Meetings using this alternate email address. However, these invites don't show up in ...
0
votes
1answer
21 views

Cannot get Query to display time

I need help getting to show the result of a dropdown. If you look at C22, there's a dropdown for a specific date. I'm currently working on row 24 and have applied the formulas I think should work. I ...
0
votes
1answer
7k views

How to move a row into another sheet?

In Google Sheets, I need to hide rows if column H says, "Completed" My preference would be to cut and copy the row to a new sheet if column F reads "Completed", but sounds more difficult. If you ...
0
votes
1answer
43 views

Conditional formatting with custom formula

I have pretty much zero experience with spreadsheets but I've got what I think is a simple task. I've been keep a log of how I spend my time. I've codified the language so I can easily grab the ...
2
votes
2answers
3k views

Can I make an email template in outlook.com?

Most of emails I send are for jobs, so I have to type the subject and attach my resume from the cloud and send it every time, the only difference is the To field. Can I create a template in Outlook ...
0
votes
1answer
6 views

How to compare two playlist in YouTube?

I want to download videos of two playlists from YouTube (100+ videos in each one) but they have common videos. How can I compare these playlists and find the repeated videos?
0
votes
2answers
4k views

In Google sheets, how to calculate elapsed duration between two cells, each containing date and time and display as days and hours

There is a built-in duration format, but Elapsed days is not an option. I want to display "2 days, 3 hours"
2
votes
2answers
2k views

Google Sheet formula on finding smallest value larger than 0 does not work inside conditional formatting

I wanted to find and highlight the smallest value larger than 0, but the formula I am using does not work in the conditional formatting. =MIN(FILTER(L4:L100, (L4:L100)>0)) Namely, if I use it ...
0
votes
1answer
2k views

Google Sheets function returns an incorrect value

I have a very simple function for every cell in column D, for example: D24 =C24-(B24*N$2) Example with values: D24 =10-(1*6,5) This works; however, not all the time. For cell D24 this returns a ...
0
votes
1answer
10 views

How to download edit history from Google Docs

I love Google Doc's edit history because I can see when I created files and then modified them later. Is there anyway to download this edit history for a particular document? Ideally, I'd like to ...
0
votes
1answer
5 views

Can I assign two functions to a single menu item in Google sheet app script?

Is it possible to assign two function names into a single custom menu item like this script: function onOpen() { var menuItems = [ {name: 'Draw Borders', functionName: 'borders'}, {name: '...
0
votes
1answer
14 views

Creating a multiselect lookup row in Google sheets

I have a sheet of activities that looks something like this Activity Name Category Ids Activity 1 123456, 98756, 345677 I have a second sheet of category ids Category Id Category Name 123456 ...
0
votes
1answer
15 views

How do I make column letters bigger so I can see them?

How do I make column letters bigger so I can see them? This has driven me nuts and I can't find anything on the web about it. Thanks in advance
0
votes
0answers
6 views

CRUD Systems Top one/s Free? PHP/MySQL [closed]

What CRUD PHP/MySQL freeware systems would you recommend? Thanks 🙂
0
votes
0answers
9 views

How to get the xml file (or html code) of the entire website made with new Google sites?

Blogger accepts only xml file and html edits to change the theme of the entire website created from blogger. I want to change the theme of my blog here into the very minimal and professional look/...
0
votes
0answers
8 views

Idea of creating twitter trend website [closed]

recently I was going through doc of twitter api. And i figure out to display trend by country i have to use trend/page API i.e https://developer.twitter.com/en/docs/twitter-api/v1/trends/trends-for-...
0
votes
0answers
3 views

“Could not fetch URL” ImportHTML/ImportXML Error [duplicate]

I've seen a few responses on this subject, but I've tried everything & have yet to have luck. I'm looking to import the "Game Box Score" tables into Google Sheets for this link: https://...

15 30 50 per page
1
2 3 4 5
635