All Questions

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

Youtube embeded webcam live streaming on website - same link

Is it possible to embeded a webcam live stream into a website using the same link? I mean that whenever I create a new webcam live stream, the same streaming url is activated. I know that this can ...
0
votes
1answer
6 views

What happens when multiple people edit a multi-page form?

Imagine I have a multi page Google form and the "edit after submit" option is enabled. Imagine we have a 3 page form with the following text questions: Q1 Q2 Q3 The form is submitted with blank ...
1
vote
0answers
5 views

Move the input caret to the search bar of Amazon without using mouse?

When I have navigated to amazon.com, is there anyway to move the input caret to the search bar without using the mouse, other than pressing the tab key six times?
0
votes
0answers
19 views

Query with sums and 2 columns on the left

I have problem with the query: =Query(Raw_Data!J$2:$BL,"Select J, Sum(U),Sum(V),Sum(W),Sum(X),Sum(Y),Sum(Z),Sum(AA),Sum(AB),Sum(AC),Sum(AD),Sum(AE),Sum(AF) where J contains 'CUS' and (AL='1-Revenues'...
0
votes
1answer
9 views

Adding elements to Mindmap/ Horizontal tree

This may be a basic question, but I could not figure it out even after spending a while on it and the documentation. How do I add new elements/nodes to a mindmap/horizontal tree? The blue arrow ...
-1
votes
0answers
16 views

Project reference number generator online

I have a construction business and a team of contractors. We are constantly having an issue where the contractors are unsure of what project reference number to assign their projects so as to maintain ...
0
votes
0answers
5 views

Error Message when I try to sync my Meetup calendar to my Google calendar

When I try to sync my meetup calendar to google calendar I get this message: Sorry This email address isn't associated with an active Google Calendar account: https://www.meetup.com/events/ical/...
-2
votes
0answers
20 views

You're not signed in on any Yahoo app. Use an alternate way to sign in

the phone number for verification that i have is not active and i wrote wrong my secondary mail.. instead gmail.com i wrote gmail.con so I cant get code by phone I and I cant get it by mail eather ?
0
votes
0answers
15 views

Issues trying to crosspost to Instagram from a Facebook page

I'm a photographer. I have a FB page and and IG page and I'd like to schedule posts to post in both places. FB now allows me to schedule posts, and hypothetically also crosspost these posts to IG. ...
0
votes
1answer
15 views

Multiple IF(AND) statements to determine Pass/Fail

I'm using Google sheets to try to generate a Pass/Fail in a cell based on two different parameters; If (R2) is less than 85% AND (I2) equals "T1","T2, or "T3" I need a fail generated. similarly, for ...
0
votes
0answers
10 views

Convert records with comma-separated values into unique records for each value [duplicate]

I've got a Google Sheets spreadsheet with records of individuals along with a column for comma-delimited phone numbers for each individual. I have been pulling my hair out trying to generate a two-...
0
votes
0answers
4 views

How to find number calls for particular day on Google Voice instead of counting them all

Is there any way instead of counting them individual in Google Voice ? I had been using hangout to make calls and call history is found in Google Voice but I need to count individually to decide ...
2
votes
1answer
24 views

How to extract multiple paths from a single string of URLs in Google Sheets?

How can I get a subrange of second to last element in a formula under Google Sheets? I'm trying to extract all occurrences of https://example.com/* in a cell which may contain multiple URLs scattered ...
0
votes
1answer
11 views

Counting with Query

I am using queries, in order to create a dashboard, =query('Usuarios icorp'!I2:M522; "count(F) when F contains '"&B3&"' ", -1) I am having issues with my query function. I want to count how ...
0
votes
1answer
18 views

In Google Sheets I need to find a string and return true/false, or even a count into a cell so I can perform an action

In my example i have a column with Names of signs we product in our sighshop and I need to be able to isolate similar named signs So say I need to return a a value if the cell is Bud Light and only ...
0
votes
0answers
14 views

Prevent Outlook from stripping line breaks from plain text emails

I'm asking webapps because meta seems to think that it was the right place. Please, see this question and post a different answer if you believe it is not the case. I like my emails to be written in ...
0
votes
0answers
10 views

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

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 ...
-1
votes
0answers
12 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
10 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
19 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
14 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
8 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
9 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 ...
2
votes
3answers
34 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
23 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
147 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
26 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 ...
-2
votes
0answers
15 views

Payroll Management System DataBase Design [on hold]

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
24 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
18 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
24 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
29 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
20 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
17 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
14 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 [on hold]

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
8 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
38 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
25 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
11 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
15 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
33 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
31 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
12 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) [migrated]

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 ...

15 30 50 per page