All Questions

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

How do I delete a Gmail filter that is set on a specific word - no other criteria and it does not show under filter with settings

I am learning how to set up filters for the first time and I mistakenly asked for a filter for the word Confirmation in "contains the word" instead of subject. Now my label for shopping ...
Jennifer's user avatar
0 votes
2 answers
36 views

How do I use google sheets to remove items as they are selected from a list that may include duplicates

I would like column C to be column A with everything in column B filtered out. Column A may have duplicates and those should carry over into column C, unless the same number of that item appears in ...
KyAnSan's user avatar
1 vote
0 answers
31 views

Can I replace percentages in legend with another value?

I would like to change the default percentages shown in a Google Sheets Pie Chart with the actual dollar values. Is that possible? I don't see anywhere to choose something other than the percentages. ...
user avatar
0 votes
1 answer
28 views

Browser doesn't stay signed into Google when logged in using GMail app confirmation

I have a case where I have a forgotten the password to my main Google account. I can signin by following these steps: Type in username. Click "Forgot password?". Switch to the GMail app for ...
Melab's user avatar
  • 147
1 vote
0 answers
10 views

If I memorialize a Facebook account for a deceased person and they had set their account not to allow posting, will I still get the tribute function?

Suppose I memorialize a Facebook account for a deceased family member, and they had set their Facebook account not to allow posting (although comments on things they put up were allowed). Will I still ...
Edward Carlstedt's user avatar
1 vote
1 answer
25 views

I have some phone numbers with names in data set 2 that match some names in data set 1 without phone numbers... how can find these and condense?

I currently am working on creating filled out contacts in data set 1. I have around 600 names, some filled, some missing phone numbers. This set of data has several columns but the only one I'm ...
Camden Vicknair's user avatar
0 votes
1 answer
9 views

A filter is being applied to all of my sent emails, how do I stop that?

A filter is being applied to all of my sent emails, and causing them to be added to a folder they should not be in. How do I stop that?
Shali's user avatar
  • 1
0 votes
1 answer
28 views

Can I make it happen that when I check a checkbox I created in a cell it will not display that checked item anymore?

This all should happen in a cell. I have several items in checkboxes that when i select one or multiple it will not display that item anymore in the cell For example, this cell will contain: Option 1 ...
Marlon P Montebon's user avatar
0 votes
2 answers
41 views

Specify the Phase based on the Dates

I have dates listed in Column A and I want to convert them to Phases in Column B; e.g. if the date is >= 5 Feb 2024 is equal to Phase 1 & if the date is >= 1 March 2024 is equal to Phase 2 ...
Deccal's user avatar
  • 3
-1 votes
2 answers
48 views

How to sum across columns automatically?

Would like your help to solve the problem as file attached. https://docs.google.com/spreadsheets/d/1E3KTOYHuYIJy9uQKsvlXwbCpwL6cU1IHAQ-Yirb-AfQ/edit#gid=0 I would like each column to sum automatically ...
Anakin Teow's user avatar
0 votes
1 answer
30 views

Syncing two cells in Google sheets

Is there a way to sync two cells on google sheets? So if I have a formula for import data function from another sheet in a column, then I add notes about it in the second column, I would like the ...
Jamie's user avatar
  • 1
0 votes
2 answers
77 views

Formatting dates based on year

I'd like to create a Google Apps Script that changes the format of all dates in a sheet based on the year. If the date is in the current year, the format should be, e.g., Aug 5 If it's in an earlier ...
gills's user avatar
  • 192
0 votes
1 answer
14 views

SUMIFS with "AND" not "OR"

How can I make the SUMIFS more complex, to only SUM the negative numbers from A2:A4 ? (AND not to include the lines with "foo" string in the B column)
peterK88's user avatar
1 vote
1 answer
47 views

Recorded a Macro to Import a File in Google Sheets

I'm able to import a file from my disk using "File Import". I tried to do the process while recording a macro. I did "File", "Import", then chose "Upload new file&...
NealWalters's user avatar
0 votes
0 answers
17 views

Googlesheets Filter or Query, to select values matching a Row by value and Column by IsBetween date range

I'm attempting to make a general Profit and Loss report in GoogleSheets. The data I am using is in a Summary tab Summary by Purchase Category. Each row in Col A represent a category, and Col D:O ...
Eli's user avatar
  • 1
1 vote
2 answers
43 views

Generate formula programmatically

I am trying to generate a large number of formulas programmatically. I can easily generate a formula text doing something like ="=1+1" (in reality it will be a bit more complex). This will ...
Luca's user avatar
  • 113
0 votes
1 answer
18 views

Apply conditional formatting based on dates listed in row

I am trying to track support hours in a shared document and want to have the entire month turn red if the number of support hours allocated in the month exceed the client's allowance. The date of a ...
Christian Guest's user avatar
1 vote
1 answer
22 views

IF OR conditions & FILTER in google sheets

This is what I am trying to accomplish: If column A = "blue", OR column A = "red" AND column B = "sold", get sum of column C Here are my attempts: =SUMIFS(or(C:C, A:A, &...
google geek's user avatar
1 vote
1 answer
36 views

How to copy and paste by using apps script, to the bottom of a list, where the bottom will change after every paste?

I have a system set up in Google Sheets that, from an input produces an output in 'Mover'!K2:V, and that output has to be copied and pasted 'values only' to the bottom of a list on another sheet '...
BMAli's user avatar
  • 19
0 votes
1 answer
12 views

Using Office 365 with Parental Controls

I'm trying to set up a child's Chromebook with parental controls active. Given that Microsoft removed their apps from Chromebook, I'm trying to allow them to access office.com online version instead. ...
DarkWanderer's user avatar
0 votes
0 answers
12 views

View old/past snoozed emails in Outlook

In Outlook, I sometimes snooze emails because I am on the go or busy and want to look at them later and they are probably important. However, when the day or time that I was supposed to take a look at ...
simplegamer's user avatar
  • 1,190
1 vote
0 answers
8 views

How to apply mutiple labels on one conversation in Gmail using keyboard only

I use keyboard shortcut a lot for gmail. Always using L and V to apply label and move conversation. However, I can only apply one label at a time using shortcut L. I am wondering if there is sommthing ...
G Tien's user avatar
  • 11
0 votes
0 answers
16 views

How can I search for calendar events that are more than 1 year old on Outlook on the web (OWA)?

I want to look at some meeting info that occurred more than 1 year ago. I just know the email address of one of the participants of the meeting. Therefore, I go to https://outlook.office.com/calendar/...
Franck Dernoncourt's user avatar
4 votes
1 answer
642 views

Does the Facebook app steal my contact information? [closed]

Facebook has made three friend suggestions who are not related to me in any way except that I had added them to my phone contacts at some point. Did Facebook make these suggestions because they stole ...
Zaman Nipu's user avatar
1 vote
1 answer
29 views

Is it possible to take folder "Shared with me" and use it as a "Shared drive"?

Someone has shared a folder chock full of stuff with me. I would like to view its contents on my file system like a shared drive, rather than having to download items one by one from the web page. Is ...
Edward Falk's user avatar
0 votes
1 answer
19 views

How to read encrypted email send from Outlook 365 to an outlook email address

I received an encrypted email in outlook probably from someone with Microsoft 365. I do not have Microsoft 365. According to https://support.microsoft.com/en-gb/office/send-view-and-reply-to-encrypted-...
Kvothe's user avatar
  • 129
0 votes
2 answers
39 views

IFS Formula Not Working

I can't seem to get the following formula to work in my google sheet. =ARRAYFORMULA(IFS(Q2:Q=3,"1",Q2:Q=2,"0.8",Q2:Q=1,"0.6")) It is looking at a score column which is ...
user avatar
1 vote
0 answers
17 views

Custom search query to show all replies in a post

I use tweetdeck and it only loads some responses made to a post, so to see all replies I would like to create a new search column where the result would be the replies to that specific post, is there ...
Digital Farmer's user avatar
0 votes
1 answer
28 views

Modification of the Google Sheet script for email notifications

I use the code from this answer in my file: https://webapps.stackexchange.com/a/149424/316384 Can someone help me modify it so that the script sends an email when the value changes to the one I set? ...
robisy's user avatar
  • 27
1 vote
0 answers
24 views

Perpendicular (orthogonal) lines in draw.io

Is there a draw.io option to constrain two lines to be orthogonal each other? I found only these options, but they do a different job.
Federica Guidotti's user avatar
1 vote
0 answers
33 views

How can I stop a former FB friend showing in my contacts list in Facebook.com

The right-hand side of Facebook.com shows a Contacts list, and each contact's current online status. I have ended a difficult friendship with someone but they still show in this list. I have already: ...
Mr. Boy's user avatar
  • 568
3 votes
1 answer
41 views

What's the difference between using "<>"&"" vs. "<>" in Google Sheets formulas?

For Google Sheets, I've seen people use both =COUNTIF(range,"<>"&"") as well as =COUNTIF(range,"<>") to count the number of non-empty cells in a range. Is ...
Kir_Mal's user avatar
  • 41
1 vote
1 answer
19 views

How does Discord decide which messages to show below a channel in the left menu?

Discord shows some of messages below a channel in the left menu: How does Discord decide which messages to show below a channel in the left menu?
Franck Dernoncourt's user avatar
1 vote
0 answers
7 views

How can I change the microphone and speaker settings of the web version of Facebook Messenger without making live calls?

I see the microphone and speaker settings only when I am on a live call. And, before I can change the settings, the call is disconnected. I am not finding the settings options where I can fix those ...
user366312's user avatar
1 vote
0 answers
28 views

What is the current url format for Google Image searches?

I use a program called Cold Turkey on my laptop that blocks specific URLs, and until recently, I was able to block all google image searches as they shared part of their url. Now, however, it seems ...
user avatar
1 vote
1 answer
32 views

How to stop + and - from generating formulas using Apps Script Google Sheets?

My Problem I have a column of data for users to input text, and it is highly expected that they should add a plus or minus before text, which would result in an error. For example, they are often ...
Cameron Schwarz's user avatar
2 votes
0 answers
20 views

How do I add an existing custom domain email to my gmail inbox without Workspace? [duplicate]

I have a website with node.js deployed on AWS Amplify. Right now, I have mx records that merely forward mail to a gmail address. I want a gmail inbox that I can send emails from without using Google ...
BigMistake's user avatar
2 votes
0 answers
55 views

How to disable YouTube “Someone liked your comment” notifications?

I have access to two YouTube accounts. One of them shows notifications on the YouTube website every time someone likes my comments. The other does not. These two accounts seem to have the exact same ...
2540625's user avatar
  • 305
2 votes
2 answers
92 views

How can I privately bookmark a message in Discord?

I can privately bookmark a message in Slack with the "Save for later" feature as follows: How can I privately bookmark a message in Discord? From my understanding: pins are not private ...
Franck Dernoncourt's user avatar
0 votes
1 answer
23 views

Counta and Array_constrain formula in Google Spreadsheets

I am creating a sheet in google sheets to look like a dashboard from the below data. I am asked to create this with formulas. I am getting the filter part correct. But changing the values from filter ...
Ramya's user avatar
  • 1
0 votes
1 answer
35 views

Conditional formatting based on data lookup and comparison

I have a google sheet for a sporting club. I am trying to make a set of cells turn red when a player is scheduled to referee their own game. I have a ‘Lookup’ sheet that has team listed with a list of ...
Markus's user avatar
  • 3
1 vote
0 answers
38 views

How to add embedded hyperlinks in a Monday.com form?

I'm currently developing a form on Monday.com and have encountered a limitation that I'm hoping to find a workaround for. The core of the issue is that I need to include embedded hyperlinks within the ...
Bilesh Ganguly's user avatar
0 votes
0 answers
47 views

Where can I view the history of the questions I asked Gemini when asked through Gmail/Drive?

Google Gemini can be used in Gmail, Drive, Docs, Slides, Sheets and Meet. E.g., in GDrive: Where can I view the history of the questions I asked Gemini when asked through Gmail/Drive? I don't see it ...
Franck Dernoncourt's user avatar
0 votes
1 answer
40 views

Where does YouTube save the videos when I click the save button?

When I am using YouTube in a web browser and I click on the save button for a video, how do I find it later? For example, if I save a video under the tag "Recipes", where can I find that tag ...
Ole's user avatar
  • 143
1 vote
1 answer
27 views

Editing the second line in all cells

I am creating a sheet in which the first column has two lines of text in every row. How can I bold the second line only in all cells without doing it manually as I already created the sheet.
Jaclyn's user avatar
  • 11
1 vote
0 answers
41 views

How do I delete some gmail suggested email addresses during composition [duplicate]

How do I delete some Gmail suggested email addresses during composition. In the composition window of Gmail web UI, I click TO: and see 6 emails for [email protected] -- 5 are not valid anymore and ...
theMezz's user avatar
  • 11
2 votes
1 answer
35 views

Rearrange columns in Google Sheets

I have data in Google Sheets that I want to rearrange. In each row, starting from the 4th column onwards, there are repeating column pairs of Favorite Fruit # & Favorite Color # where # indicates ...
user323956's user avatar
1 vote
1 answer
39 views

How can you copy and bunch words into a different column? [duplicate]

I was wondering if there was a way to return the contents of a column but skip the blank rows to better utilize the space. I have tried researching this, but have not found anything. Every solution I ...
Nolan's user avatar
  • 11
1 vote
1 answer
19 views

Hide a value in a cell unless another cell has a given value

I'm trying to create a formula to generate a list of values in a dropdown. Each row contains a task that has a status, and a priority. The priority is set from a dropdown containing a list of numbers ...
Christian Guest's user avatar
1 vote
1 answer
41 views

Create a shared album combining photos from multiple OneDrive accounts belonging to the same family group

Recently we went on a family trip and everybody was taking pictures. We all are part of a Onedrive family plan. How we can create an single album that includes everyone's photos? Do we each need to ...
Mykola's user avatar
  • 113

15 30 50 per page