All Questions

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

Google Sheets: updating cells that has been fetched by IMPORTRANGE()

I've got two Google Spreadsheets. Spreadsheet B fetches data from Spreadsheet A using IMPORTRANGE: =IMPORTRANGE("url", "tab!A1:JB19") What I want to achieve is to be able to write over fetched data ...
0
votes
0answers
5 views

Conditional Formatting Whole Rows in Excel Online

Does anyone know how to use conditional formatting on Excel Online? More specifically, I am looking into how you can highlight a whole row once a cell has something inputted into it. That way I know ...
-1
votes
0answers
4 views

Tool to automatically batch multiple CVs as pdf

Let's say I have CVs (saved as CSV, a database or any other data source) of many people. How can I generate a CV as a PDF file for each person individually that follows a general template, but ...
1
vote
1answer
7 views

Google Spreadsheet sum when filtering

I have spreadsheet that looks like this: Now when I filter on a company I want the total to display the sum of the whole of B column. Since I am very new to spreadsheets I was hoping someone could ...
0
votes
0answers
5 views

How to automatically forward all outgoing mail from one G Suite account to another?

I need to either BCC or forward all outgoing mail from a G Suite account to another account on the same domain. There used to be a setting to route email per account, but it seems to have disappeared....
0
votes
1answer
9 views

How many 'importranges' are being used in a selected Google Sheet

How to find out how many importranges are being used in a single Google Sheet.
1
vote
0answers
4 views

Google Docs: images are blurry when downloaded the doc as web page

I am having a Google Doc with good quality images. Later once my document is completed I have downloaded the web-page (HTML, zipped) version. When I saw the images in the folder they are of poor ...
0
votes
0answers
7 views

Is it possible to use Google Lens from the desktop version of Google Photos?

I frequently use the Google Photos application on my Android phone, where I make use of the Google Lens feature there. Right now I'm managing my photos from the Google Photos web application in ...
1
vote
2answers
18 views

How do I get the address of a range with a formula?

Let's say I have a range called WidgetTypes in cells C5:M5. I want my formula in cell A1 to return C5:M5 or $C$5:$M$5. What formula goes into cell A1? cell("address",WidgetTypes) returns $C$5 but I'...
1
vote
0answers
9 views

Gmail doesn't download 'suspicious' emails from server even though they are legitimate

I am migrating from G Suite to Personal Gmail via POP3 and am getting tons of these messages. "The message "Subject" from Someone (someone@somewhere) contained a virus or suspicious attachment. ...
2
votes
1answer
138 views

How can I use a formula to split a text into individual characters, regardless of length?

I have a list of words in Japanese. I want to write a formula that will input the word, e.g. ひらがな, and output it as an array of however many characters: ひ + ら + が + な, no matter the length of the word....
0
votes
0answers
4 views

Why is the corrected subtitles are not showing after the approval on YouTube?

Corrected version of my translation doesn't seem to appear on the video, there is still the old version and I can't even edit it now because it's locked. How am I supposed to fix this?
0
votes
0answers
20 views

Unable to filter rows in a sheet populated by QUERY

I am trying to filter one column A-Z to pair items listed in more than one selling app. However, if I apply an A-Z filter for a column with item codes, the sheet rearranges everything per the filter ...
-1
votes
0answers
8 views

Payroll Management System DataBase Design

Payroll Management System DataBase Design, let me know if i made a mistake for my normalization so that i can denormalize if it's good please give me some like.
0
votes
0answers
15 views

Facebook Friend List feature - nothing in feed, how to fix?

As manual here You can create lists to organize your friends on Facebook (example: Close Friends, Acquaintances) and see posts from a specific friend list all in one feed. I created a list with 5 ...
1
vote
0answers
10 views

How to skip the Inbox?

I get so many shopping emails, travel emails, etc. I want all my emails, except what I deem important, to go into a different mailbox so I don't see all of these on my iPhone. How do I do this?
1
vote
1answer
19 views

Help to modify code please

I would like to use this code : function onEdit(e) { if(e.range.rowStart === 1 && e.range.columnStart === 1) { e.range.offset(0,1).clearContent(); } } but only on a tab called '...
0
votes
1answer
28 views

Auto numbering Google sheets

I want to have auto numbering dependent on cell drop down box in helper column so i can sorted out. If someone pick Start in A2 to have number 1 in B2. Then if they skip one or two and chose Start ...
1
vote
1answer
19 views

How to calculate the following mathematical expression in Google Sheets?

I am trying to calculate the total money that can be made from dollar cost averaging every year using Google Sheets. For example: how would I evaluate this?
2
votes
1answer
16 views

Sumif and Sumifs with open ranges gives #ERROR in one sheet, correct result in other

Here's my test sheet: Localization is USA with timezone GMT+1 I've tried substituting ',' with ';' to no avail. https://docs.google.com/spreadsheets/d/1pZku_X6b49uMhKivnv3N1uv6sekYrhY12IlUct_Zudc/...
-1
votes
0answers
13 views

How to get current Logged in tenant from spring security and store it into thread local and then pass the value to the current tenant resolver class

Following hibernate multi-tenancy database approach https://dzone.com/articles/spring-boot-hibernate-multitenancy-implementation, I am developing a multitenant application in which around 500 users ...
2
votes
0answers
7 views

Is it possible to filter/block sellers without free return while searching on Amazon?

I usually don't want to buy stuff on amazon if I can't return it for free. For some sellers, you have to pay the shipping cost when you return the stuff. While searching for products, can I filter ...
1
vote
0answers
6 views

Is it possible to filter/block all international sellers while searching on Amazon?

I've had some bad experiences with international sellers on Amazon. They fall into two categories: Shipping time: It took ages until the product arrived (sometimes more than 6 weeks; mostly sellers ...
2
votes
1answer
33 views

“Invalid Input, must be item on specified list” Google sheets error

I am super new to anything coding and google sheets. All of what I've done was was trying to follow the directions of another question I saw on this site. However, as expected, nothing is working! ...
1
vote
1answer
21 views

“Calculating formulas” in Google Sheet disaster

I have a worksheet with 13 sheets. the largest one has 2000 rows. I have already deleted all the possible blank rows i could. I have also read all the guides on how to make a Google Sheet faster and ...
1
vote
0answers
4 views

Sort YouTube comment history by likes

I was curious to see if there was any way I could see all of my YouTube comments, and there is, in the history section. I have a lot of comments, and after scrolling through them for a while, I wanted ...
0
votes
2answers
10 views

Opposite of SWITCH function? (i.e. enums in Google Sheets)

In programming, I could use a switch/case statement to do something like this: func animalNameFromType(animalType: Int) { switch animalType { case 1: return "dog" case 2: return "cat" ...
0
votes
0answers
13 views

Non Business Hours Auto Reply in Gmail

I am trying to add an Auto reply to emails received during non-business hours. The vacation responder does not allow for this. Business Hours are Monday-Thursday 8:30 am-4:00 pm and Friday 8:30 am-12:...
1
vote
0answers
14 views

How to have font size adapt itself to cell size?

I have a document where I use one sheet for presentation purposes. It's like a window/viewer of the content of the main sheet (the cell contents are all references to the main sheet). I built myself ...
1
vote
0answers
30 views

How does Gmail's “snooze” feature work when I move between timezones?

In Gmail, if I snooze an email until some particular date and time (e.g. 1pm), then I physically go to another time zone and remain there, when does the notification occur? At 1pm in the new local ...
0
votes
0answers
24 views

recovery of gmail account [duplicate]

I have tried to access my account without any success. I forgot my password and have tried several times. A verification code is sent to me yahoo account and all goes well but I get a message that ...
1
vote
0answers
24 views

Insert image to spreadsheet from google drive folder, png image dose not show, why?

I have an image in a folder that I want to import into my spreadsheet (in a cell). I'm using the script from Insert image from Google Drive into Google Sheets (with some modifications). But this ...
-1
votes
0answers
11 views

Why doesn't slashdot allow editing replies? [on hold]

Instead of editing replies Slasdot.org shows users a preview. Supposedly this allows you to spot any mistakes and correct them before posting. However this doesn't work for me at all. Usually I want ...
-1
votes
0answers
19 views

Checking web app resources usage (for cloud)

I'm currently using VPS to host my web app which price is fixed per month. I read about cloud services such as Google Cloud Platform and their pricing is based on resources usage. My question is how ...
1
vote
1answer
27 views

How to treat data pasted into Google Sheets as number instead of text and sort accordingly?

I pasted a table into Google Sheets (part of Google Docs), and one column is 1/234 1/102 1/1222 1/83 and when sorted according to this column, the column data is treated as "text" and sorted ...
0
votes
0answers
10 views

How do I edit cells in Google Sheets, after filtering or importing a range [duplicate]

when I import a range, in Google Sheets, or I use the formula Filter(), I get an array of data. I would want to then be able to edit the imported/filtered data, is that doable? of course, without ...
2
votes
1answer
15 views

Add item to a google sheet's cell from url?

Is it possible to pass a URL to a google sheet and have the sheet append a new cell with content taken from a parameter in the URL?? Use case: In KDE (and other environment as well, perhaps), most ...
1
vote
1answer
13 views

Conditional formatting Google sheets

I want A1 on Sheet1 to change color based on specific text in cell B1 on Sheet2 or even different Book...is that even possible with custum formula? Tnx in advance P.S. =ISText(indirect("Sheet2!B1")) ...
1
vote
0answers
4 views

New Trello User - Sign Up with Company UNIX ID email or lastName.firstName Email?

We're just starting to use Trello at our company. I'm wondering if it would be worth the effort to standardize the email address for our Trello session. For example, my UNIX ID is john15@company.com ...
1
vote
0answers
6 views

Hangouts Contact is missing

I had a contact in my list for a month, now I don't see the person in my list. The last time I saw the person, their status was "last seen 4 weeks". Did that contact blocked me? I doubt if the ...
0
votes
0answers
11 views

No way to access admin of Google team drives?

My CEO and I both have super admin access to our google for business account but in the drive settings there are no options to set up or edit our team drives. We previously had a CTO who set them up ...
0
votes
0answers
16 views

Linked Google Sheet requires authorization although public

I have made a Google Sheet that links to another Google Sheet, using IMPORTRANGE(). Although the linked sheet has Public accessibility, I am still required to authorize access to the linked sheet. Why ...
-1
votes
0answers
15 views

Why are there no Google results for this query?

If I google [curl man page] there don't seem to be any results which is obviously not correct.
-1
votes
0answers
16 views

Query returning multiple results in the first cell, followed by rows with the remaining results

I have a Query returning multiple results in the first cell, followed by rows with the remaining results. The query and results are below. I've replaced = with contains, same results. I use many ...
0
votes
0answers
9 views

Short codes to yahoo groups? What do I do

Found an email sent from my spouse to a yahoo group containing only numbers? What are they for
0
votes
1answer
21 views

Reverse Shortened URL to Get the Original URL Before the Shortening in Google Sheets

I have a sheet where I collect tweets with links based on a search query. Twitter, however, is handing me for each tweet their short URL format (t.co) rather than the original URL that was shared. Is ...
-1
votes
0answers
10 views

How can I “void” a cell from a column to give me the correct average? [duplicate]

Google Pages. I need my page set up for 20 rows of data on a google spreadsheet (forgive my ignorance) Often I need to only input 15 or so rows of data. Sheets spits out an average at the bottom of ...
1
vote
0answers
24 views

Is Facebook Ad Manager the right tool to create and edit ads?

I am trying to use the Facebook Ad Manager tool for iOS to create and edit ads. I am on iOS 9 on a 32-bit iPad. I am finding the tool is so glitchy that I can't get through two screens without it ...
0
votes
0answers
14 views

Capturing Connections in Firefox

When Firefox loads a webpage, the bottom-left of the screen briefly displays connection information. For example: Waiting for pubads.g.doubleclick.net Transferring data from insight.adsrvr.org… ...
0
votes
1answer
21 views

How do I set up this checkbox formula in google sheets? I'm getting #N/A error

I have a list of players in my league and next to each name is a checkbox to show if they are active or not. I set up a formula that checks each of the 12 weeks of game play to see if a player ...

15 30 50 per page