All Questions

0
votes
1answer
9 views

How to edit my business on Google My Business?

The old business is closed. The address is the same, but the Name and Type of business have changed. How can I edit this in? Jocelyn Ross Officiant on Demand (New Business Name) ...@gmail.com 630.640....
0
votes
1answer
12 views

Google Sheets Conditional Formatting for expiration dates

I need help! I need to create conditional formatting for expiration dates: Cells should stay green Cells should turn yellow when 1 month of exp. date Cells should turn red once expired
0
votes
2answers
9 views

Conditionally format cells that not match with range from Sheet2

I have two sheets in the same file where "sheet1" has cleaned up information and "sheet2" has the dump from my jira. Now I am trying to compare Column F from sheet1 and sheet2 to confirm if they are ...
1
vote
2answers
14 views

Change cell colour based on another cell containing text (day name)

I am new to Google Sheets and trying to create a custom formula in conditional formatting to make the fill colour of a cell change based on another cell containing a specific text. I want to change ...
0
votes
0answers
11 views

can a user see a list of private/locked channels on SLACK?

If there are private channels on slack, can a user without admin rights see the list of those channels?
0
votes
0answers
14 views

Conversation mode is on, but each reply from my friend ends up in a separate thread

The thread titled "<the subject>" started normally and numbered nine messages, when something strange began to happen: the replies of my friend get titled "Re: <the subject>" and end up ...
0
votes
0answers
13 views

How to stop Google Drawings from changing links when exporting as SVG

When I create a Google Drawing and add links to different elements, upon exporting the drawing as a SVG Google changes all of my links to point to a Google search redirector instead of using the links ...
0
votes
0answers
9 views

Take a Note from a cell

How do I get a Note that I put on a cell from another cell? I need that a range of cell share the same Note. It is possible?
2
votes
1answer
31 views

How can I exclude archived messages from the multiple inboxes view?

I turned off conversation mode. I set up a filter that applies the label Family to any email coming from a family member's email address. I set up a separate mailbox inside Gmail for any emails with ...
1
vote
1answer
18 views

How to filter only the highest value for each date based in a criteria?

I have a table with 3 columns. I want to filter only the highest value of column B for each date (A) if column C contains the code "red". My sheet: date entries code 08/04/2019 1 red 08/04/...
0
votes
1answer
17 views

Combine multiple sheets in one master file

I am applying the below formula where I want to combine the live data from multiple sheets to one consolidate sheet in horizontal format & here my header is same... but I am getting an error as: ...
0
votes
0answers
14 views

Incorrect contacts images when searching in Google Contacts

My company has its name given in each contact's details so I can display all contacts from that company using a search query. When I do so, I see some incorrect photos or no photos at all. When I ...
0
votes
0answers
16 views

@IFTTT: How to replace the domain in the EntryURL fed by a RSS source?

In "If this then that" I would like to replace youtube.com by invidio.us or similar services, which can pass youtube videos through a proxy. How can I do this without the need to create a self-hosted ...
0
votes
1answer
10 views

How do I arrange raw data in Google spreadsheet in group way?

I have a list of orders, like this: Paid $28.00 | 2019-04-08 15:14:20 Unpaid $00.00 | 2019-04-08 15:13:48 Unpaid $00.00 | 2019-04-08 15:12:58 Unpaid $00.00 | 2019-04-08 15:12:10 Paid $18.00 |...
1
vote
0answers
27 views

Why doesn't YouTube cache videos? [closed]

Normally, if we watch a video (or view an image), it's stored in the cache (local disk). But YouTube doesn't cache videos. As far as I know, they use the cache but it's temporary. As soon as browser ...
-1
votes
0answers
10 views

Trying to Download a flash application to run offline [migrated]

Background Since, flash support is ending one of my favorite tools to have on hand, www.pixlr.com/editor (Good old flash version), will likely shut down soon. Attempted Solutions I have tried to go ...
0
votes
0answers
16 views

How to select activated sheets cells in Google script, rather than sheet by name

I need my script to talk to the "current sheet" rather than sheet by name. Code as is, selects cells from sheet 2019 but I want the script to copy the values from the current sheet, and paste into ...
0
votes
1answer
5 views

How to split a cell into key/value rows?

Apple,3,Orange,4,Mango,10 How can I split this cell into key/value rows? Apple (a1), 3(a2) Orange (b1), 4(b2) If I just call split(), I get: Apple 3 Orange 4
0
votes
1answer
10 views

Outputting a cell x number of times in an array format

Using Google Sheets: Need to display a vertical list, where each occurrence in the A column of sheet1 is repeated based on the number in the B column of sheet1. I've created a dummy file to show what ...
0
votes
0answers
16 views

How to delete all my posts at once from a closed Facebook group

I want to unsubscribe a closed group, but I want to delete all my posts before. Is that possible? I'd prefer a solution which doesn't require me to find each post and delete it separately: it looks ...
0
votes
0answers
6 views

In Google Sheets, why won't a cell update unless I give it a “kick”?

TL;DR A cell in one sheet in a Google Sheets workbook refuses to update when it should -- i.e. when relevant changes occur elsewhere in the document -- unless and until a recalculation is forced, for ...
-2
votes
0answers
31 views

please help me asap! [duplicate]

Ok. so i think i tried to remove my account from computer. instead i accidentally deactivated it i think. I dont have the phone that they are asking for to get the code and it doesnt give me anymore ...
0
votes
1answer
22 views

How to download files from Facebook group?

I'd like to download Files hosted on Facebook group which I'm part of. I couldn't find any relevant API, and the following question at Quora points to extensions which are outdated. The first ...
0
votes
0answers
3 views

Identifying anonymous users on Google analytics 360

How do I identify anonymous user on Google Analytics 360? I mean only a small %age of users login and we are able to track them but what about those that do not login?
0
votes
0answers
10 views

How to set the default message direction in Outlook to right-to-left

When I compose a message in Outlook 365, it is by default left-to-right, and I have to click some buttons to make it right-to-left. Can I tell Outlook to always compose new messages or replies as ...
0
votes
0answers
11 views

Calculated field in google sheet pivot table

I encounter a problem when trying to make a simple formula in calculated field. I can't reference a column with a space on its name. For example, if my column is "Column A" : formula : "='Column A'" ...
-1
votes
0answers
23 views

How do I find out all the users who liked a tweet of mine?

it only show less than 50 newest users,but I want to see all users who favorited my tweet. is there any way to find out their twitter IDs?
-1
votes
2answers
41 views

I am getting :server IP address could not be found (DNS_PROBE_FINISHED_NXDOMAIN) on new Wordpress site

I'm trying to host a WordPress website on Google Cloud Platform. I purchased the domain from Google Domains. I was getting an Error: Token mismatch error on www.whatsmydns.net. The error has gone, ...
0
votes
1answer
8 views

How can a forumula be converterd to array formula in Google Sheets?

How can you convert these to array formula? =IF(COUNTIF($I:$I, $A:A)=0, "No", "Yes") and =CONCATENATE(C3," ",D3)
-1
votes
1answer
13 views

How can I search an argument in GSheets to return TRUE if the argument references another cell?

Hello! In some cells in the True Price Column, I applied a discount by referencing the cell Conv!C2. For example, the argument in D13 is =MROUND((D8 * 2) * Conv!C2, 5) where (D8 * 2) is me calculating ...
0
votes
0answers
66 views

YouTube glitch that sporadically inserts a static “subliminal” image for 1 frame of uploaded video

In the following video that I've uploaded to my YouTube channel, a still image from the beginning of the video flashes for 1 frame many times throughout the video. Here's an example right after the 5:...
0
votes
0answers
9 views

how to read csv file in zapier?

I'm setting up a Zapier trigger to do something with the values of a new csv file in Google Drive, but I can't get it to actually read the content of the file. I can trigger on all kinds of metadata,...
1
vote
1answer
16 views

How to have a table that updates across multiple sheets in both directions in Google Sheets?

I have two sheets, and a table that I want to be displayed on both sheets. I can use =('Sheet_name'!A1) to create a one-way dependency. However, is it possible to create a table that updates both ...
0
votes
1answer
23 views

Google Drive with same account on different gadget

If you uploaded a file to your Google Drive on your computer will your phone/tab that had the same account will be notified of the file?
-1
votes
1answer
58 views

How do I login to my Instagram account without a security code that is sent to my stolen phone

I was wondering how do I regain access to my instagram account without having to put in a security/verification code as my phone just got stolen and I'm trying to gain access to contact family and ...
0
votes
1answer
120 views

Remove old emails from Gmail matching criteria automatically

I want to delete the following emails: from:(reply@abc.com) subject:(for sale) older_than:1d It seems in the old Gmail interface it was possible to create filters to delete these messages. I am ...
0
votes
1answer
12 views

Value transformation in Google Sheets

I'm working with a table of data as following: User ID: Event name: 111 Event 1 222 Event 2 333 Event 3 111 Event 4 444 Event 5 111 ...
0
votes
1answer
13 views

How to disable new row when Google Form collects responses for Google Sheet?

When Google Forms collects responses, it creates an entirely new row in the Google Sheet which I don't want to happen because I am using a VLOOKUP for another sheet and it's not grabbing the data I ...
0
votes
0answers
7 views

Find what videos were in a playlist deleted by youtube

I recently received a notification from youtube that on of my playlists violated their community guidelines and was taken down. Is there any way for me to find out what was in that playlist? They ...
2
votes
1answer
17 views

How to show time in a YouTube description without YouTube hyperlinking the time to a certain point in the video?

I have a YouTube video description that contains text describing a date and time of a meeting in the format of $date HH:MM - HH:MM. However, YouTube is interpreting those as MM:SS MM:SS times and ...
0
votes
0answers
13 views

How to use Google Apps Script to skip slides in a Google Slides presentation?

I want to use "metadata" in the speaker notes for a slide to determine whether to skip the slide. The API provides a way to get the notes, which I can then read; does a method exist to apply the "...
0
votes
0answers
16 views

How can I prevent the Meetup.com e-mails from cluttering my Google Calendar?

How can I prevent the Meetup.com e-mails from cluttering my Google Calendar? It has to be, because of the confirmation e-mail that Meetup.com sends and Google Calendar automatically adds them to my ...
1
vote
2answers
3k views

Why am I being followed by a political opponent in Twitter? [closed]

Why would an influential political figure follow me in Twitter, when I'm a nobody, and all I've done to date is opposed his party's philosophy? He follows some 100k people, with a similar number of ...
0
votes
0answers
12 views

Trigger script in Google sheets with Zapier action

Is it possible to set an action in Zapier (like webhook) to trigger a Google sheets script? What's the right way to set this up? This has been driving me crazy so I hope there is someone out there ...
0
votes
0answers
5 views

How can I configure Microsoft Outlook web so that it automatically saves any received email attachment to OneDrive?

How can I configure Microsoft Outlook web so that it automatically saves any received email attachment to OneDrive? I don't want to have to click on "save in OneDrive" for each email that contains ...
0
votes
1answer
22 views

Using a script someone else made in Google Docs

I was looking for a script to add to a Google Doc that would automatically insert the current date into the document. I found the script on this page. The last step is to authorize the script and ...
0
votes
1answer
5 views

Creating a formula based on TODAY's day

I have column A (list of stock prices at close of day) A1=4/1/2019 | stock price A2=4/2/2019 | stock price A3=4/3/2019 | stock price each day will be added to the sheet automatically I want to take ...
0
votes
0answers
12 views

AT&T captured my yahoo email

today, AT&T started receiving my Yahoo email at "sign in" with an ad for att service and I can't get to my email to receive a verification code to maybe fix it. My address has always been xxx@att....
1
vote
1answer
21 views

How to get the largest initial values of multiplied columns?

I'm tracking performance for some athletes and we need a way to see their "Best" workout numbers meaning the highest numbers of (rep × weight). The table looks like this: The reps and the weight are ...
0
votes
1answer
18 views

Sonos to Slack - how to show the songs we play in a Slack channel

I work on a distributed team and I want my remote colleagues to know what we're playing in the office. We use Sonos. We bump beats everyday. How can I automatically send played tracks into Slack so ...

15 30 50 per page