All Questions

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

Extract the Day of the month (dd) from a date in Query()

I have a list of transactions for a month, all include a date (Column B - dd/mm/yyyy) and a £in figure (Column F). I want to create a table that shows the total taken on each day of the month so for ...
0
votes
1answer
3 views

speed up google sheet with large pivot table

I have several pivot tables that present 5-7 columns of data extracted from a sheet that has about 30 column and 5000 rows. That sheet in turn is updated everytime a line is entered in the orders ...
0
votes
1answer
17 views

Organizational-sensitive Gmail link

Problem statement I'm creating an internal dashboard for my organization, and would like to link to all relevant internal resources. That includes Gmail and Google calendar. However, just linking to ...
1
vote
1answer
55 views

Conditional Formatting IF/AND Google Sheets

EDIT 2: Test document. See comment of what I'm trying to accomplish in cell A1. https://docs.google.com/spreadsheets/d/1lqrPbVqSrO257PqOYKLuCTxG1iiLaL6KYawp1hu4n5c/edit#gid=0 EDIT: I've tried this ...
2
votes
2answers
31 views

Boolean test of whether a time is before or after midnight in Google Sheets?

I'm having a job trying to create a Google sheet which calculates the difference between the time I fell asleep and the time I woke up. Here's what I want to happen: Sleep time Wake time ...
0
votes
2answers
34 views

How to forward multiple emails at the same time in Gmail?

I looked at this thread and it does not look simple enough.
0
votes
1answer
15 views

Differentiating automatically and manually cc-ed YouTube videos

As suggested by the title, suppose I’m given all the video links under a YouTube channel. Is there anyway that I can tell if each video has close captions automatically generated by YouTube or ...
0
votes
1answer
35 views

How to use arrayformula to find and get data from only a certain, dynamic set of columns?

I have a table where my headers are dynamically generated from another source and can show up with any header values, in any order. In the example below I've got the header values: AA - BB - CC - ...
0
votes
0answers
2 views

Add to Managed File Types in Sharepoint Online

This documentation specifies the file types that are crawled during search indexing. I have some other plain acsii text files with extensions not matching any of the defaults. When searching for ...
0
votes
1answer
11 views

Why isn't “info” icon in Google Photos showing up for me?

I created a link to share a photo in Google Photos. When I view this photo under my own account I see an "info" button (an "i" with a circle around it) that I can click to see things like when the ...
0
votes
2answers
28 views

How do I “bin” results in Google Sheets?

I am trying to bin my results so my groupings have lower granularity - going from a 1-10 scale to a 1-5 scale. For example, any result 1 or 2 would be renamed to 1 in the next column, any result 3 or ...
0
votes
1answer
49 views

Changing a cell value based on another cell's color?

In my Google Sheets in column F, I want to include the word "LATER" based on magenta color (#ff00ff) that is in column B starting from row 227, how should I write this script? I'll really appreciate ...
7
votes
1answer
3k views

Edit message as new in Gmail

Is there a way to edit messages as new in Gmail? I wish for something similar to forward function but with the message body unaltered. Or for a better explanation to use existing emails as a template....
0
votes
0answers
6 views

Insert range using IF formula in SUMIF function with multiple criteria (using arrayformula)

I am using arrayformula with my sumif function which has several criterion and ranges to expand automatically across a set column (B). The formula below works perfectly: =ARRAYFORMULA(SUMIF('DATA'!$N:$...
0
votes
2answers
14 views

Auto Sort different ranges

I have a google sheet that I would like to sort different ranges by the 2nd column in each range. Example: A B C D E F G p 7 1 h 9 1 q 6 2 j 3 2 g 9 3 p 7 3 I need the range A:C sorted by B ...
0
votes
1answer
111 views

Google Sheets - Historical Data not returning yesterday

The formula below is been used to get the historical data until today: =GOOGLEFINANCE("GOOG","ALL",DATE(YEAR(TODAY())-1,1,1),"12/05/2019","DAILY") Unfortunately I don't receive today's data (until ...
0
votes
2answers
36 views

Is there a clever way to search YouTube comments of a specific video?

I found a service called Juphy which unfortunately did not work even though it said they offer searching through YouTube comments. I thought of scrolling down until all comments are shown and then ...
0
votes
1answer
20 views
0
votes
1answer
40 views

Gmail: Automatically detecting all caps in incoming messages, converting to bold

So I have a senior colleague who regularly misuses all caps to emphasize points. This is annoying to see regularly--especially in reviews of my work--so I am curious if there is a Gmail add on or ...
8
votes
3answers
66k views

How to format the date in this Google Apps Script

I've come across this rank checking script. I'm not sure exactly where I found it but it's built on Google Docs and a script which automates the rank checking process. I understand a bit of coding ...
4
votes
2answers
715 views

Combine Custom Formula with Colour Scale in Conditional Formatting

In Conditional Formatting in Google Sheets, I'm wondering if it is possible to combine the Format Cells if - Custom Formula is with a Colour Scale? It would appear not, but is there a clever ...
6
votes
1answer
511 views

Disable redirect notice in Google Calendar

I regularly click on links in calendar events for work and every single time Google Calendar first sends me to this page: Since when is the default response to a user clicking on a link, "Let's send ...
0
votes
0answers
7 views

Change text size and font family in Blogger Editor?

Is there a possibility that we can change the font size and family of text in the Blogger Editor itself? Exmp: I add this line to css from inspicter : p, pre { margin: 0; font-size: 16px; ...
0
votes
3answers
1k views

Multiple columns as one in an Google Sheets chart

I have a Google Sheet tracking data over days, logging data at different times during the day, example: Is there any way that I can have this data represented in a chart as one continuous line ...
1
vote
1answer
17 views

How to find a spreadsheet to which a form submits?

In my organization, we have recently found a form that is supposed to collect some kind of submissions from people. The problem is that we don't know who exactly created it and where are the answers ...
1
vote
1answer
20 views

Is there a way to generate many rows and columns from a single value?

Let's say I have a sheet with a single column that lists all of my clients with each row being a unique value: e.g: client1,client2,client3,client4,... Goal: I'd like that in a separate sheet, 2 ...
173
votes
14answers
133k views

How can Google Docs and markdown play nice?

I love Google Docs. I write notes, essays, correspondences, invoices, journal entries, business ideas, planning documents- everything on there. I also love the markdown format. I'm a programmer so ...
8
votes
1answer
212 views

How do I turn off Slack's new format while typing?

After an update, Slack now formats messages as you type them which is highly disruptive to how I type. How can I disable this feature and only show message formatting after I hit send?
2
votes
2answers
461 views

Collapsable/hidden text boxes in draw.io

If I want to add in a lot more information to a particular box, is it possible to create a hidden “note” section where I can add more detail without cluttering up the flowchart?
0
votes
0answers
5 views

duckduckgo blank screen when searching - using vivaldi browser

recently changed to using duckduckgo for search and vivaldi for my browser browser- just started using my pc, did a couple search just fine, and hour later did a search and every result is blank, no ...
0
votes
0answers
29 views

Youtube chat is unusably fast for me, but other people use it

When I try to use LiveChat or TopChat on the web page of a Youtube video, it can be too fast. It shows so many new messages, with a high frequency, that I can not follow my own one to one ...
0
votes
1answer
71 views

Only include search results that must exclude multiple words

Consider this search: rick's haven -bbq -barbeque -menu I am trying to find all results related to Rick's Haven as it relates to the movie Bird Box. However, there is a really famous BBQ restaurant ...
0
votes
0answers
6 views

Open telegram web site by a mobile phone number in link

Is there any way to open telegram application from a website being in a mobile? I know if you use telegram:// you can open telegram app, but how can I open telegram and create a new conversation with ...
1
vote
1answer
136 views

Is there a way to select a 'From:' alias based on intended recipient?

There is an old related (but not duplicate) question about automatically replying from an alias email address when an email is received to that alias. I have a catch-all address, me@example.com, set ...
0
votes
0answers
8 views

Sharing Blogger blogs in Facebook shows blog title and article title

I have a blog on blogger (blogspot), and when I want to share an article on facebook, the name of the link (the gray fild under the image) appears as: [Blog Name]: [Blog Post Title] I would like to ...
0
votes
1answer
3k views

Exporting Google SpreadSheet to PDF (filename referring to a cell D7)

I have developed a script which allows me to export a spreadsheet to a pdf file with a click of a button. I have assigned the script to a macro so that it is triggered by clicking on an image. Script ...
1
vote
2answers
460 views

Can't log into my Blogger account

I haven't been able to log into my Blogger account for my blog or into the Gmail of the same account. I remember the recovery mail that I'd connected and I've tried using the account recovery several ...
0
votes
1answer
75 views

Find most liked photo on my Facebook page?

I am runnig a Facebook page for my own photos, sharing them with friends. There is over 1000 photos this year, in about 10 albums. Is there a way to statistically analyse individual photos? For ...
0
votes
1answer
12 views

alt+click doesn't mark a message as unread on slack webapp

From slack's Keyboard shortcut menu (ctrl+/): Mark a message as unread --- Alt and click message But this doesn't work :( When I alt+click I get a clutched hand icon. Running ubuntu 16.04.
0
votes
0answers
511 views

Unable to access my Twitter account

I tried to login to my Twitter account but I got this message from them! Once I clicked on the "Call me" button, it would bring "sorry, the request failed. Please try again later." I've tried all ...
0
votes
1answer
343 views

Can editors of a Facebook Page request to join a group?

I've recently learnt that you can join a Facebook group as a page yourself, which is great for me as that means I can interact as the page rather from my personal account. However, when joining a page ...
2
votes
2answers
2k views

How to pull last value in a Google Sheets column and populate it across another worksheet column?

This is my first post here- I hope this is the right place for it, apologies in advance if it isn't. Context: I have a password protected presentation that I need to give users access to, but only ...
1
vote
1answer
15 views

How to remove unwanted email address from list of autocomplete suggestions in Gmail “To” field

I entered user@example.org but accidentally mispelled the address. then Gmail will most likely save the email for future reference. However, when you send your email, an email pops up in your Inbox ...
0
votes
0answers
5 views

lost labels from e-mails when I transferred to Chrome

When I transferred to Chrome from my new gmail account, I lost the important labels I had created to save important things in. I NEED these files! I hope Chrome did not delete my files! I cannot ...
0
votes
0answers
16 views
+50

Can't post to any subreddit, not even r/help

On Reddit, I cannot post anywhere, not even r/help. When I click on the post button it loads for about 15 seconds and then goes to my profile's previous posts page here. I can still post comments, ...
0
votes
1answer
19 views

Email undilivered to one of the receivers. will anyone get the mail?

I sent a mail a few hours ago( suppose to person A and person B) but one of them lets say person A has a system in place such that mails from unknown Id's are blocked but person B doesn't, so person A ...
4
votes
3answers
4k views

How can I easily merge the tabs of two Chrome windows?

I have two Chrome windows open with a bunch of tabs. I want to merge the tabs/windows so that all the tabs are in one window. Is there a way to merge them without manually moving each tab from one ...
11
votes
1answer
2k views

Deduplicate Google Photos photos

Is there an easy way to deduplicate Google Photos photos? All of the examples on Google are for Google + and/or Picasa. EDIT: I'm not storing google photos in my google drive, because then they count ...
6
votes
3answers
4k views

Formatting text in checklists in Trello, or embedding comments

How do I format text in a checklist, or embed comments, within a single checklist item in Trello? I would like to provide additional notes and a hyperlink for several items in a checklist, but I ...
0
votes
0answers
14 views

My conditional formatting 'equal to' not working

I am trying to show a particular entry is equal to or greater than another entry by having the condition turn the cell green. But nothing I am trying is working. All other formatting works but when I ...

15 30 50 per page