All Questions

Filter by
Sorted by
Tagged with
1
vote
2answers
35 views

Issues with Google Script on collecting Form responses and moving to another sheet

I have been trying to piece together some code for a task at work using Google Sheets and I am having some issues with what I can find versus my current knowledge level. I am trying to create a script ...
-1
votes
0answers
18 views

How to implement inheritance in a Google sheet

I have a sheet in Google Sheets that has several complex formulas that will be used many times over by other sheets. Additionally, improvements are regularly being made to these formulas. As of now, I ...
0
votes
0answers
15 views

Error (denied) adding supervision to Chromebook for existing account using Google Family Link

I am trying to set up parental controls for my child's chromebook (Acer R11). I was a member of a Google Family managed by my brother. So, before starting this process, I removed myself from his ...
1
vote
1answer
27 views

Google Sheets - Split row into multiple rows

Current: ------------------------------------------------------------------- | Amy | Adam | Bob| Cliff | Dave | David | Derek |...| Zachary ------------------------------------------------------------...
1
vote
1answer
24 views

Conditional row sum

I'd like to sum a column of cells if the corresponding cell on the next column contains a string of any sort. I've tried using SUMIF but I can't figure out how to combine it with ISBLANK or ISTEXT. ...
-1
votes
1answer
21 views

Google Spreadsheet Trigger which will fire when the active selection changes for a given sheet

This would be equivalent to the Excel Worksheet_SelectionChange event.
1
vote
0answers
11 views

How to search google doc filetype from google?

Is it possible to search for google docs documents/filetype from google search engine? I know it's possible to search for .doc file types like so trucks filetype:doc But is it possible to search ...
0
votes
0answers
66 views

Viewing other email accounts' sent mail via Gmail in browser

Can emails that are sent via MS Outlook (or other client) from one email address be viewable as sent mail within the Gmail account of another email address? I have added the non Gmail addresses to ...
0
votes
1answer
27 views

Help with complicated math and syntax

I am trying to create a calculator for this mobile game that I play (Lord’s Mobile) but cant seem to figure out the formula. 1) In this game, you can get your upgrade time reduced when your guild ...
1
vote
0answers
25 views

In Google sheets is it possible to have a combined chart with stacked columns?

I currently have a simple combined chart with a revenue line and columns. For what I am trying to communicate with this graph, I would really like to have stacked columns in addition to my revenue ...
1
vote
1answer
53 views

Send a Google Forms response to specific email address based on form response

I need to send Google Forms responses to specific clinicians at my practice depending on whether they have been selected on a drop-down menu in the form. At the moment, Google Forms sends an email to ...
0
votes
0answers
15 views

LastPass empty error message when autofill credentials [migrated]

So, I'm using the LastPass extension in Firefox and Chrome and it worked fine at the beginning but now every time I want to save my typed login & password, I receive this empty error message box: ...
0
votes
0answers
40 views

How can I COMPLETELY delete my Google account?

I have 17 devices listed in Google Home, and a subscription to Google Music. The devices include a Pioneer receiver with built-in Chromecast — that I learned is registered to “someone else’s home”. ...
0
votes
0answers
21 views

Facebook “URL signature expired”

I posted links to Facebook images elsewhere and now I can not see the image. Example: https://scontent.flis5-1.fna.fbcdn.net/v/t1.0-9/48374097_10156822229099932_7902434783177736192_n.jpg?_nc_cat=105&...
0
votes
1answer
47 views

Send the same email every two weekdays with Gmail

Please note I've searched for similar questions within the site, but none of them contains what I need. In a nutshell; I would like to send the same reminder email every two weekdays from Gmail (i.e: ...
1
vote
1answer
27 views

How can I select all cells that contain specific text in Google Sheets?

I have a spreadsheet that contains 20,000 cells. I want to select all cells that contain "foobar". How can I do this?
0
votes
0answers
12 views

Local page's news feed and posts got stuck

I'm managing a brand page with multiple connected location page. By posting on the brand page, all of the posts should appear on the location pages as well. Every 2 weeks I scheduling posts for the ...
1
vote
1answer
19 views

Querying for the last results with group by

I've got the following data sheet: date(A) source(B) cost(C) totals(D) val(E) 9-8-2019 Magic 0.00 0 0.00 9-8-2019 Stick 54.72 6820 ...
0
votes
1answer
254 views

Recovering deleted Gmail account

Can someone please let me know if I can reopen my old Gmail address? I deleted it about 2 years ago. I need to use this email again as I posted comments on YouTube video that I need to look at again. ...
0
votes
0answers
28 views

Does a large amount of Gmail bounces put your account at risk? [closed]

We're using a Gmail/Gsheets mail merge Add-on to send marketing emails. A proportion, perhaps 15% of these, bounce back. Does this put our Gmail account at risk of being suspended?
0
votes
0answers
9 views

Failed to load TEX extension from http source [migrated]

I'm deploying a Google web app to write commutative diagrams with LaTeX/Xy-pic. In the heading of html page I put the following configuration: <script type="text/x-mathjax-config"> MathJax.Hub....
1
vote
0answers
26 views

Conditionally format a column if it contains all the values in a set

Each of the columns in my Google Sheet represent a farm. Each farm is a list of animals. I want to highlight the entire column if the farm has a duck, a horse, and a cow. So the column may look like ...
1
vote
2answers
60 views

Is there a way to allow users to access Google Sheets with installable triggers without manually signing in?

I have set up a Google Apps Script that validates data that is entered into various Google Sheets files. I am looking for a way to allow users to access those Google Sheets files without making them ...
1
vote
1answer
17 views

How do I keep borders when dragging down to fill cells?

I have a large scheduling spreadsheet of dates and names, split up by week, with borders for clarity. I want to be able to autofill the dates by dragging down the cell. Sometimes I also want to fill ...
0
votes
1answer
27 views

Google Side bar & editing form responses

I have some code which captures the URL of the edit response, so you can click it, and amend the record if needed. It pops out and opens in a new window. I wondered if it was possible to open it ...
0
votes
0answers
4 views

App events in Facebook Business

Is it possible to add column(s) with event(s) counts from mobile app Analytics to Facebook Business (like in Google Ads)? Currently we have implemented Facebook SDK and we see how many people did some ...
1
vote
0answers
14 views

How to set the due date of Trello cards to weekends?

I'm using Trello board as project management, but when I set the card due date as a weekend, it automatically change to the nearest working day. Fore example, if I would like to set a project card due ...
1
vote
1answer
20 views

“Superset” Checkbox

I have two checkbox columns E and F. I want F to be the "superset" checkbox column, meaning that every checked cell in E means the corresponding cell in F must be checked as well. I can populate ...
0
votes
0answers
20 views

Where can I edit a Google Maps shared list created on mobile?

I created a shared list on mobile (in the Android app) for planning a trip, but for some reason, I can't find it when I use Maps from the browser among the other lists. (I'm pretty sure that this is ...
0
votes
0answers
51 views

Change Google 2FA app from Gmail to another on iOS?

When logging into a Google service on the web with 2FA enabled, Google will prompt you to go to the Gmail app on the iPhone to confirm the login. If you delete the Gmail app, it will still prompt you ...
2
votes
0answers
32 views

Opening Google Sheets to A Certain Cell or Column

I am trying to make it so when anyone who is in this weekly calendar opens the doc, it locks to the week we are currently in. Our dates are in row 4, going across the top of the doc and run from June ...
1
vote
1answer
27 views

Offset called JSON into the next column

I am trying to check for emails based on domain names stored in a column in Google Sheets. I have the API call setup and working, but the data gets pasted into the selected cell. I would like to paste ...
1
vote
0answers
15 views

How to search within an Array to a range in Google sheets and setFontColor to blue [closed]

Don't know why this is puzzling me but I want to search for all parts listed within the primeparts array shown below and find them in a table then color the text blue. So to clarify, using the partial ...
0
votes
3answers
25 views

In Google Drive, does 'remove' delete file? It says it's still accessible by collaborators

In Google Drive, does 'remove' delete a file? It says it's still accessible by collaborators, and my GB looks the same. So it looks like the file is still there somewhere, not deleted, using space, ...
0
votes
0answers
18 views

How can I use Slack's API without a token to automatically join many channels?

API tokens in Slack have been depreciated for a while now. However, you used to be able to acquire one with ease. Now when I try to do that it no longer is allowed and instead sends a message to the ...
0
votes
0answers
11 views

Outlook web: Search for unread messages containing foobar?

In Outlook Web (under https://outlook.office.com/mail/...), one can setup an Unread filter. And one can search for foobar: But is it really true I cannot search for messages that are both unread and ...
0
votes
0answers
7 views

How can I upload multiple videos to bitchute?

How can I upload multiple videos to bitchute? Rather than each one individually?
-1
votes
1answer
21 views

Find and Replace (CTRL+H) script on Google Sheets

I'm looking for a "find and replace" script for Google Sheets. I have phone numbers on column C, which are in a ###-####### format. I want to make a script that will replace the "-" to nothing. ...
-1
votes
0answers
29 views

Unable to access Gmail [duplicate]

I can't access my Gmail because I have forgotten the password and telephone number I used, the network does no longer work in South Sudan. How can I recover my account?
0
votes
1answer
12 views

Is there a way to sort my Google Script project triggers, on the console?

My console currently looks like this, and I expect the number of triggers to increase: screencap of my GSuite Developer Hub's project triggers console I name most of my projects in a standard manner,...
1
vote
0answers
10 views

Auto adding date to cells having data [closed]

All the people in my sheets are adding data to different cells in different days and I want to know when they did them because difference between the registered data by different people is very ...
1
vote
1answer
52 views

Google Sheets countif attendance sheet, quarterly report

I have a Google Sheet that I use to track attendance at an open lab that I run. Each quarter I put together a report where I count the number of people that attended that quarter. If I just use the ...
1
vote
0answers
11 views

Survey Data & Google Sheets: Excluding Missing Values?

I am using survey data in Google Sheets with rows for "before" and "after" responses, with the same survey administered to the same subjects at two different time periods. With each question, a number ...
0
votes
1answer
45 views

In Gmail, I want all labels to be visible, I don't want to have to click “More” every time. Possible?

In Gmail, I want to be able to see all labels on the left, without scrolling to the bottom of the list and clicking More. Mainly because the More label is usually covered up by a popup or a ...
1
vote
1answer
28 views

Exporting to PDF from Google Sheets removes emoji

I have designed a schedule in Google Sheets that uses emoji to indicate the character of each days activities. They display perfectly in Google Sheets. I want to physically print the sheet but when I ...
1
vote
0answers
21 views

Google Sheets Calendar Monday start of week

I don't want my weekday to start on a Sunday, who does? I want it to start on a Monday like most normal people, but impossible to find a way to do this. It's Ok on Google Calendar, you go to 'settings'...
0
votes
1answer
26 views

How do you change the starting view of a panoramic photo in Facebook?

I just uploaded a few panoramic (360) photos to Facebook. I would like to change the starting view of each one. I have done this in the past, but I am no longer able to do so. When I am viewing one ...
-1
votes
0answers
29 views

Google Sheet Link from WordPress site

So I am looking at a WordPress website and I'm trying to get the link to a Google Sheet that was embedded to make a copy of it. By going to into the page source of the WordPress site I was able to ...
0
votes
0answers
11 views

TypeError: Cannot read property “audits” from undefined [migrated]

I cannot seem to figure this out. I can run this script to pull in Pagespeed Insights some times, but lately I've been getting this error "TypeError: Cannot read property "audits" from undefined." I ...
1
vote
0answers
22 views

Facebook Business Page not showing me who has liked my posts in groups

When my business page posts in a group, I can see that a set amount of people have liked that post. However, when I click to see who has liked the post (and invite them to my business page), on mobile ...

15 30 50 per page