All Questions

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

Problems with SUMIFS function

I don't understand why SUMIFS function works with some columns in the same worksheets and for others it doesn't. This is my formula: =SUMIFS(EURO;AGENZIE;"ABN";MESI1;"01") where EURO, AGENZIE, ABN ...
0
votes
0answers
23 views

Filter spam email from my email address with different replyto header

I keep getting emails that come from my email address (obviously not sent by me but spoofed by someone). These emails will have a significantly different reply-to header. Do you know how I could ...
1
vote
1answer
57 views

Where do I find old Facebook messages?

I need to retrieve old messages I sent to a friend on Facebook from 3 years ago that I didn't delete. Can I find them and where?
0
votes
0answers
13 views

How to Change Google Slides Default Transition

I can easily change slide transitions from fade (default) to something else, and then apply to all slides. But sometimes I forget, and I do not realize it until it is too late. Is there any way to ...
1
vote
1answer
42 views

How to turn on notifications about new message on Facebook page?

I just started with creating my own page on Facebook. How to turn on notifications, when someone send me a new message via FB page? Thank you
1
vote
0answers
63 views

Syncing Google Photos to Google Drive?

Google previously had a way of having a Google Photos folder in Google Drive. So that anything say automatically synced into Google Photos would be shown in Google Drive. But recently (2019), they ...
0
votes
1answer
31 views

Is it possible to move youtube subscriptions to another account?

I'd like to migrate all my various google accounts into one so I don't have to remember five different ones (and also, some of these are kind of tasteless names that I made when I was a 14). The ...
1
vote
1answer
30 views

How to access all public files shared by one user in Google Drive

Is it possible to access all public files in Google Drive if I have only one link? They are are obviously public as I can access the ones where I have a link, but I would like to obtain links to other ...
0
votes
0answers
32 views

Need to move auto move row in Google Sheet

I need a to move all rows that have the word "wine" in column E to a a different sheet that is labeled "Wine" in the same Google Sheet. I have been trying different scripts but have not been ...
2
votes
0answers
5 views

Amazon: How do I clear text search and see just the category

Here's something that I've been trying to do for a long time without success. Let's say I'm searching for something on Amazon, and this is the search page I'm on: https://www.amazon.com/s?k=e27+led+...
-1
votes
1answer
24 views

GAS MailApp.SendEmail - include multiple attachments using ss cell value

I have file names separated by commas (no spaces) in a google sheets cell 'filez1.pdf,filez2.pdf'. If I assign a variable as a string; flist = "filez1.pdf,filez2.pdf" or an array flist = ["filez1....
0
votes
0answers
15 views

I need to check if the number belongs to the set

Students id numbers must coincide with the numbers in the database (right bottom corner) for cast votes to count. So I need a system to check it.
0
votes
0answers
6 views

Is it possible to import Firefox cookies into Chrome? [migrated]

I have exported my cookies in Firefox to a TXT file and also to a JSON file. Is it possible to import either file into Chrome? I have tried a number of extensions from the Chrome Web Store but none ...
0
votes
1answer
13 views

postEdit functions getting range

Does anyone know how I can change the below function to postEdit rather than onEdit? I am trying to set this in an autoSort function so that the sheet will be edited only after all values in an ...
0
votes
0answers
40 views

Gmail - precedence between blocked senders and filters

If you have blocked senders in Gmail then email with that FROM address will get put to the SPAM folder. If you had filters which also would fire for those emails do they fire still? After the email ...
0
votes
0answers
3 views

How do I remove the DEFAULT rollover link/icon from Titles, Headings and SubHeadings in New Google Sites?

By default "NEW" and terribly improved "Google Sites" puts a 'copy link' icon on all text that is a Title, Heading, or Subheading. It shows up when you rollover the text. It looks terrible. I have no ...
1
vote
1answer
53 views

Gmail opens PDFs in Google Docs Viewer. Is it possible to disable this?

In any browser I open, gmail has this annoying "feature" that previews pdf files (I haven't tested other files) in google docs viewer. This is inconvenient because when I try to print, it opens a new ...
0
votes
1answer
11 views

Google Data Studio - Sum of 2 fields from different data sources

I'm just getting started with Google Data Studio. I have connected 2 different Shopify stores to it, which worked totally fine. Now I try to show the sum of the revenue of both stores, but the ...
3
votes
1answer
33 views

Filter in Filter function Google sheets

I have a Sheet with the prices of some products Each column is a parameter. How to use the FILTER() function in order to filter by multiple conditions In this case I need to filter and see only ...
1
vote
1answer
13 views

Integrating Office 365 Calendar with Google Calendar

I am trying to integrate a offiche-365 calendar to google-calendar. The purpose is to use the ical from the google calendar in a 3rd party app where I can only read Google Calendars. However, ...
0
votes
1answer
13 views

One column of vertical text on draw.io

I want to create a box with text in vertical, but I don't want characters to be rotated, I want them to be horizontal, just one on each line. Like this: If you select vertical text all you get is ...
1
vote
0answers
14 views

client-side document editing - locking / editing / upload [closed]

I'm looking for a solution to allow users to edit files (mostly Word, but other should be possible as well) on the client machine (no add-ins as they need the full-blown editor) without having to ...
0
votes
0answers
8 views

Amazon: Exact search or search only in title?

Amazon search seem to suck... or am I using it wrongly? For example, I wanted to find the cheapest Wi-Fi 6 routers, but searching Amazon with "Wi-Fi 6 routers" and sorting it by price showed lots of ...
1
vote
0answers
11 views

Link to view PDF version of a Word Online doc

I create documents which I update frequently, I share these with a link which turns the document into a pdf when clicked ensuring whoever clicks the link always gets the most up to date, pdf version. ...
2
votes
2answers
40 views

Show/hide fields (if empty --> don't show)

we are working on a project to atomize our offer process. We have multiple insurance products which can be chosen and are then passed on through zapier to Google Docs. Obviously not every customer ...
2
votes
1answer
14 views

Search excluding file name on GitHub?

Situation: You are trying to find the usages of a feature of some common framework, and want to only find client code instead of 1000 copies of the library itself. Further compounding the problem is ...
1
vote
1answer
30 views

Why does close price results have a date shift (one day off) while using GOOGLEFINANCE in a Query

I want to get last 40 days close price of stocks. I used below formula for the same but the result not showing the last day close price. =QUERY( GOOGLEFINANCE("nse:"&B2,"all",$A$2-80,81),...
0
votes
1answer
26 views

Increase my script perfomance and speed

I was ran this script. It worked in more than 30 minutes. I don't know how to make it faster. May be have the way to reduce run time to 5-15 minutes . strong textfunction sumData1() { var ss1 = ...
-1
votes
0answers
7 views

How to forbid Chrome from opening a new tab? [migrated]

Sometimes, when I click a link it will open a new tab. Is there a way to forbid Chrome from doing so?
1
vote
1answer
11 views

How can I hide all videos from a given channel on YouTube?

How can I hide all videos from a given channel on YouTube? By hiding I mean never recommending any video from the given channel.
2
votes
0answers
15 views

Gmail Filtering

I have Gmail filters set up to label incoming mail based on the the company name in the subject, and it is working just fine (For my case they are marked as read and labeled). If however the subject, ...
0
votes
0answers
13 views

How to remove media from a specific individual 'experience' / job role entry on user's profile in LinkedIn?

I attempted to add a web-link to a specific experience entry (i.e. job role) on my profile on LinkedIn and now I want to remove it, but I can't see where to delete when editing that experience entry. ...
1
vote
0answers
37 views

POP download from Gmail doesn't include emails sent from smartphone client by SMTP

I have three different Gmail accounts. I have a phone with AquaMail. I have a PC with Thunderbird which is set up to combine all the accounts using POP, thus keeping a permanent copy of everything on ...
1
vote
1answer
23 views

How to open a hyperlink in the same tab using a keyboard shortcut

How do you open a hyperlink in Google Sheets using only keyboard shortcuts? Google has Alt+Enter which opens the hyperlink, but in a new tab in Chrome. How can you open the hyperlink using only ...
2
votes
1answer
48 views

Split comma-separated cell in sheets while repeating other cell for all entries

I have a Sheet that looks like this: ╔═══════╦═════════════════════════════════════╦══╗ ║ ID ║ Users ║ ║ ╠═══════╬═════════════════════════════════════╬══╣ ║ 12345 ║ ...
-1
votes
1answer
22 views

Can Google Spreadsheets cache images?

I want to create a resource for a browser game and I need to export a ton of character portraits. The url of those portraits is automatically generated with character's id, so you can just load them ...
1
vote
0answers
22 views

How to change font style for Description, Response and other fields?

My research shows that old version of Google forms allowed to set different font styles for EACH type of field (question Title, Description, Response etc.). It used to be possible to switch to the ...
2
votes
2answers
62 views

Query or Filter formula to 'search for' and 'return' multiple words

I am a basic user of Google Sheets and need help creating a new formula. I am trying to filter a worksheet so that it returns particular information into another sheet. The filter I have created is ...
0
votes
0answers
22 views

Why won't the 'post' button work on Facebook?

It seems to only work on a computer but not on the moblie site. I am using an android phone (a very low quality one) but I can't figure if that's the problem or not.
1
vote
1answer
22 views

Formula Parse error

Trying to use this formula in Google Sheets but getting a #error! parse error. Any help as to what may be wrong in the above formula =if(AND(B4="YES",G4=0),(ROUNDDOWN((AVERAGE(I4,K4,M4,O4,Q4,S4))*35%*...
0
votes
0answers
27 views

Catch All Filter G Suite

I have recently set up GSuite on my domain and am really enjoying the productivity and getting myself organized. I have successfully set up a catchall email which is an alias and is catchall@...
0
votes
0answers
31 views

How can I resize web WhatsApp aside bar?

I have been looking for my solution since long, please help me out in this. I tried a way which was told in this forum by someone to use stylus extension but it's not working so if anyone helps me out ...
0
votes
1answer
25 views

How to sum specific columns when adding new columns for hundreds of rows?

I've got a sheet in Google Sheets that tracks a large inventory. I want to quickly see the total of the last three months (columns) but ONLY the last three months. So far it looks something like this: ...
0
votes
1answer
46 views

Primary G-Suite User Can Send But Not Receive Emails

The primary user for my G-Suite account can send but no longer receive emails. I think I may have changed a setting to cause this but I don't know which one. The primary user email on my G-Suite ...
0
votes
1answer
20 views

Formatting a cell based off of the rest of the row

I have a spreadsheet keeping track of the various documents that students of mine have been turning in. The first column contains names and each column after tracks a particular document. Is there a ...
1
vote
0answers
7 views

Is it possible to upload CC-BY-SA licensed works on YouTube?

Is it actually possible? Has it been possible in the past? Did this option ever get discussed? Did google ever talk about it? If not possible, one can't actually upload (or repost) a CC-BY-SA video ...
0
votes
1answer
25 views

Copy Rows from Master Sheet to other sheets based on user input

I am trying to set up an assignment sheet for my work team. I have a script to move a selected range from one sheet to another, but is there a way to modify it to have the person doing the assigning ...
1
vote
0answers
14 views

G Suite discussion forum that works with G Suite lists/groups? [closed]

My university has G Suite, and creates some G Suite lists, e.g., C-ABC123-Fall2019@example.com, which has all students enrolled in the course ABC123 in Fall, 2019. The G Suite domain is there, rather ...
0
votes
0answers
15 views

Using Jekyll for private website with private GitHub repo

I'd like to setup a private portal for an organisation (portal.organisation.com) for people to login and download essential internal docs etc. I figured it'd be good to use Jekyll. The site will be ...
0
votes
0answers
6 views

Shipping logistics for Shopify sites

I am trying to help a buddy out that has an emerging (and surprisingly successful) mom-and-pop shop retail website. He is a world-class "grip athlete" that holds several world records for lifting ...

15 30 50 per page