All Questions

Filter by
Sorted by
Tagged with
1
vote
0answers
15 views

Function to create a calendar for one year with gaps (date and days in separate cells)

Is it possible to have a function within a Google Docs spreadsheet which I can link to a button which will create a calendar in the following format: Number will be 1 - 365 for the days Date will be ...
0
votes
0answers
15 views

How to find messages from friend who deleted their account?

My friend deleted her Facebook account. Now I can't find the Messenger conversations we had in my account. How do I find those old Messages?
1
vote
1answer
21 views

How to automatically fill, sort and conditionally format 1st day of the week according to given year and month

How can I fill-in column A, make it start with the day's name according to the year in A2 and month in A1 and conditionally format them? https://docs.google.com/spreadsheets/d/...
0
votes
0answers
3 views

Error Launching on the Angular/Electron app [migrated]

I have created an angular 10 project using the angular-CLI. Following that that I have installed Electron and done this: changed src/index.html base to Installed Electron locally. but when run my code,...
0
votes
1answer
21 views

Delete Facebook account including chat

Is there any possible way to delete a Facebook account including all old chat messages both sides, I know I can delete my Facebook account (comments, likes, groups...) but what to do about old chat?
1
vote
1answer
18 views

Problem with results of filter function from tabs that have no data yet

I made a master sheet that combines all data from 12 tabs within the workbook sheet. These tabs use query functions and importrange from other sheets. Some of sheets have no data yet like May 2021 ...
0
votes
0answers
6 views

Add multiple body parameter and the end of list with GitBook

I am using GitBook in Firefox. When I add parameter to my header they are placed on the very top. Its not possible to move these items. Am I overseeing anything, or it it not possible to easily add a ...
1
vote
1answer
19 views

Has Google been Hacked or do I have a Virus/Spy/Trojan?

Since Yesterday I think, titles in my Google Search results are displayed Bold unless it's due to the Font chosen... Moreover, for the 1st time since a long time (don't even know if it ever happened ...
0
votes
1answer
25 views

How to sort the types of materials from one column

I have in Sheet1, column B, 5 types of materials. In column L, I have numbered the position of each one. So, Position 1 to 6, is 'Plastic tube': I need a formula, in Sheet2, that can calculate this ...
1
vote
1answer
38 views

How to clear range instead of sheet in Google script?

I used this script from another post but I want to modify to clear range instead of the entire sheet. Instead of sheet.clear() , I want to clear A2:D. (while keeping data in Column E and other columns....
0
votes
0answers
11 views

What's the fastest way to upload an image located in the clipboard to some website with a file upload that doesn't support upload from clipboard? [closed]

From time to time I have an image located in the clipboard, and I go to some website that asks me to upload the image: What's the fastest way to upload an image located in the clipboard to some ...
0
votes
0answers
17 views

Overwrite Google Form responses with Data input tab

Due to Covid we have to do registration differently. We have a form that collects all the requests. The counselor meets and pulls up their ID on a search tab. If there is a mistake the counselors ...
0
votes
0answers
10 views

Google Calendar: Is there a way to show me as “Free” automatically if I respond “Maybe” to an invite?

I respond "Maybe" to events in my Workspace calendar that I'll only attend if I need to and/or I don't have a higher-priority event/task at that time. However, these events still show me as &...
0
votes
0answers
17 views

Changing font size based on value

I found this script when searching for a way to employ Harvey Balls in a Google Sheet. The only problem is that a couple of the balls are smaller than the others. A remedy would be to increase the ...
0
votes
2answers
34 views

Change all unique country abbreviations to country names and place in one cell

I need a formula that can add all the countries with that is in a column. Example: In sheet 'Export' I have the below countries of origin: And in other sheet I need to show all the countries of ...
0
votes
1answer
23 views

How to refer to a cell value within importrange function?

I am using this formula to bring data from another spreadsheet file based on name of the month. This time for February.. =query(importrange("1L86iP0GLHTubwfvxs1kJ4ocbmgRAd4Iz0000000M","'...
0
votes
1answer
21 views

How to draw self-call in sequence diagram

The built-in self-call in the UML shapes library is misplaced. Attached shows the desired one and the current one. Making the desired one I have to make several clicks, draw, tweaks on the line. Any ...
0
votes
1answer
51 views

Google Analytics redirect to provision page issue

I cannot register in Analytics. I will be redirected to the page below: https://analytics.google.com/analytics/web/provision/#/provision I even used another browser and browser private mode.
0
votes
0answers
20 views

Use an embedded image as a link in a Google Spreadsheet in the published version

This is a very specific set of circumstances. I'm trying to use an image which I've embedded as a link. This works in the Edit interface, but when published, the image/cell does not act as a link. I'm ...
0
votes
2answers
56 views

How to sort a column with date that is impeded within Texts?

I have a list of files' names that I would like to sort based on the date that's impeded within the file name text (Column A folder). When sorting them, the number 10 comes after 1 instead of 1,2,3,4,...
1
vote
0answers
10 views

Top vs latest tweets in new Twitter accounts

I joined Twitter in 2009. In my home page I always see the "latest tweets". A friend that has joined about a year ago has two options - latest tweets and "top tweets", where it ...
0
votes
1answer
40 views

Look up rate for specific person in effect on or after a date

In this Google Sheet, I have one sheet, "Transactions", with a rate entry that should be auto populated from a table in the "Rates" sheet. The formula should look up the rate for ...
0
votes
0answers
14 views

Google Forms Overlay Responses

I'm trying to capture a few information about our business partners. Four of the questions will be used to print a contact card. Is it possible for Google Forms to display the 4 responses that ...
1
vote
0answers
11 views

Google search for multiple countries/region/area?

Is it possible to search Google for multiple locations at the same time, for example the African continent, or multiple countries. There is the possibility to do it for a single location. gl=sa in the ...
-1
votes
0answers
14 views

Duplicate Slack channel posts in real time?

Is it possible to do this for all the sections, including all posts/files/videos in a PRIVATE channel (not owner) to another private channel (where I am owner)?
-1
votes
0answers
17 views

How do you combine/concatenate within the same column with conditions on Google Sheets [duplicate]

Will explain it with picture example, lets say I ran a car repair with this Google Sheets: And I want to combine/concatenate All Column B into column D like this with Car Number as Conditions using ...
2
votes
1answer
24 views

Drag to fill/autocomplete dates only increases year, not day

Please see screenshot below. When I dragged on the blue square in highlighted cell, I only get the result below. I have set correct region in sheet settings. I have set the correct date format in the ...
0
votes
1answer
26 views

How to use FLATTEN function in query function in Google Sheet

Below in my query result: In the above table "Form Response" table is the response received from Google Form. I want to convert "Form Response" table to "Desired Result" ...
0
votes
1answer
11 views

Permanently stop a YouTube autosuggestion for a single video during auto play?

After one song is played, YouTube plays another and another - this feature is called 'auto-play'. Often, YouTube predicts what you will enjoy based on what others have enjoyed, but occasionally ...
3
votes
1answer
186 views

Google Sheets - existing row formulas are being erased after Google Form submission

I am having problems with Sheets and Forms connection. I have pre-entered formulas on Google Sheets, like vlookups and TO_DATE value, but as soon as I submit entries from Google Forms, the formulas ...
0
votes
0answers
17 views

How to set a default location when Google Maps opens

I just want the Google Maps iPhone App to default to my home address every time I open it, regardless of whether or not I have my GPS location active. I can't understand why all of a sudden it keeps ...
1
vote
0answers
24 views

How to calculate units with range value of numbers

We sell greeting cards and this is how it works Scenario 1: if you want to send 1 greeting card up to 10 cities then the price will be 15USD if you want to send 1 greeting card up to 25 cities then ...
1
vote
2answers
38 views

Select Unique on 1 Column in Google Sheets - Distinct Doesn't

I'm trying to set up a kind of a bid thing, where the top 5 respondents receive a prize. I was hoping to use SQL to get the top 5, but I can't remove duplicate bidders and only take their top bid. I ...
0
votes
0answers
9 views

Google Maps locations

I am trying to download the directory of all hospitals in my city within the year they appeared, I would like to import that information to a csv file, is there any option of downloading information ...
0
votes
1answer
21 views

How to include VLOOKUP with a loop for a list of data on Google Scripts?

I have a list of data on Sheet1 columns A-N, and a list of updates on Sheet2, columns A-N. I have a code that imports data to Sheet2, and I would like to add to my code a similar function to VLOOKUP. ...
0
votes
0answers
11 views

Is there any way to export PowerPoint slides to PNG while having each image the name of the slide?

I need to have a presentation with PowerPoint in several languages, so after the translation, I do not know the content of the images anymore. Then, if I do export the file to PNG, the images have ...
0
votes
0answers
59 views

Gmail: add another email account

I would like to add a Yahoo account to a Gmail account. Since the Gmail account is a free one approaching its quota, I would like Gmail to not retrieve the old Yahoo messages, but only those received ...
0
votes
1answer
22 views

Conditional Formatting only seeming to apply if the 'Less than' criteria is selected

I am trying to apply some conditional formatting to a cell on Google Sheets. I want the cell to change green if it is larger than another cell, red if it is less, and yellow if it is the same. However,...
0
votes
0answers
27 views

If I am importing mail from one Gmail account to another will the data from the previous Gmail from where I am importing be deleted, If yes?

If I am importing mail from one Gmail account to another will the data from the previous Gmail from where I am importing be deleted, If yes? How can I prevent that? I want mails to be copied over ...
0
votes
0answers
19 views

How to send personalized HTML emails from a spreadsheet [duplicate]

I have a Google spreadsheet that contains recipient's names, emails, and a message that anonymous people have sent this Valentine's Day. I am aware of applications such as the various Mail Merges ...
0
votes
0answers
10 views

Google Script protect Row based on cell

How to protect a Row based on a cell "locked", "unlocked" dynamically with Google script?
2
votes
1answer
25 views

All Mail folder

Every answered on this topic is unsatisfactory. I have a simple request and expect a very simple procedure. I expect you have the expertise and experience to provide an immediate answer. I need to ...
2
votes
1answer
63 views

What is this image next to the YouTube logo referencing?

I see the following logo next to my YouTube logo on my home screen. Reverse image search suggests a connection to American Sign Language but since I see only two results I'm not sure, and YouTube ...
0
votes
0answers
13 views

Sync company calendar to Google Calendar

I would like to view my company calendar (Hosted on Bluehost) on my Google Calendar. Is there a way that I can do this?
0
votes
0answers
7 views

G-Mail SMTP Service accounts [migrated]

I'm setting up a google workspace for my company as we want to fully migrate our mail system to google. Part of this is obviously creating al mail boxes, aliases, etc. Now we currently have some mail ...
1
vote
0answers
63 views

Recovery Instagram page

Just logged in to Instagram with my number(Not connected to email and Facebook either). Now I have forgotten my password. When I forget the password, it sends me a page recovery link, but the problem ...
0
votes
0answers
16 views

I need a script to open a link in Google Sheets, go to that page, copy the URL and paste the URL back to the sheet

I have a list of websites in my Google Sheets with redirect. So I need to manually click on those links > go the website > copy the URL > and paste it back in the sheets. Is there a way to ...
0
votes
0answers
15 views

In Google Sheets, how can I multiply across two rows conditioned on whether a value exists in a given cell?

I have two tables that track sales seasonality as well as sales per person per month: Seasonality: Seasonality Jan% Feb % Mar% 4.5% 6.0% 7.5% Sales: Salesperson Jan$ Feb$ Mar$ John $1000 $1200 ...
0
votes
0answers
13 views

Combining OR, AND & NOT logic in Gmail - where do PARENTHESES go?

I have Gmail's multiple inbox set up, and can't seem to combine OR, AND and NOT logic for the search term. My top group shows red-bang and drafts, my second group yellow-bang, my third red-star, and ...
0
votes
0answers
17 views

Spam reporting on Messenger

What happens when I report a conversation as spam but older messages are deleted from my side and it is still visible on the other side?

15 30 50 per page