All Questions

Filter by
Sorted by
Tagged with
-1
votes
0answers
3 views

How to get specific data from a website into a list

I want to receive data from this site so that it transfers the last 5 games and the results into a list. import discord import os client = discord.Client() mancity = "```L (0-1) , L (1-4), L (0-...
0
votes
0answers
5 views

Used incorrect email address setting up Facebook Business Page so I can't access the confirmation email

We are a start-up and my business partner's son-in-law set up the domain for us and Google workspace and we thought he also set up a domain email address hello@xxxxxx.com. Unfortunately, he hadn't, ...
0
votes
0answers
3 views

How to merge multiple Google Photos libraries into a new account including albums

I've accumulated a number of Google Photos accounts over the years which were pretty meticulously kept. There are lots of albums in each and lots of photos have many edits. I am trying to combine ...
-1
votes
1answer
11 views

HOW DO I CREATE A PIVOTE TABLE FORM A DIFFERENT WORKBOOK IN GOOGLE SHEET?

I have a workbook that has information from a form, and I need to analize it but in another workbook, how can I create a pivote table in a new workbook2 but using data from de workbook1
0
votes
0answers
5 views

Why did my YouTube comment disappear?

The following video: https://www.youtube.com/watch?v=q_otSO1Ab9w is a from a series of videos from the University of Florida. At the end of the video, there were the following links on the screen: ...
0
votes
0answers
16 views

receiving confirmation SMS messages (gmail)

receiving confirmation SMS messages (gmail) from phone numbers like this is normal ?, since the content of the message does not contain any word? can gmail send confirmation codes without any word ...
1
vote
2answers
20 views

Google Sheets reverse vlookup partial match?

I'm trying to return the length, width, height, and weight for each item (A1:E29) based on the data provided (G1:K10) I know how to do a vlookup partial match but this is the other way around. https://...
2
votes
1answer
69 views

Is it possible to make the most recently-created sheet the default?

In Google Sheets, if you have a Spreadsheet, then you can make individual Sheets (like tabs) within it. In my Spreadsheet, I've made a new Sheet every month for the last four months, so January ...
0
votes
1answer
16 views

Is there a way to get, programatically, the datetime of the last update to a google spreadsheet? [closed]

In our system we have google spreadsheets which content editors use. I have some processes which pull these down and save them as local csv files, so the data can be read in by the system. It would ...
0
votes
0answers
7 views

How to read/interpret full email headers from Gmail (or other email providers)?

I received a spam email which scrambled the typical "to:" and "from:" fields. However, instead of spoofing the "from:" address, which is apparently the more common tactic,...
0
votes
0answers
8 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 ...
0
votes
0answers
5 views

How to create a 2nd version of a Google Drive “ecosystem” [closed]

I have a series of Google Documents located within several Google Folders. Each of these Google Documents contains links to other Google Documents within these folders. Is there a way to automatically ...
0
votes
1answer
9 views

How to create a IF formula that searches for multiple (more than three) text options

I'm trying to create a Google Sheet to track pitches (I'm a baseball coach). I have a current sheet that I have a check box to click if the pitch was a strike or not, and then you have to choose a &...
1
vote
1answer
16 views

I want a CLEAN way of saying - this particular sender should always appear in my Gmail Inbox and never under promotions

I am amazed that there isn't an authoritative answer to this seemingly common request. No, I DON'T want to get rid of the Promotions category, which is mostly useful, but I want a simple way of ...
0
votes
0answers
7 views

Can Zoom be used to transcribe external audio (i.e. other than meetings recorded with Zoom?)

Is there a way to use Zoom's speech recognition and transcription features to transcribe audio files that were not recorded using Zoom? I.e. can I upload any audio file to Zoom and have it transcribed?...
0
votes
0answers
6 views

What languages does the Zoom transcription feature support?

The popular video conferencing tool Zoom supports recording of meetings and automatic transcription of recorded meetings via the webclient. I couldn't find any information on the supported languages ...
0
votes
0answers
14 views

I can't get password reset for LoL on Outlook

I have an outlook email for many years that receives all emails as expected but recently I needed to reset my password for a League of Legends account. The password reset email never appears. Not in ...
0
votes
0answers
11 views

Sort one column in multiple columns

I have a Google Spreadsheet with the information from a Google Form. The sheets updates automatically. I have a column with the hour of delivery. Now I want to sort that info in a new sheet. I can't ...
0
votes
0answers
5 views

How to add filter in Gmail to label any email which is from/to an email address from one of your Google Contact labels?

I want to make my clients' emails stand out more than just "important" allows, and also group them better. I have added all client emails to a Google Contacts "Label" and want to ...
0
votes
0answers
21 views

IF function that leaves the last number calculated if statement is true/false

I am trying to write a formula that updates a number in the cell if another cell is empty, and leaves the last number calculated if the other cell is not empty. I am calculating my profit, which ...
0
votes
0answers
12 views

How to modify small image (logo) left to the link shared on Facebook?

Links to my site when shared on Facebook have a small square image left to the text (see attached image) Which is actually cut from my logo. The logo is long and the cut looks ugly. I actually want to ...
0
votes
0answers
16 views

Formula to Reference an Outside Sheet If Specific Text In Cell Range Is Present It Will Compare Text in Two Ranges and Populate Text

I need a formula to reference an external workbook for to query a cell range for a certain entry to exist, and if that specific text is present, it will cross reference the a cell from a certain ...
0
votes
0answers
5 views

Add more conditional formatting cell highlight color options in excel online

In excel online (such as a spreadsheet tab in teams), you can add conditional formatting to highlight a cell that contains a certain value. But there are very limited options for highlighting colors ...
1
vote
1answer
29 views

Is there a keyboard shortcut to 'focus' cell I'm typing in so that the left/right buttons don't shift to adjacent cells?

I'm on a Mac, using Chrome. When I type abcde in a cell in Google Sheets, and then want to move the cursor to the left within abcde in order to backspace c, I have to manually click the cell to focus ...
0
votes
0answers
6 views

How to embed table from Google Sheets to Google Doc and preserve formulas & cell protection

I'm created a Google Doc posted to the Canvas platform for individual students to record data from an experiment. (see below for screenshot) In excel, I can easily insert AVERAGE formula for each row ...
-1
votes
0answers
12 views

Highlight edited cells [closed]

I want to conditionally highlight the cell that was latest changed/modified. what function is needed and can this be done within conditional formatting tab or will this be a script?
0
votes
2answers
24 views

Why doesn't “format A 'yyyy-mm' options no_values” strip the day from the output?

I have some input that contains a set of dates. I want to strip the day from the input and sort by just the month and year. I know there are other ways to do this, but why can't I set the format to ...
0
votes
0answers
14 views

Getting the latest date of something happening (with conditions)

So basically, I've got two sheets. One (sheet_1) with every single record in the system (over 11000 rows) and the other one (sheet_2) is querying information from that sheet. The relevant information ...
0
votes
0answers
24 views

Direct link to add email to contact in Gmail

In marketing and transactional emails I send to Gmail address, I would like to include a link, clicking on which adds my address to the recipient's contacts. I have read In Gmail, how do I create a ...
1
vote
1answer
32 views

Google Sheets: VLOOKUP formula for a multi line cells range

I have here a sample project, where columns A to C are in FORM RESPONSES TAB/SHEET and columns D and E are in RECORDS TAB/SHEET. In the RECORDS I have a list of names, in alphabetical order, and a ...
2
votes
1answer
301 views

What are the github achievements?

Github seems to have updated the achievements feature, so what other achievements are there? Is there a list of achievements and their unlock requirements? Didn't find any documentation and post about ...
-1
votes
0answers
7 views

Is social media engagement increasing? [closed]

I'm wondering whether Facebook and other social media are getting better over time in grabbing users' attention. Are they? How fast? Are there any data available that could indicate an answer?
0
votes
0answers
3 views

Adding individual users to a chat channel in Odoo

I use Odoo 14.0 . I created a chat channel for all my Odoo users. Still, not all user can see this channel, and I do not find an add user button in the channel administration. https://www.odoo.com/...
0
votes
0answers
5 views

After changing Facebook Page username it is showing broken link in Google search

I have changed the Facebook page username. Now it can no longer be opened in Google search. It indicate "link may have broken or It may have removed" . What is solution?
0
votes
0answers
3 views

Is there an official Stack Exchange android app? [migrated]

I saw a number of apps in the Play Store, but was wondering if there's an official one. I didn't see a link on the homepage. It would be nice to be able to check, and get Notifications, on my phone, ...
0
votes
1answer
8 views

Can I rename a file someone shared with me?

I have several clients who share docs with me. I can see these when I go to docs.google.com. Unfortunately, clients name their files things like "strategy" and I have many clients with ...
0
votes
1answer
11 views

Finding the longest time duration in Google Sheets

I'm trying to find the longest time value (hh:mm:ss) and I'm looking for it in column I, starting at row 5. I've already tried using the LARGE function but that outputs a decimal, not a time. =LARGE(...
0
votes
0answers
13 views

Facebook/Facebook Messenger settings conflict

So around six months ago a close friend and I stopped talking. Very long story as to why; it was hard for us both. He completely blocked me on Facebook. At the time I went on my Facebook Messenger the ...
0
votes
0answers
5 views

Summary of e-commerce transactions [deleted sales]

It happens to me that every 24 hours the data of the purchase transactions is erased. This problem has never happened to me as I have not had the opportunity to track sales on a website. The website ...
0
votes
0answers
6 views

Is there a browser extension to show upvote and downvote counts in reddit? [closed]

Reddit's redesign shows net votes (upvotes minus downvotes) and percentage upvoted (upvotes / total votes) on post pages, from which it's quite simple to work out how upvote and downvote counts. Is ...
0
votes
1answer
21 views

How to find and get data from only a certain, dynamic set of columns in another Sheet?

I saw a proposed solution here, but it didn't work for me. How to use arrayformula to find and get data from only a certain, dynamic set of columns? Using formula: =SUM(INDIRECT(ADDRESS(4, MATCH("...
0
votes
1answer
11 views

attempting to compile an output List, into a single cell in one Sheet, based on matching criteria in a range on another Sheet

I found a proposed solution on Stack, but I can't get it to work. https://webapps.stackexchange.com/q/120111/270308 Starting formula: =IF(G3<>""; JOIN(CHAR(10); FILTER(ARRAYFORMULA(...
0
votes
1answer
11 views

How to add arrayformula function to this formula with IF function?

I made a table that has two columns (namd & State). The 4th column(check) makes conditional formatting possible for any of these combinations: (if name is either "Ali" or "John"...
0
votes
1answer
15 views

How to change focus from one cell to a different row and cell [closed]

I'm trying to make an ID Card Tracking List in Google Sheets. Example: B5 would contain the issuance date. Once filled in the cell is no longer accessible, focus switches to C5, the expiration date. ...
0
votes
0answers
26 views

Import data from a different file but only if it matches some of the data in the new one?

I would like to copy information entered from another Google Sheets file but only if it relates to the information in the new file. For example, MR SMITH's employee number is entered into one sheet ...
0
votes
1answer
14 views

Range returning null using getRange

I am new to Google Apps Script and the docs are a little fuzzy on the returned data from a method call. I want to loop through a range, but it is coming back as null. What am I doing wrong? var ...
0
votes
0answers
24 views

Formula to Have Sheet Populate Data From Another Sheet If Referenced Cell Exists in Import Sheet

I am doing my best to write formulas, but I am still super new to it all. I am doing my best to figure out how they work and I am stuck at the moment. I am looking for a formula that can reference ...
0
votes
1answer
5 views

problems with form and appendRow

I created a form in Google Script and one of the fields is a Checkbox, the name of the field would be field1 [] and to save the answers in a sheet, I am using AppendRow, but when I insert the name of ...
0
votes
1answer
24 views

How to Import Data From Another Sheet If Any Data is Present In A Cell Range Corresponding to The Same Row

I am extremely basic in my understanding of coding formulas for Google Sheets, so please help where you can. The formula I'd like to put together is to search a vertical range (column) of information ...
0
votes
0answers
4 views

YouTube video still showing old title and description

A specific YouTube video keeps showing old title and description after clicking Save button although it shows the correct data in the editing mode. All other videos are updated successfully. What ...

15 30 50 per page
1
2 3 4 5
629