All Questions

Filter by
Sorted by
Tagged with
0
votes
2answers
369 views

Can Weekday value be shown in natural (Su, Mo, Tu..) format in Array Formula?

For Google sheet with the following data in A2:B4 06/29/2019 1:25 PM 1 06/30/2019 1:32 PM 1 07/01/2019 1:40 PM 1 The output will show Monday 1 1 Saturday 1 1 Sunday 1 1 Can this be ...
0
votes
1answer
39 views

Default custom fields in Asana?

What are the custom fields that "ship" with Asana? For example, if I go to Add Fields > Add Existing Field to Project, I see a list with a bunch of fields I can choose from. Some of those ...
0
votes
1answer
24 views

LinkedIn show different title of a same post when user logged in and without login

I am facing some weird problem in LinkedIn. I have shared some post on one company page. when I checked this post without log in it show correct title of the post but after logged in the post title is ...
0
votes
1answer
1k views

Count in QUERY to include counts for all unique items (dates)

=query(A:B,"Select A, Count(B) where A is not null and B='A' group by A,1")
0
votes
1answer
110 views

Can we check the status of AOL mail?

Long ago, there used to be a button to click in our AOL mail: Status. We could see the status of a sent email, whether it was read, ignored, deleted, etc. I no longer see this option. Do we still ...
0
votes
1answer
1k views

Equivalent of IMPORTRANGE with script in Google Sheets [closed]

Since the Importrange() is not working as expected, do you know how I could express e.g the following function with a script? ={IMPORTRANGE("SheetKey","SheetName1!A:J") ; IMPORTRANGE("SheetKey","...
0
votes
1answer
64 views

Subtract different percentage based on quantity range

I want to be able to provide a different percentage discount based on the quantity purchased. The percentage should be based on a range, so for example: QTY > 0 && <= 5, discount = 5% QTY >...
0
votes
2answers
586 views

Direct YouTube link as background video not working

I have video banners using the direct mp4 link to YouTube videos using the solution posted by 'ale' here This worked perfectly yesterday however when viewing the site today, none of the videos load ...
0
votes
1answer
24 views

Why did my emails from a listserv stop threading?

I am part of a listserv that until late March, threaded messages from the same conversation. After late March, each reply to the same conversation comes in as a separate message. What can I do to fix ...
0
votes
1answer
375 views

Dynamically reference DATA in Query in Google Sheets

I have a query in a Google Sheet structured like so: =QUERY({IMPORTRANGE(Expenses_2018Q4,"DATA_Expenses"); IMPORTRANGE(Expenses_2019Q1,"DATA_Expenses");IMPORTRANGE(Expenses_2019Q2,"DATA_Expenses")},"...
0
votes
1answer
25 views

Home directory showing-up twice in Mediawiki links

I recently installed Wikimedia for a tiny non-profit organization, as I am the technical person on the board. With this fresh installation links are showing the home directory twice. Example: (our ...
0
votes
1answer
697 views

Date and time keyboard shortcut for Google Docs document (not sheets)

I am trying to find out if I can set up a keyboard shortcut to print/type in the current date and time in a Google Docs document (not sheets). Anyone? The best I could find is an Add-on Text Factory ...
0
votes
1answer
41 views

Is it possible to set dates across a row of cells where each cell date counts back different amounts of weekdays from a completion date?

I manage digital marketing campaigns from end-to-end, and there are various steps within each campaign's production process that are due certain dates out from and relative to a final launch date, ...
0
votes
1answer
499 views

How to select existing sheet to be populated by a Google form?

I have a team working in pan India with 6 Team leaders. I have created a Google form to collect the everyday status report. Now the question is: How can I assign a particular sheet[already created in ...
0
votes
1answer
2k views

How to import historical open price in Google Sheets with GOOGLEFINANCE?

For some reason, I can't get the google finance function to work with any open-price lookups I do. For example: =GOOGLEFINANCE("AAPL","priceopen", DATE(2019,4,12)) comes back as #N/A with message: ...
0
votes
1answer
93 views

Using a cell value, to dynamically create a formula, that links to a cell in a different sheet (tab)

Ok. This is a bit complicated, but I will do my best to describe the problem. All of these elements are located in multiple Sheet pages (Tabs) within one singular Google Sheet (Workbook). Sheet 1: ...
0
votes
1answer
778 views

Grabbing only non-empty cells from a row range for every row

I have a survey that sends responses into a Google sheet. The raw data that is inserted is messy, so I have another sheet that processes the incoming raw data. One of the things I need to do is: from ...
0
votes
2answers
64 views

Format cell if all the cells in a row are not empty

I tried all kind of formula but they all seem to work the other way around for me. I have a very large sheet with lots of columns. I'd like to have the first cell in the row to be a certain color if ...
0
votes
1answer
32 views

Can I navigate from a pivot table back to the original database?

Once I am "in" a pivot sheet, is there an easy way to click on a row or cell in the Pivot table and navigate directly back to the related data in the original database (Google Sheet), from which the ...
0
votes
1answer
422 views

How to create a filter with bcc or cc

When I create a filter in gmail I can enter values for the from and to field like this: However, I can't add any value for cc or bcc. I need to create a filter where bcc is from example@mail.com . ...
0
votes
1answer
30 views

Copy Google form and linked sheet preserving existing formulas and formatting?

I am required to copy an existing Google Form, however, the linked results sheet has deep formatting and formula. Apparently, the new form requires a new sheet to be linked to form results. How can ...
0
votes
1answer
155 views

How to reference a cell while keeping its color formatting?

Is it possible to reference a cell which contains "ABC" where B is blue and C is yellow while keeping the color formatting? Assume A1 contains the colored text, then I want B1 to refer to A1 and ...
0
votes
1answer
73 views

My GMAIL Has Been Deleted

All gmails from june of 2018 have been deleted. Everything is gone. It was fine the last time I signed in. How can you recover my messages.
0
votes
2answers
16 views

How Do I Quickly Merge A Large Amount Of Cells?

So I'm trying to merge all cells in Col A and B so that A1 and B1 are one cell all the way for 150 rows, anybody knows how?
0
votes
0answers
971 views

Bot telegram that copies and forwards messages from a chat or group?

I don't know if it's the right community so if I'm wrong, tell me where I should write ... However I would like to know if there are any telegram bots that automatically copy and forward messages in ...
0
votes
1answer
88 views

Formatting script applicable to a range, not an entire sheet

I have the following script, which applies formatting in row 1 to an entire spreadsheet. How can I limit the formatting application to a range (ex. A7:AN135), so that the header rows are excluded from ...
0
votes
1answer
454 views

Google Spreadsheets timestamp

I'm trying to have a timestamp automatically appear in column L (12) in a Google Spreadsheet if a tick box is ticked on the same row (in column A). The app script code that I modified from this source ...
0
votes
1answer
36 views

Display name of sheet with highest value in cell

I have a sheet for each data set i have. I want to display in a cell the name of the sheet with the highest value in all the B2 cells.
0
votes
1answer
22 views

How do I insert different cell data from a table into a hyperlink?

I have a table of different cell data that I want to insert into different hyperlinks for each item: =HYPERLINK("https://www.otcmarkets.com/stock/CELL DATA TO BE INSERTED/security","SECURITY") Cell ...
0
votes
1answer
325 views

How to ignore certain strings when creating unique list of words in Google Sheets?

In Google Sheets, I am using the formula to create a unique list of words: =unique(transpose(split(ArrayFormula(concatenate(B2:E"+")),"+"))) But I want to filter out certain strings. My unique list ...
0
votes
1answer
79 views

Method to preserve cell reference in a formula upon adding rows in reference sheet?

I have a Google Sheets with two(2) tabs. The first sheet is just a running tally of raw data and is updated with new rows at the top weekly. In tab 2 there is just a single query(arrayformula)... ...
0
votes
1answer
43 views

How can I see backups for corporate accounts in Google Drive?

I have a personal and a corporate Google account, the corporate being in the domain of my company. When I head to my personal account, I see a tab "backups" in the left side of the page as shown in ...
0
votes
2answers
35 views

Is it possible to have Twitter alert me when someone tweets?

I have twitter installed on my iPhone and wanted to know if it was possible to have my phone alert me when a particular user tweets?
0
votes
1answer
406 views

Google Sheets Two-Way Databinding?

I want to make a spreadsheet in Google Sheets with a user friendly editable front end and a back end with an arbitrary number of rows containing the data to be displayed. There should be a dropdown on ...
0
votes
1answer
467 views

What difference between these video files might make YouTube accept one and not the other?

What difference between these files might make YouTube accept one and not the other? Each is about 100KB or 150KB. Each of the two are one second long so are small easy to download and quick to test ...
0
votes
1answer
91 views

Divide data evenly in row, place in additional rows

I am using Goodle Sheets, and I have a simple problem. I am looking to divide the data by 4 in many rows, and place the results in new separate rows, replacing the original row. The new rows should ...
0
votes
1answer
1k views

How to TEXTJOIN in Google Sheets

I have ten columns in my rows which contain 5 sets of first name/last name. I want to combine each of these names in a final column using TEXTJOIN (or whatever function is appropriate if I'm missing ...
0
votes
1answer
452 views

How to make Google ask for password when switching between accounts

When using Gmail, have the option of switching between accounts by clicking the user icon in the upper right corner of the screen. Currently, can switch between the accounts listed when clicking the ...
0
votes
1answer
18 views

Collates the number of depots that don't have manifests and trunk headers

Trying to do a work project that collates the number of depots that don't have manifests and trunk headers. Column A: Depot Numbers Column B: No Manifest record (i.e if Colum B 2 - 200 contains "...
0
votes
1answer
564 views

Data validation if no then disable cell else drop-down lists

I'm trying to do a drop-down list IF another cell doesn't equal "no" So I have two columns: one with a drop-down list containing "yes" and "no" and in the other column I want to do a drop-down list ...
0
votes
2answers
46 views

Update each cell in column from upper right adjacent cell

How can I make the start mileage in each cell update from the end mileage in the upper right adjacent cell? Preferably using something like a single array formula that can be updated. I think I'm ...
0
votes
1answer
280 views

Get excel in sharepoint to google drive

Is there any way to import an excel file located in a sharepoint into a google drive site?
0
votes
1answer
915 views

Can't delete an inactive Instagram account

I deleted an old account a couple of years ago, however the account still appears on my iPhone for some reason. I can't remove it, log into it in order to properly log out of it to delete it ...
0
votes
0answers
161 views

Vertical alignment of text within a Gliffy shape

Given a basic container shape on a Gliffy diagram : we can see the Text formatting options only show horizontal alignment options: This is in contradiction to some documentation that I had found: ...
0
votes
1answer
2k 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
1answer
51 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
1answer
38 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
0answers
1k 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'" ...
0
votes
1answer
229 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,...
0
votes
1answer
26 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 ...

15 30 50 per page
1
557 558
559
560 561
615