All Questions

Filter by
Sorted by
Tagged with
0
votes
1answer
22 views

Can I create a custom ratio based on two fields in Google Data Studio?

I'm trying to create a custom ratio in Google Data Studio that is: 'sessions with a particular event' / 'all sessions' Can anyone tell me if this is possible? I tried using a calculated field, but ...
0
votes
0answers
5 views

Facebook Events Manager / Analytics

In Events Manager I can go to 'Purchase Event' - 'view details' and underneath the graph that slides into place I can see a table with just a couple of rows of the full details of the purchase event ...
2
votes
1answer
1k views

YouTube higher quality = no buffering

While watching videos (no video in particular) if the video starts buffering at 360p, I switch to 240p and it still buffers but if I switch to 480p it doesn't. I'm connected directly to a router so ...
0
votes
1answer
83 views

Is there a way to get multiple lists of labels/categories in Trello?

I've a situation where I want to be able to filter Trello multiple ways using the UI. For example, say I want to apply a Project C label and also a In Review label and then filter for just that using ...
3
votes
1answer
715 views

Simultaneously sort multiple ranges on a single sheet in varying orders

I am trying to find a way using a script if possible (or formula) that will allow me to reduce the number of operations that I have perform to sort data in a particular google spreadsheet. Currently, ...
-1
votes
2answers
30 views

Empty cell reference when “Loading…”

I want to do a calculation with imported data from an HTML link. The data is imported every minute. There is loading time and this ensures that the cells are empty during loading. Because my formula ...
1
vote
1answer
639 views

How to calculate time worked in Google Sheets after 12am?

I usually work from 3pm to 1am. I can't seem to find out how to make google sheets find the correct duration between those times. I know the correct duration is 10 hours, but no matter what I do ...
2
votes
1answer
939 views

How can I import a vector drawing into Google Slides?

Google Slides adds an annoying amount of compression on my imported images. I want to avoid compression so I want to upload my schematics in a vector format. I can basically export myself to any ...
0
votes
0answers
9 views

Is there an Instapaper bookmarklet for moving to folder? [on hold]

I use Instapaper to share content on the web on social platforms automagically with IFTTT. It'd be great if I could use to share it to different pages/profiles using Instapaper folders. For that I'd ...
0
votes
1answer
194 views

Formula for custom number format in Google Sheets (e.g. 5M --> 5,000,000; 50k --> 50,000; etc)

I've been trying to figure this out for a bit but everything I've tried doesn't work. A quick search brought me to the conversion from full number format to condensed format (5,000,000 --> 5M; 50,000 -...
0
votes
1answer
65 views

Converting a grouped set of primitives into a primitive

I'm trying to develop a set of symbols for our developers to choose from when creating documentation. I'm confused by the terms ('shape', 'path', 'closed path', 'symbol', 'element') so for the ...
0
votes
1answer
15 views

How can I modify table row height in Google Slides?

In Google Slides, is there an option to modify the row height in a table?
0
votes
1answer
86 views

Rename Cognito Forms uploaded files

Is it possible to automatically add an event reference to file names, for files uploaded using Cognito Forms?
1
vote
1answer
27 views

Show full URL on Google Search results?

I would like to see the full URL disclosed. Is there any way to achieve this? Maybe using a custom script or browser extension?
-1
votes
0answers
10 views

How do i implement importrange the formula below?

can anybody here share with me how to actually implement importrange into this formula.. =SUMPRODUCT(SUMIF(INDIRECT("HON_"&Parameters!$B$7&"_"&YEAR(Parameters!$A$2)&"-"&MONTH(...
1
vote
1answer
21 views

(How) can I ask Google Search to crawl a specific URL on a website I don't maintain?

This question on Meta Stack Exchange asks whether crawler visits count towards the 'number of views' of a Stack Exchange question (that determines the 'people reached' statistic on your profile). ...
0
votes
1answer
44 views

When someone shares a Google doc or presentation with me, I no longer get an email notification. How can I fix this?

When a teacher or peer shares a google doc, presentation, or spreadsheet with me, it no longer appears in my Gmail. I have checked my spam, trash, and all my folders. It used to send a notification, ...
0
votes
1answer
67 views

My email box is full but I can't access my archived mail and only have less than 800 emails, what gives?

Several months ago in an effort to save space I archived about 4000 messages from over the last 5 years thinking it would help. Now with only 800 in my inbox I'm getting a message saying my inbox is ...
0
votes
1answer
73 views

Concatenating URL with a value to create link, but links only partially work

I have a column of cells in Google spreadsheet with values such as: b2397 b9504 b3333 b8655 bxxxx I would like to combine each value with a URL, for example: http://websitex.com?id= ...
0
votes
0answers
16 views

Race results as race is being run

i have a sheet for a multi lap race. At any point I want to print the current standings. Racer D is currently leading having gone the furthest, racer B in 2nd, and so on. How can I get the current ...
0
votes
1answer
21 views

Average value using different sheets on Google Sheets

I have a data set that's separated by year (so, the first year is Sheet1, the second year is Sheet2, and so on. There are 18 years in total). I want to average the data from different years. At first, ...
0
votes
0answers
35 views

Can't recover gmail account [duplicate]

I've gone through the endless loop of recovery steps as outlined by google but i keep getting the same message that they can't verify the account belongs to me and provides no other recovery options. ...
2
votes
1answer
3k views

Hidden Facebook Birthdays

I used to be able to see my friends' birthdays on one of the side panels on the Facebook homepage, but now it's gone and I can't find a setting to bring it back. Is there such a setting? And if yes, ...
0
votes
0answers
17 views

Facebook messages

Why can't I send messages to this person? Am I blocked or what? Can someone explain this to me? I'm confused since I can message that person on messenger but not see him/her.
5
votes
6answers
65k views

How to add bulleted list in Google Sheets

I am unable to add bullet in front of any sentence. See below example, I need circle bullets in front of every sentence written in one cell. First Sentence Second Sentence Third Sentence How can I ...
0
votes
1answer
125 views

Creating a Dashboard in Google Sheets which multiple people use issue with multiple users

this may be open-ended but let me put this forward. I have a very complex dashboard which works out staff hours across the country. In this dashboard our team members have a drop down to choose their ...
0
votes
1answer
174 views

Customize priority inbox in new Gmail design

For the last few years I've been using this method to customize my priority inboxes the way I like. However, with the new Gmail redesign this no longer works. Does anyone know a way to get this to ...
0
votes
1answer
15 views

google sheets query function

google sheets query function Trying to use the following query: =query(WABrdg729!A:B, "select A, B where A > date '"&text(datevalue($A$6), "yyyy-mm-dd")&"' AND A > timeofday '"&text(...
0
votes
1answer
16 views

How to RoundUp in Cognito Forms

I am creating a calculator using and my result need to be rounded-up. How do I do that? The only thing I can do is to round the result but not round-up.
0
votes
1answer
212 views

Concatenate using an array formula to result in last name.firstname

We have a form that asks for the students first name and last name. I am trying to using concatenate and an array formula to display "Lastname.Firstname". I used: =ARRAYFORMULA(CONCATENATE($B$52:$B,...
2
votes
1answer
2k views

Change Google calendar to view all 24 hours for each day in the week view mode

Is there any way to change Google calendar to view all 24 hours for each day in the week view mode, without having to scroll? (I am aware of Google Calendar view whole day at once but the OP actually ...
0
votes
0answers
7 views

Google Sheets ImportHTML formula not pulling table I need [duplicate]

I have a Google Sheet trying to pull website table using ImportHTML formula to get a table from https://mesowest.utah.edu/cgi-bin/droman/raws_ca_monitor.cgi?state=AZ&rawsflag=3 ImportHTML(https:...
1
vote
1answer
631 views

Can't set up 2 step authentication on a Google Apps for Business account

I'm having issues setting up 2 step authentication on a Google Apps user account. I've gone to the settings page and normally under the password tile there is the option to setup 2 step auth, but when ...
0
votes
1answer
10 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
0answers
12 views

Youtube video embedding by default

I have uploaded quite some videos on my channel but these are not embeddable by default. I have to click on "Info & Settings", then click on "Advanced settings" and finally tick the "Allow ...
0
votes
1answer
67 views

Split rows dynamically based on row length (COUNTA) and transpose to 2D array

I have data in this format: And I need it to be reformatted into this: Basically, each row in the initial format is composed of 4 concatenated sections of equal lengths: Part(s), Product(s), Quant(s)...
0
votes
1answer
57 views

Add row to Google Sheets and keep formulas from previous row

I want to add a row to my spreadsheet but keep the formulas – and only the formulas – of the previous row. The #1 solution provided here doesn't help me because it also copies non-formula information, ...
0
votes
1answer
348 views

Move rows on 2 sheets older than 24 hours to archive

I have been trying to figure this one out for a while now and would really appreciate some assistance. I have a Google Sheet that is being updated by a Google Form. Due to this I needed to mirror the ...
0
votes
0answers
12 views

Creating New Event In Google Calendar From A Table On Another Website

So say I have a schedule in a table(HTML table) on another website. Is there any tool that can grab content from that table(date, time, event title) and then use that information to create a new event ...
1
vote
1answer
27 views

Is it Blogger or LibreOffice who is adding so many useless SPAN tags into my text, and why?

I write in LibreOffice Writer, then I copy and paste into Blogger text editor (Compose button). Why in the world a simple and unformatted text such as Helmut Sick (Tukani: entre os animais e os ...
2
votes
2answers
6k views

How to log into Facebook using alternative accounts (Google, OpenID)

Everybody has a Google account. Yet, I see no way to use it to enter the Facebook. Others say that I must check "Linked Accounts" in https://www.facebook.com/login.php?next=https%3A%2F%2Fwww.facebook....
0
votes
2answers
30 views

Chronological ordering of checkbox in Google Forms

I have a checkbox in my Google Form, which sends the user selections in the form in an ascending order list: But I want to grab the list in the order of selection, for example if the user clicks in ...
0
votes
1answer
186 views

Are permissions granted by IMPORTRAGE bi-directional or one-way in Google Sheets?

If I want to import "Sheet A" from one workbook into "Sheet B" in another workbook by using =IMPORTRANGE() inside of Sheet B - when I grant it access to Sheet A is that permissions only 1 way? Meaning ...
2
votes
1answer
14 views

Conditional Formating for Google Sheet comparing to list of text (highlight duplicates)

I am trying to create a custom formula for conditional formatting. I want to highlight the cell if the text appears in a list of names. This list will contain 210 unique names so I can't type each one ...
0
votes
0answers
12 views

Is there a javascript bookmarklet to play all videos from a given video's channel on Youtube? [on hold]

Quite often I fall on a youtube video I like, and am interested in seeing other videos from the same channel. I wanted a bookmarklet to reopen the video page with other videos from the same channel ...
8
votes
1answer
6k views

How do I auto-reply to text messages received through Google Voice?

I recently got a new phone number, and I want people who contact me at my old number to be automatically informed of my new number. I've ported my old phone number to Google Voice and set up a ...
0
votes
1answer
109 views

Facebook shortcut Alt + Del for archiving messages has stopped working

Some months ago, the shortcut Alt+Del for archiving messages on Facebook stopped working. From what I can see in this help file (the Norwegian version), the shortcut is currently supposed to be Ctrl+...
0
votes
0answers
12 views

How can I forward Craigslist Auto-Alerts to a Google Groups email?

I am searching for a housing with five+ friends. I'd like my automatic craigslist housing alert emails to be forwarded to a group email so everyone can see the same listing at the same time and ...
1
vote
1answer
9 views

How do I add a folder shared with everyone in Onedrive to my account?

I use OneDrive for Business (through my university). My adviser shared a folder with me. I subsequently received an e-mail which said in the subject line "[my advisor's name] shared the folder "[...
1
vote
1answer
16 views

How to countif with dates before today's date that auto updates

I am trying to use countif to count a certain number prior to today's date. So if today's date is 8/15/2019 the formula would count the number that is the B column that had a corresponding date prior ...

15 30 50 per page