All Questions

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

Filtering views based on a cell having a value

I am trying to sort out a spreadsheet which has multiple columns in but don't really know where to start! I am looking to filter the sheet where column C has more than 3 errors for the ID on column B. ...
0
votes
0answers
10 views

Open App From Webpage [closed]

In specific websites(Example: https://stackedit.io/app), the top right corner displays a button. It's hover says, "To Open This Link Choose An App". I want to include this option in my HTML ...
0
votes
0answers
6 views

Get URL of image in Google slides

I've inserted an image via URL in Google slides but I don't remember it. Is it possiible to get the original source URL of the inserted image?
0
votes
0answers
4 views

Airtable filter base collaborator field to logged-in user

I have a base with a Collaborator field, for which I would like to create a view that is filtered to the collaborator who is logged in. The SharePoint equivalent filter is: Show items where column: ...
0
votes
0answers
11 views

Google Analytics - Share Assets via link not working for more than 1 person

I have created some custom reports in Google analytics and want to share these ASSESTS to other people having access to the GA account via "Share template link". However the 1st time I ...
0
votes
0answers
7 views

My Gmail editor shows a strange right-click YALIG submenu [closed]

When I right-click inside the Gmail editor, I get the following submenu. Clicking on the menu items doesn't seem to do anything. Does anyone know what this is, or what it's for? I can't remember ...
0
votes
0answers
5 views

How can I use a photo in Google-Drive in a text message using Message+?

I have a photo in Google-Drive that I would like to include in a text message using Message+. How do I do that? If I have to transfer the photo to Google photos, how do I do that?
0
votes
1answer
16 views

Determining type of hours worked past certain time of day

Link to sheet: https://docs.google.com/spreadsheets/d/1dwpeRWkkbX0adBeQkwMUI6PQa6WqRCNzNluSOw0RU5k/edit?usp=sharing Our business pays a different rate for drive time vs. site time. We also pay ...
0
votes
0answers
12 views

Is it possible to save files (e.g., screenshots) via a Chrome extension directly to a Saved Drive / Team Drive folder? [closed]

Is it possible to save files (e.g., screenshots) via a Chrome extension directly to a Saved Drive / Team Drive folder? I've been having trouble finding an answer to this, as most sites seem to focus ...
-1
votes
0answers
11 views

¿Como hacer que la formula siguiente: =CONTAR.SI($D$2:D3,D3), se ejecute con ArrayFormula? [closed]

La formula me da en cada fila el numero de veces que se va repitiendo el criterio, pero no he logrado ponerla en un ArrayFormula, para no tener que estar copiando la formula cada que se inserta una ...
0
votes
1answer
12 views

How do I code 3 series dependent drop down on multiple sheets?

I have a code to run a 3 tier dependent drop down list - it currently works for one sheet in my workbook named "BlankNode" but I need it to work for ~20 different sheets. I tried adding a ...
0
votes
0answers
18 views

Storage amount doesn't update [duplicate]

I deleted many messages from Gmail, about 1.5 GB. But the total google storage value (the one at the bottom of the page) has not been updated. Messages have been deleted via IMAP with Outlook. Trash ...
0
votes
1answer
14 views

Sync dropdown cells and edit it

Sorry English is not my native language but I can't find anything to this topic and I hope you understand my writing/problem and can help me. I have a huge google sheet with many columns. But for this ...
0
votes
1answer
12 views

Can I quickly sort Google Sheet via buttons?

I've got a Google Sheets document with a lot of data that I often need to sort. Google Sheets offers a sorting feature but I'd personally like button on the header that allows sorting of the rows ...
0
votes
0answers
4 views

How to sort numbered list on Google Docs in reverse order

I'd like my google docs (https://docs.google.com) numbered list to count backwards: largest number first, 1 last. Ex: 3, 2, 1, instead of 1, 2, 3. Any way to do that? Here is a sample document for you ...
0
votes
0answers
5 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
19 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
0answers
5 views

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

sorry I've been over this, but 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 ...
0
votes
0answers
13 views

Changing User Agent Not Working for Google [closed]

On my desktop PC, I went to Google to create a Google account. After filling in my name, my new email address, etc, it asked for my phone number. But when I create an account on my phone, it doesn't ...
0
votes
1answer
21 views

Pivot Table doesn't seem to be correct way to fix? Add rows based on data type and return value?

I am struggling with either using a pivot table or writing a query that will get the database in Columns A-E to format as Columns G-I. As you can imagine, I'm working with hundreds of thousands lines ...
0
votes
1answer
12 views

How Can I Take A Formula From One Cell And Display It In Another Cell?

When one cell references another that contains a formula, only the value is displayed. Is there a way to display the actual text of the formula in this second cell? Here's a simulated version of what ...
0
votes
1answer
5 views

Can't search drive files within Gmail anymore

I've noticed my queries using the search bar in Gmail don't return files in my Google Drive anymore. The files used to appear as a suggestion below the bar while I was typing. Is there a way to turn ...
0
votes
1answer
11 views

Array Formula Issue

So I have ArrayFormula checking Column C Price to see what range it falls in. Then it assigns the number based on that range it puts it in Column M. It works perfectly as a formula but when I make it ...
0
votes
0answers
4 views

No accept/reject buttons on MS Teams

Lately, lot of my users reported that they are not able to accept or reject my MS Teams invitations to add the event to their calendar, only the link of the meeting is showing up, They are all Gmail ...
0
votes
0answers
7 views

Javascript Function [closed]

Hello im new in Javascript please someone can help me to create a function that can return me the cxd value my code is this but i need to return me like a value, not console.log or alert let url_str = ...
0
votes
0answers
5 views

How to automate Enumeration and Cross referencing Exhibits

Given a series of three photos: Alpha, Gamma, Delta. and they are enumerated in two sentences: Exhibit 1 is a photo of an Alpha specimen, where as Exhibit 2 is a Gamma specimen. Recently a new ...
0
votes
1answer
8 views

Always mark as “Looks safe”?

Is it possible to mark emails that match a specific criterion as always "Looks safe"? I don't think I found anything matching in the filter settings.
0
votes
0answers
21 views

Sync multiple outlook Calendar with one google Calendar

In my website I need to sync a google calendar on which the customer can ask for a meeting, with outlook calender for each of my employees. Is there a way to do it ? Thanks.
0
votes
2answers
8 views

Is there a shortcut to insert current datetime as a static value in a cell in Google Sheets?

I have a table like this: Expense Date What it was for 120 CZK 4.5.2021. 12:30 Pizza coz I'm lazy I use it to log some expenses, not exactly for pizza but that's just an example. I also have ...
0
votes
1answer
12 views

Create a RAG system based on dates, upcoming and expired within Google Sheets

I want to create a RAG system in google sheets based on dates in a cell. Column A will show a date when someone is trained on a topic and column B shows the due refresher date (3 years later). I want ...
0
votes
0answers
4 views

Office 365 / Outlook: Automatically add a calendar entry (by email or API?)

We are using Office 365 / Outlook calendar to keep track of customer appointments. We have certain forms on our website for customers to request an appointment. After such a form is submitted, a ...
0
votes
0answers
12 views

How to get columns added automatically every Monday with previous week dates [closed]

I want our team to update data for the previous week every Monday. it's getting difficult to add columns and dates every week, is there any possibility to get the columns added automatically with ...
0
votes
0answers
16 views

How can I remove a previously public but now private GitHub repository from showing up on Google Search?

My GitHub repository named "mywebsite-io" (not the actual name) was a public repository for a few months and was indexed to Google Search before I converted it to private. When searching &...
0
votes
1answer
16 views

Trying to run two functions onEdit

I have found two scripts that work independently, but fail when combined. I get this error message ReferenceError: myfunction2 is not defined onEdit @ Code.gs:3. I want one field to populate the ...
0
votes
0answers
18 views

Help with auto generated data on Sheets - Baseball Pitch tracking [closed]

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. I posted a few weeks ago about how to ...
0
votes
0answers
9 views

I am getting input mismatch exception error continuously? [closed]

import java.util.; import java.lang.; import java.io.*; class Main { public static void main (String[] args) { Scanner sc=new Scanner(System.in); Servicecentre[] ab=new Servicecentre[4]; String n,b; ...
0
votes
0answers
7 views

Control User Access to Certain Apps in Slack

I have a slack channel and I want to add a Google Calendar to that channel. However, I don't want all members to view the calendar (only select members). Is there a way to limit which users can see ...
0
votes
2answers
14 views

Google Sheets Sigma notation to calculate series

I have to calculate a series but since the Sigma icon represents ALL possible formulas in the UI, it's very difficult to find a documentation on the actual "mathematical" summation symbol. ...
0
votes
2answers
22 views

How to pick a random row that also does not contain text in one cell?

so I have a google spreadsheet full of youtube videos. Column A looks if the video is already in column B, and if it is it says "duplicate" Column B is youtube link Column C is the title of ...
0
votes
1answer
10 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.
0
votes
1answer
14 views

duckduckgo - make it look exactly like google

Maybe it's just me, but I've gotten so used to the Google interface that I find the DDG interface "just not my taste". Any way to fix these issues would be awesome, URL at the top. Really ...
0
votes
0answers
11 views

What tool can I use to automate Facebook feed monitoring

I need to monitor the Facebook feed for apartment renting posts and for some other types of time sensitive updates. The functionality I need: Filter/split posts to categories/folders by content Rise ...
1
vote
1answer
22 views

How to use use cell references in the WHERE part of a QUERY / IMPORTRANGE formula

Can you tell me what's wrong with my formula? = QUERY (IMPORTRANGE ("url googlesheets database"; "Data range"); "SELECT Col1 WHERE Col1 =" A3 "AND Col2 =" B3 "") The "A3" and "B3&...
0
votes
0answers
20 views

Facebook Admin Personal Account Disabled (NEED HELP)

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
10 views

How do I block non educational content on youtube recommendations for Safari? [duplicate]

There've been a plethora of posts about users wanting to completely block all youtube recommendations. I too was considering the same thing, as I find it can be quite distracting. However I do use ...
0
votes
0answers
12 views

Making Youtube playlist a continuous stream

I have several Youtube playlists from a whole LP, for example Pink Floyd's The Wall. The problem is, it takes a moment from one video to another, sometimes making a cut in a continuous stream. This ...
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
0answers
28 views

How to set default phone for Google 2FA prompt (same phone number) without using Gmail prompt?

I don't know where else to ask this, so I'll start here... I want to use a Google prompt for 2FA on my new iphone. I've set it up and it shows up on the list of phones on my Google account, however ...
0
votes
0answers
4 views

How to use the microphone and speaker with textnow?

I'm not seeing a microphone icon when using textnow. This is on a Surface 3 tablet. How can I cause the app to prompt for microphone and speaker access? Is one browser preferred over another?
0
votes
0answers
8 views

Google Docs: how to selectively make section visible to certain users?

I would like to make a section of a Google document only visible to certain users. However the means to do this is non-intuitive; the primary collaboration controls are an all-or-nothing affair. How ...

15 30 50 per page