All Questions

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

Complicated Google Sheets Project

I am a teacher and am designing a tool to help teachers design units and plan lessons. I am new to coding and this is becoming a bit ambitious for me. I am happy with what I have so far but there are ...
0
votes
1answer
5 views

Help with a Vlookup function to return multiple results of not exact match

I am trying to run the following code to return all the matches of column A from column C in a set of rows. In this situation, cell A1, is contained in a few iterations of column C, however, these are ...
0
votes
0answers
10 views

Combining IMPORTRANGE, SUMIFS, QUERY with cells that contain numbers and text

I'm having an issue combining SUMIFS with ImportRange in Google Sheets. I found answers suggesting to nest it with QUERY. However, the issue is that one of my criteria is non-numerical. Formula in ...
0
votes
0answers
7 views

In Trello, is there a way I can see all cards assigned to me within a specific team and then assign them an order?

I'm a member of Trello team where boards correspond to individual projects, each list under a project corresponds to a type of task. (e.g. bugs, features, etc.), and each card is an individual task. ...
-1
votes
0answers
4 views

What if both person on messenger shows active “1 minute ago”and “active now”at the same time and it happens more than 10 times

What if both person on messenger shows active "1 minute ago"and "active now"at the same time and it happens more than 10 times.
0
votes
0answers
5 views

Slack indicates unread messages in the tray icon even when set to only notify for mentions

I'm in a couple pseudo-public workspaces on Slack that have quite a bit of activity. I've gone into my settings for these workspaces and all the channels in them to make sure that I should only be ...
0
votes
1answer
18 views

How Can I Ignore Null Cells in a Google Sheets Chart?

I'm generating a chart where I have to have some empty cells due to the way my data is formatted. However, I cannot figure out how to ignore those empty cells when generating a line chart. I've tried ...
-2
votes
0answers
9 views

Build a document viewer like amazon look inside

i need to build a document viewer like the Amazon "Look inside". How can i build that? With Html/css or do you know any free frameworks? I couldn't found anything. Thanks in advance!
-2
votes
0answers
6 views

Is there an Email limit?

Is there a limit on how many people you can email at a time if they are in a group? I have two groups that I email regularly, (104 & 95 members), but some folks do not receive the emails. Help!
0
votes
0answers
4 views

conditional formatting skipping colors after the same large value

Looks like the conditional formatting skipping large formula because of the same large values. Help me please how can I get the order what is on the picture in the column "What I would like".
-2
votes
0answers
7 views

Same email for two people?

Constant receiving junk email clearly aimed at someone in Australia plus I recently looked on Amazon and was directed to my recent browsing history to be shown a selection of games and computer ...
0
votes
0answers
9 views

Tumblr pages no longer redirect - How to redirect using pages on a Tumblr blog

It used to be that you could create Tumblr pages to redirect to posts or other non-Tumblr URLs. For example, you could create a page pets and redirect it to a post on your blog (using the post's ...
0
votes
1answer
11 views

Google sheets IF OR script

So this is the code that I'm using for the script that I found; function onOpen() { var s = SpreadsheetApp.getActive().getSheetByName('Todo'); s.showRows(1, s.getMaxRows()); s.getRange('D:D') ...
0
votes
0answers
4 views

Sort GitHub issues by title

It doesn't look like sort:title or sort:title-asc works Does anyone know of a way to sort within the tool?
1
vote
0answers
9 views

Is it possible to create a share link to a specific location in a Word Online document?

I would like to be able to send a link to a colleague, which will take him to a specific location in the document when the document opens in the Word Online web application. For example, a programmer ...
0
votes
1answer
8 views

Process visualization based on data

I am trying to use a Google spreadsheet to visualize a customer journey. I am trying to create the following graphic: I have created the following example spreadsheet: https://docs.google.com/...
0
votes
1answer
24 views

Simplify multiple OR statements in a QUERY using IMPORTRANGE

I am trying to query values from a different sheet using a range from the current sheet. Is there a way to simplify the formula and get rid of all the ORs? Like maybe using a FOR loop? =QUERY(...
1
vote
0answers
7 views

Conditional Formatting formula for alternating checkerboard with Merged Cells?

I wrote a formula that attempts to create a checkerboard pattern via conditional formatting, that should even work with Merged Cells. However, it seems to fail in an almost undebuggable manner with ...
1
vote
1answer
8 views

How to reference a local cell in QUERY?

I just about have formula 100% perfect. Just one issue: Formula (Works): =QUERY( ImportRange( "https://docs.google.com/spreadsheets/d/1Lf4r_b0fmFh6fClZsGmfZmo8ZD87qf8N_0f-Jaoyu-g/edit#gid=0", "...
0
votes
1answer
12 views

Google Maps grey dotted lines identified location

I clicked to search for directions on a place on Google and it redirected to Maps. Google was able to precisely identify my location The map displayed several thick grey dotted curves all converging ...
-1
votes
0answers
3 views

Google Form Drop-Down List questions based on previous drop-down list select

The majority of questions that I have found regarding Google Forms referencing the drop-down listing based upon another drop-down list selection (cascading), is directed to the Google sheets, or it is ...
0
votes
0answers
15 views

Excel Online can't see other people's selections

I found this on microsoft's website: Why can’t I see other people’s selections? You can see other people's selections in different colors, but only if you and other people are using Excel for ...
2
votes
1answer
11 views

Google Sheets date conditional formatting

I have dates in column D in Google Sheets. I want the cells to highlight red if 30 days have passed and there is not a comment date in column F. Example: Column D: Submittal Date 6/29/2019 ...
-2
votes
0answers
12 views

How to block a seller [on hold]

I've had a bad experience with a seller and want to be sure I don't give them repeat business in the future. Is there a way to block a seller?
1
vote
1answer
16 views

Array formula for adding letters after duplicate numbers in order

The below formula adds a letter after a sequential number, A, B, C, D, etc for the same number until it finds a new number, then it starts again from A. I need help on turning this into an array ...
0
votes
1answer
13 views

How do I filter news articles out of my google search?

I'm trying to google a topic which has a lot of heavy media coverage. I'm looking for technical details though, not any media coverage. The problem is the most combinations of search queries end up ...
1
vote
1answer
19 views

How to extract the first rows that have a unique value in specific column in Google Sheets?

The unique items in D are: 4,3,2. I wish to extract 3 rows for each D value, For each row, provide the first row that this D value appears. I tried using =query but it doesn't support grouping or ...
0
votes
0answers
39 views

Migrating accounts in Gmail

My school is quite annoying in that they want to delete all email accounts once you graduate. Having graduated I now have to move everything from one email to another, but the thing is that email is ...
1
vote
1answer
30 views

In gmail, how to filter messages to support@mycompany.com but not if they are also sent to me@mycompany.com

I'm receiving quite a lot of emails for support in my inbox that I want to filter out. A couple of weeks per year I'm on stand-by. In those weeks I need to be able to receive those emails sent to ...
0
votes
1answer
20 views

Google Sites: How to create Blog-like sites [on hold]

I'd like to create an internal sites for my company, in which we can post articles that can be tagged in multiple categories of tagging. For example, we have two categories "Country" and "Topics". ...
0
votes
2answers
17 views

Format Cells if greater than “value of the cell”

Values of K11–K13 are variables. On the Conditional formatting, I want to use the output from those cells in the "Greater than" function. Typing =k11 doesn't work. I'm not really sure on how to do it. ...
1
vote
1answer
9 views

Which filename extensions are NOT safe to move outside of a syncing Google Drive folder? (because the corresponding Google Docs will be deleted)

When syncing Google Drive to your computer, the following SHORTCUT files will be synced, which link to the online web-based Google Docs documents... .gdoc .gslides .gsheet .gdraw .gtable .gform ...
0
votes
2answers
16 views

How to extract email link text from Google Sheets hyperlink? [on hold]

Can you extract the copy email address text from a hyperlink? See example:
0
votes
1answer
9 views

Replies to my comments

So I comment on a video, and someone replies, the little notification pops up and I can read about half of the comment. There's no 'read more', so I click and it goes to the video in question but not ...
0
votes
0answers
9 views

How to getFullName()

I would Like a code example how I can get getFullName(), in google sheets. Basically, I have multiple users using Google sheets and would want that every time they edit I cell in the Sheet, there ...
1
vote
0answers
10 views

Google Sheets' IMPORTXML pulling from the wrong region

I'm using IMPORTXML to get the price of an electronics component from Mouser: If the prices are refreshed as a result of me editing the spreadsheet, it requests from my computer, and results in the ...
0
votes
0answers
6 views

Google groups show unread counts is not longer working for me

Google groups is failing to display the number of unread messages in each group next to the group. This feature stopped working for me a few months ago. I thought perhaps I had met some limit on ...
0
votes
0answers
34 views

Some Twitter GIFs don’t work in PC browsers, do work in mobile browsers

I could really use some help figuring out this very weird issue I have with Twitter GIFs. Some Twitter animated GIFs (which Twitter converts to MP4s, but I’ll refer to them as GIFs for simplicity’s ...
0
votes
0answers
29 views

Split Master Sheet into Multiple sheets

I have a master sheet where the data is like this: Would it be possible to split this into multiple spreadsheets so it can look like: and the sheets are divided into Weeks? Scripts or formulae are ...
-1
votes
1answer
68 views

How can I create a new password for my Gmail account?

How can I create a new password for my Gmail account?
0
votes
0answers
13 views

How to move row in Google Sheets after checking a check box?

I'd like to be able to move an entire row from one sheet to another after a check box is checked. In this spreadsheet I'd like to be able to check the "Letter Sent to Client" checkbox and have the ...
1
vote
1answer
14 views

Escape single quote in cell content in a QUERY

My Problem I have a Google Spreadsheet with two tabs - one containing regexes and values: And the other containing phrases which matches regex in the first tab, and a QUERY Formula that picks the ...
0
votes
0answers
10 views

Using Google Sheets Making Leaderboard System [on hold]

I'm looking to make a leaderboard where I can keep track of rankings for a game. Participants will play matches and the winner and loser will win/lose points based on a base amount +- the difference ...
0
votes
0answers
11 views

how to visualize time range data in google sheets

i have several thousand rows of data. Each row represents a task and includes the start time, end time, and data related to the task in the other columns. A task duration varies between 1 second to ...
0
votes
0answers
9 views

Unable to get comments on blogger [on hold]

I’m quite new to blogging stuff. I started using google blogger and did my first blog however, I’m not getting any comments. Even I tried myself to comment on it but neither I receive any emails nor ...
0
votes
0answers
12 views

How will Google Photos handle Apply Photos folder structure during sync?

I have over 200GB of photos stored on my mac and it's time to move everything to Google Photos. I have over 15 years of photos stored and many of the older images have little metadata associated with ...
-2
votes
0answers
9 views

Can I recover old chat of lost sim no. through same Gmail account [on hold]

I have lost old sim 9175899169. Now I want to recover old chat. I have same Gmail account. Can I do same
-3
votes
0answers
10 views

Code for a Python list programming [on hold]

In python list name contains these names: Name=["zam","tam","pam"] How to get an output like this: Zam Zam Zam Tam Tam Tam Pam Pam Pam And also like this: Zam Tam Pam Zam Tam Pam... without ...
-2
votes
0answers
15 views

Locked out due to “phishing”?

A week ago when I opened my Facebook app I was shocked to see that I have been “temporarily” locked out of it due to phishing. It says to click “continue” to verify that it’s really me and do the ...
-1
votes
0answers
16 views

Trying to calculate two time based intigers from same pool of resorces [on hold]

I have a pool of resources. Two time factors are eating into them, consumption & spoilage, i.e.: consumption 20 seconds for a unit Spoilage 15 minutes per unit in a stack (30 units per stack, ...

15 30 50 per page