All Questions

Filter by
Sorted by
Tagged with
3
votes
1answer
416 views

Transfer all data from a Google Account to another

I have a managed Google Account and I'd like to transfer all my data, sync files, Drive, absolutely everything possible that is Google related with that account to a new Google account. Is it possible?...
0
votes
2answers
932 views

How to remove duplicate rows based on a column (leaving first one out) in Google Spreadsheets

I am trying to remove duplicates from my Google spreadsheet file. Here is an initial table example A B C D HelloWorld1 2 6 41 HelloWorld1 4 3 5 HelloWorld2 6 46 6 ...
0
votes
1answer
18 views

How do I correct the automatic borders that are scripted into this Google Sheet?

I have this Google Sheet document that already has functionality built in which applies automatic borders. I don't know how it is doing this. I've tried looking in the Script Editor, but I don't see ...
0
votes
1answer
10 views

google sheet how to import cells based on value in different cells

So I have two sheets. Sheet A tab X contains two columns, first one with an url for a google doc and in the other column text IDs. Sheet B tab Y contains a column with text ID of several more files ...
0
votes
1answer
12 views

Locate file on disk with Dropbox link

If I copy a Dropbox link in the UI (e.g. on OSX in finder, right click, "Copy Dropbox link") I get a https link to the file. If I click that the webinterface opens and I am pointed at the file. Is ...
1
vote
2answers
23 views

Array Formula omits IF / AND functions

I'm using a series of IF and IF/AND functions to assign a set value according to, sometimes one set or two set of colums. While creating a range and Array Formula to apply that to all posible new ...
0
votes
1answer
16 views

Google Sheets: Determine eligibility for a certification based on fulfilled requirements

Problem overview I have a list of certifications that have a set of requirements (e.g., years of experience) that applicants are required to fulfill to be eligible for the certification I have a list ...
1
vote
1answer
67 views

Is there a way to convert gmail attachments to gmail docs, and replace them in the message with links to the drive file?

My Google drive folder is at 12.8 GB. 11 of that is gmail, with a ton of photos sent back and forth between me and my customers. Gmail doesn't include mid resolution photos (which most are, and I ...
0
votes
1answer
172 views

Unable to share YouTube videos to groups of users

We have a Google G Suite Basic account (company). I would like to share some videos to a group of users (a subset of domain accounts). Although I can share with individual users, there seems to be no ...
0
votes
1answer
390 views

Disable Google account additional security

Google forces me to verify my account on second device when is identified attempt to login from new location with message below This device isn't recognized. For your security, Google wants to make ...
0
votes
1answer
44 views

Best way to change dates in Google Sheets in all the tabs?

I have a sheet that is for accountability in my business, I have each month with it's own tab with five week sections and the dates are done by a Monday thru Sunday sections with the date that is ...
1
vote
1answer
943 views

Temporarily disable autosave in Google Sheets

I use autohotkey scripts for a lot of things in Google Sheets. It's basically scripted, automated keyboard input. A script may look something like this: Loop, 4 { Loop, 7 { Loop, %...
0
votes
1answer
10k views

How can you *turn off* the new "Show Edit History" feature in Google Sheets?

I turned on "Show Edit History" for one cell in a Google Sheet and now I want to turn it off for that one cell. I can't see any way to do so. If I right-click on the cell I see "Show Edit History" ...
0
votes
1answer
750 views

How do I delete all my mail from the inbox in ProtonMail?

When using ProtonMail, there doesn't seem to be a way to delete all my mail in my inbox. I have over 10K+ emails that I just want to archive. Currently I have to select one at a time to move them to ...
1
vote
1answer
14 views

How to create Google Photos album with specific contributors?

I'd like to create an album on Google Photos, where anyone can comment on pictures, but only specific collaborators can add photos. Is this possible?
0
votes
1answer
16 views

Counting a cell if another cell has certain strings

Have a cell which will either have W, L or BB in it. I want to add the cell in O6 if the N6 cell contains any of the strings mentioned below what is the code for this? below is what I currently have ...
0
votes
0answers
4 views

Hosting Dash / Flask App with .csv data displayed via iframe - how to make manageable by single, beginner admin [closed]

I am in the process of creating a website with Wordpress, which among other things will display a Dash / Flask app via iFrames. Here are the key details: The app is written in Python The app is ...
0
votes
1answer
68 views

How to add text above all photos in Google Photo album

I have a Google Photo album I created back in 2017. I somehow managed to add some text to the top of the album (see text circled in red). I either forgot how to add text in that manner, or it is now ...
0
votes
1answer
12 views

Ask users to fill in required custom attributes?

We are looking to add custom attributes for our users, like: Discord id GitHub username etc. I cannot seem to find if there is a way to require these to be filled by users themselves. Have searched ...
4
votes
2answers
4k views

Count number of consecutive entries with Arrayformula in Google Sheets

I want to count the number of consecutive times the same value appears until the given row, until another value appears then start counting from zero again. And I want to use an arrayformula so I don’...
0
votes
1answer
26 views

Convert Script into HTML and have links embedded

I have the below script and want to have the URL links embedded instead of the whole link appearing on the automatic emails, but don't know how to convert this script into an htmlbody script to have ...
1
vote
1answer
228 views

How can I see best efforts on Strava?

I have a free Strava account. In my profile on Strava webpage I can see my estimated best efforts. For what concern running I can see: 1k 1 mile 5k 10k Half-Marathon Marathon After a run Strava told ...
0
votes
0answers
5 views

My account hijacked (and secured with OTP by attacker) now I can't get facebook OTP via email to log in

I lack access to my facebook account and some weird messages starts coming to my contacts. I was able to login to my email and change my password (it was hacked too because of same password) I tried ...
1
vote
2answers
56 views

Count how many times a certain word comes before and after another in a list

I am trying to evaluate some information from an animal studying exercise using Google Sheets. I'd like to know how many times the animal: forages then allogrooms sleeps then allogrooms etc. Also ...
0
votes
0answers
3 views

In Gmail. how may I directly forward multiple mails into an existing message being composed?

I am in a compose window. I want to forward multiple existing mails in this composed message, without having save on local computer. How?
0
votes
1answer
72 views

If my Yahoo mail is unused for years, will someone be able to register my previous mail address?

I signed for Yahoo mail, and made a Facebook account using it years ago. I suffered a head injury, which made my memory really bad. Now, I have no way of remembering that email address, and that FB ...
1
vote
1answer
45 views

Aggregate data to show text in one cell

I need to put together multiple entries into one where the results is text and has to be in one cell. From this to this
0
votes
0answers
31 views

My chatbot doesn't show links preview (thumbnail)

I am using Manychat as my messenger chatbot, i've set a campaign and lunched it to find out later that it is only sending the link without its preview. Any suggestions?
0
votes
2answers
164 views

Broken YouTube Watch Later Button

Recently, my YouTube "Watch Later" button just stopped working. I've tried clearing my cache and history - To no success. I the "..." kebab icon still works, but I'm not looking for a workaround. ...
0
votes
1answer
88 views

The cell is filled with $0,00 but IF(Cell >0;True;False) return True

In Google Sheets, when I compare a Cell filled with $0,00 using: CELL [$0,00] IF(Cell > 0; true; false). It returns true, but Cell is = 0. It should return false. It seems to be related to ...
3
votes
3answers
4k views

Google "Appearance" settings is not shown

I just realized that Google now allows dark mode. After googling for a while, I read that on Windows 10 if you have dark mode enabled, it will ask to switch or apply the dark theme by default. If not, ...
13
votes
6answers
7k views

Google Maps: add to contacts

I've searched Google Maps for a business. I've found it. I'm looking at the popup/bubble/whatever on the map, for that business. Is there something I can from this point to quickly get that ...
0
votes
0answers
13 views

My profile visitor is unable to post photo comment in my Facebook page. Why?

My profile visitor is unable to post photo comment in my Facebook page. Why? I saw a lot of people highlight that we can change it in the settings. Unfortunately, I didn't see this option in my page.
0
votes
1answer
30 views

How to manually open twitter's "more tweets" page?

Once or twice a day, the Twitter app on my phone shows a notification that shows me one highlighted tweet followed by "More Tweets". How can I get to this list of tweets manually? If I dismiss the ...
0
votes
0answers
8 views

Percentile Conditional Formatting in Google Sheets - Copying the formatting but isolating the range

I have setup conditional formatting using a green-red percentile color scale. This works fine until I copy this section down the sheet. When I do this, the numbers in the second section affect the ...
0
votes
1answer
43 views

Google Sheets Conditional Formatting Cycle

In Google Sheets I would like to color a cell depending on if the cycle is on or off. The cycle is for 10 day the cycle is ON then for 5 days the cycle is OFF then repeat. So if I start the cycle on ...
0
votes
1answer
46 views

Add fields and update array and scripts

I want to add some questions to my Google form but my response sheet has a script and an array, which do not like that. Here is what it should look like: The URL is the link for the form. Here is ...
1
vote
1answer
14 views

How to send somebody a link to a movie or TV show on Netflix?

I couldn't find a way to get a URL. If I am watching a movie, the URL has a lot of tracker info and perhaps session ID, so I don't want to send that. I could only tell the person to "search" ...
0
votes
0answers
25 views

Find the duration in weeks between grouped events using the 1st of each event

I have a data set where i'd like to have the duration between each grouping of events by comparing only the first (earliest) event in the grouping as a google sheet arrayformula. The output should be ...
4
votes
1answer
629 views

Copy several Slack chat messages without timestamps or users

If I try copying and pasting several Slack chat messages, I usually end up with lots of extra lines that are empty, or have a timestamp, or have a username and a timestamp. Is there any way to just ...
0
votes
0answers
4 views

Changing Yahoo! keyboard shortcuts

I want to specifically change the "Delete" shortcut. I have the Chromebook and there is no Delete key, the Backspace won't delete the e-mails, and I don't feel pressing Shift + # Is there a ...
0
votes
1answer
31 views

How to randomize words contained in a cell separated by Alt+Enter [ char(10 ]

How to randomize words contained in a cell separated by Alt+Enter [ char(10 ] , like a new line. I found a formula but what it does is create a range of columns first. But I can't do it because there ...
0
votes
1answer
17 views

Saving and removing things from Pocket

I have a lot of things stored in my Pocket on my computer. I do not want to lose them, but I want to clean out my pocket. How can I save them and then delete and empty the "Pocket"?
2
votes
2answers
1k views

Mails from inbox gets removed if I reply or forward them

I had made some changes in Gmail account due to which, if I reply to or forward some mail then it deletes the basis mail from my inbox automatically. If I want it back in inbox then I need to search ...
0
votes
0answers
7 views

Can Yahoo! Mail accounts use a 2FA code generator?

I would like to set up 2-factor authentication for an old Yahoo! account and @yahoo.com email address. Specifically the "code generator"-type Time-based One-Time Password (TOTP) based on RFC ...
0
votes
1answer
18 views

Merged cells not preserved when copying and pasting

I wrote a script to copy and paste a block of cells from one sheet to another in Google Sheets, and everything is working fine except the merged cells are no longer merged after the cells are pasted. ...
0
votes
1answer
22 views

Open emails in a new tab while staying in the summary view

Problem: I have a list of unread emails and I'd like to open a bunch in separate tabs, mark all unread as read, then jump around in the tabs I opened to respond to those. Gmail slows me down because ...
0
votes
1answer
10 views

How can multiple people upload to Google Drive with the same "Last modified" name on each upload?

We run a service that involves uploading deliverables to our clients' Google Drives. Our client shares a Google Drive folder with us, and we have multiple contractors uploading the files. The problem: ...
1
vote
0answers
19 views

Converting VBA code to Google sheets app script [closed]

I have been using Excel VBA code since couple of months and it was working fine now i have to move this code to Google Sheets to access it from anywhere. I am not an expert but i tried hard to convert ...
4
votes
1answer
70 views

Click to mention @name

I am using Slack on a Mac but I think the web version is the same. I am tired of typing @name each time. Is there a way in Slack, like there is in HipChat, to click on a channel member's name so it's ...

15 30 50 per page
1
2 3 4 5
642