All Questions

Filter by
Sorted by
Tagged with
0
votes
0answers
5 views

How to get sort ordered using Unique filter in google sheets

I have a flag in a table. When I am trying to sort using Unique formula. It is not sorted as per my requirement. Flag order needs to be Flag T1 T2 T10 T11 instead of Flag T1 T10 T11 T2 T3 ...
1
vote
0answers
124 views

How to stop zoom chat scroll bar from disappearing?

When I teach over Zoom, I have a small chat window on the side. It is very difficult to use because the vertical scrollbar keeps disappearing. I have to fidget with the size of the window in order ...
0
votes
1answer
3 views

How to export from the MindMeister web app to FreeMind format?

I used the MindMeister browser-based collaborative mindmapping tool to create a mindmap. Now I want to export it to FreeMind format, as FreeMind is my default open source mindmapping tool for offline ...
1
vote
1answer
167 views

G Suite selective email migration from Gmail

I am interested in partially migrating emails from my personal google account to my new G Suite account. I want to migrate all emails containing a certain label and no others. I know there is an ...
1
vote
1answer
45 views

Two Gmail filters applied to the same email

I'm having an issue where 2 filters are being applied to a single email. Resulting in that email ending up in two different labels. As an example: Filter A is for a general email box that multiple ...
0
votes
1answer
367 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 ...
0
votes
1answer
36 views

Create events from a spreadsheet and write relevant ids back to the spreadsheet

I have a function to create events for field based workers. Eventually I will add this to an onEdit trigger and give the user (centrally based admin worker) some functionality to edit/delete events ...
0
votes
0answers
9 views

I want to cancel my Zoom-pro account but cannot log in anymore (old deleted email address). How to stop the payment?

I discovered that I still have an old zoom pro account for which I still pay every month. However, this email address does not exist anymore, since it was from my former job. Therefore, I cannot log ...
2
votes
2answers
918 views

Import button greyed out in Google Sheets menu for unknown reason

I'm trying to import a .csv file into my Google Sheet like I've done myriad times. However, occasionally, the Import button in the menu is greyed out (see screenshot). Reloading the document doesn't ...
2
votes
1answer
39 views

Filter function with multiple variables google sheets

I want to be able to use a filter function for people in NAME whose P DATE is within a specified range. However, if they have a Y under VALIDATED, I want the filter to also include names with the T ...
0
votes
0answers
12 views

Merge rows into a single line while keeping data

I have a Google sheet that logs attendance using a simple x to tell when someone has come in. Unfortunately there is a lot of misspelling of peoples names and so there's a bunch of duplicate data in a ...
0
votes
0answers
6 views

Gmail deletes my receipts

Every month I get a bill from my credit card company for stuff I bought online. I search my Gmail to check that the receipts corresponds to the credit card bill. Lately I have discover that receipts ...
0
votes
0answers
6 views

How to remove myself from a canceled event on Facebook?

I had responded "going" to an event on Facebook that was canceled later. Now I cannot change my response and the event keeps showing on my events list. I would like to remove it, but ...
0
votes
0answers
4 views

How can I merge responses of two google form identical to each other but in two different languages

I want to combine the responses of two of my google forms that are identical to each other but in two different languages. How can I combine the responses to get the summary of both sets of responses?
1
vote
2answers
1k 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
0answers
9 views

Google Doc Hyperlinks [duplicate]

I have a Google Doc setup like this. I'd like to be able to link to each part of the table from a Google Sheet using a URL like: GoogleDocLink#1 GoogleDocLink#2 GoogleDocLink#3 GoogleDocLink#4 Can ...
0
votes
0answers
13 views

what is the Google sheet query for getting rows excluding non matching rows

The tables will have multiple entries for amount debited and credited details. It also has 5% debit and credit and 1% debit and credit entries as well. Data includes unique flag for districts, Date ...
0
votes
0answers
7 views

How to insert a tab character in a Medium post

This looks like a "duh" questions probably already answered here or somewhere, but could not find. How do I add a tab character in a Medium post? Tried the below a b a\tb a b U+0009 etc. ...
0
votes
0answers
5 views

Why do different tabs show images slightly brighter or darker in Firefox? [migrated]

A mystery: On this page, two tabs in Firefox show slightly different brightnesses for a color image from one tab to another. This is clear if I click one tab, then the other, precisely comparing them ...
0
votes
0answers
8 views

Google Analytics UTM Codes in Conversions Goals

I have 2 websites. (Site A and SIte B) I am passing UTM codes From Site A to Site B page. (Site A page 1 to Site B page 2) Site A with UTM tracking info - https://www.SiteA.com/?utm_source=MYsource&...
0
votes
1answer
25 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 ...
4
votes
2answers
3k views

API access to Cognito forms

Is there any API access to Cognito Forms or are there plans to make that available? I'm working on a particular form and finding the email notification is significantly delayed and having API access ...
0
votes
0answers
4 views

Changing profile picture privately

How do I change my profile picture back to an already existing one without it appearing on other's timeline or it being in everyone's newsfeed?
0
votes
1answer
10 views

Drawio mirror diagram

Is it possible to mirror an existing diagram with connectors etc.? By mirroring I mean to have a reversed copy of it (the nox that's in the left to go in the right and so on)
0
votes
0answers
10 views

How do I insert a timestamp in Word for the Web or Google Docs, on a Chromebook, via hotkey or voice?

Desired Result: The desired result is to insert a timestamp (local machine time or whatever) into a "Word for the Web" document or Google Docs document, on a Chromebook, by using: i) a ...
0
votes
0answers
13 views

Pi network Facebook verification problem

I deleted my first Pi network account before, and made a new one today. However, I cannot verify my Facebook account anymore. The note says: a user already exists with this Facebook account. What ...
0
votes
2answers
28 views

How to sum all the value inside multiple brackets within single cell in Google Sheets

I'm a complete noob to everything that concerns formulas and scripts on sheets but I thought I'd ask if a certain thing was possible: I have no idea if this is even feasible in a formula or if I'd be ...
0
votes
1answer
10 views

Generate report of total count from drop down data list in Google Sheet

I have created a Google Sheet to enter data of a hospital. One of the column is 'GENDER' where I have created drop down using data validation -> list of items and the items are (M,F) and similarly ...
0
votes
1answer
15 views

Find cell values that are x% similar in google sheets

Essentially I have a bunch of data in a Google sheet from a Google form asking people what video games they play. I have results like "CSGO" and "CS:GO" as well as "Kovaak 2.0&...
0
votes
1answer
25 views

Facebook Admin Personal Account Disabled

I run an online business through my relatively new Facebook account, and my personal Facebook Account is the admin of my Online Shop got disabled recently. Before running ads, I was asked to upload ...
0
votes
0answers
7 views

VLOOKUP (PROCV) It's not returning the same value in the next line

I have a specific "ORDER NUMBER" that shows up around 10 times with different "MONEY VALUE", so I did a dynamic table to group up all the "MONEY VALUES" for that "...
0
votes
0answers
5 views

Why does my live stream have more Peak Concurrent Views than Unique Views?

I'm looking at the analytics for a live stream I ran in the past to get an idea of how many people watched it. I see some confusing data in the report. According to the report, on the day of the ...
0
votes
1answer
31 views

Google Sheets - Highlight nearest value - Swimming Times

I'm banging my head against a wall trying to find a way to highlight a swimming time compared to results from past swim meets. Column A is my swimmers time Column B is the event Column D is the time ...
0
votes
0answers
239 views

Microsoft Outlook hiding text after pressing enter [migrated]

When typing an email, the previous line of text is hidden after pressing enter. Then, the cursor is stuck and can't be moved. I've checked if it's deleting the text and it's not, since when sending ...
10
votes
3answers
3k views

How to make hundreds of URLs clickable in Google Docs

I am migrating documents to Google Docs that contain many URLs. If I hit Enter after each one, the link becomes clickable. But I'm looking for a way to convert all URLs (text starting with http:// or ...
3
votes
2answers
3k views

How to disable auto-play in YouTube playlists

So I know this question has been asked before, but neither the answers on this question: (How can I disable playlist autoplay in YouTube?), nor the answers from the linked duplicate question there, ...
0
votes
0answers
6 views

Google Analytics: how do I get detailed click-through numbers by advert by advertiser

[This query is already posted on stackoverflow because I was unclear whether I needed to add more variables to the GTM Data Layer or whether it was just an Analytics data analysis issue. I don't make ...
0
votes
1answer
20 views

Point in time data [duplicate]

In google sheets, was wondering if I can do a lookup and capture the data of the return at that point in time instead of continually updating it. For example, if I'm using vlookup to relate item to ...
0
votes
0answers
7 views

I want to replace an URL in Google Sheets as a personalized hyperlink in my Google Docs body [duplicate]

I have a link in one of the Google Sheets cells like this: I know how to attach it to the Google Docs body through the following steps: const body = doc.getBody(); body.replaceText('{{MyURL}}',row[...
3
votes
3answers
2k views

How to restrict a Google Script to a certain cell range?

I'm working in an automatic script that shows the last modified dates of some cells within a sheet. So far, I've succeed with the sheet restriction adding an if condition, but I want to restrict this ...
0
votes
1answer
117 views

How to run a different script on multiple Google Sheet tabs?

The code writes an auto email once a trigger is met in the sheet. There are 3 different tabs pulled from the main sheet and each tab should run the script but with a different message for each tab. ...
0
votes
0answers
10 views

How to start the script from the third row for dependent drop down list? [duplicate]

I am NOT expert in coding, just managed to piece together a script with dependent drop down list. The script is to allow user to select the drop down list from Row 1, Column B, C, D, ... (eg. B1) with ...
0
votes
1answer
293 views

Restrict the range of a script that replaces input data to a certain range

There is this question regarding adding checkbox functionality to Google Drive: Checkbox function to automatically add to total. And a great answer is: In the Google Sheets spreadsheet go to Tools -...
0
votes
1answer
662 views

How to select existing sheet to be populated by a Google form?

I have a team working in pan India with 6 Team leaders. I have created a Google form to collect the everyday status report. Now the question is: How can I assign a particular sheet[already created in ...
8
votes
4answers
19k views

Is there any way to use a formula in a Google Sheets filter view?

I have a sheet with a column of numbers. I'd like to create a filter view that only shows rows with a value greater than 500, but I can't find any way to do that. There are lots of different numbers, ...
1
vote
1answer
143 views

Google Sheets: filtering and matching a list treating NON-unique values

I have a list (column A) of non-unique text values. Items from that list are put into column B (via dropdown data validation). Any items from column A that are missing in column B are shown in column ...
0
votes
0answers
6 views

Excluding a Column Range from a Filter Equation [duplicate]

I've been bashing my head against this for hours. My boss has a filter equation running in column A that spits out a long list of ID numbers. In column B, there is a running manual list of ID numbers ...
0
votes
1answer
74 views

How can I open context menu for sheet in google sheets using only the keyboard

I know that there is a way to open the google sheets context menu via the keyboard, or there was one. However, I cannot seem to find it! For reference, this is what I am talking about (am I calling ...
2
votes
2answers
2k views

Facebook won't let me post in other languages

I am an admin on several Facebook pages, and have previously been able to post in different languages. However the last year or so, it is as if this function has frozen. When I click on the "write ...
4
votes
4answers
32k views

Show unique ID on the form (before submitting)

I need an anonymous form (no names, emails etc) that shows unique ID so that if a person decided to reveal that ID to me I will be able to find his/her answers in the spreadsheet. The ID can show on ...

15 30 50 per page
1
2 3 4 5
632