All Questions

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

Split multiple line cells from various column and duplicate the surrounding rows

may I know if there is a way that I could split multiline cells from various columns in google sheet then duplicate the surrounding rows. I am new in this kind of environment so I am really confused. ...
0
votes
0answers
3 views

please solution

sold my old Android phone, factory resetting it first, without thinking of logging out, so now the new owner who lives 500 km away can't login without getting my account and password. I don't want to ...
0
votes
0answers
5 views

Mandrill not using updated Mailchimp template?

I'm a Python/Vue.js dev who has been asked to step in on an existing website and make some changes. One of the changes I've been asked to make is to update the address that appears at the bottom of ...
0
votes
0answers
8 views

How to exclude IP address from “App + web” property

When I go to "All Filters" under my Google Analytics account, there is no option to add a new filter to exclude my IP address. This is because the only property on the account is an "App + Web" ...
1
vote
1answer
20 views

How to use IF THAN statements on date but converting it to time

On B2, I'm trying to put in an IF timevalue statement on a datetimevalue statement with this formula =IF (A2 < TIME (7,30,0), "PREM", IF (A2 >= TIME (7,30,0), "INTRA", "0")) However it doesn'...
0
votes
0answers
5 views

Pinterest - Download all pinned images

Ive got a private instagram board with c. 2000 image pins on which i wish to download as JPEG / PNG etc. If i click into each pin there is an option to download the image, but is there a way i can ...
0
votes
1answer
27 views

Help with Google Script Editor and checking the value of all cells in a certain range

I am using google sheets to record our printer cartridge inventory, and using script editor to check the cells C2:C50, and send out an alert email if one cell falls below 1 after editing. I finally ...
1
vote
2answers
23 views

Conditionally format if date is same/greater or smaller than current date

I'm trying to get my Google sheet to automatically colour a cell red if the current date is the same or greater than the date in the cell. Example: today is 21/02/2020. The date in the cell is 25/...
0
votes
1answer
18 views

How to sign up for a Weixin account?

I need to ask questions to developpers of Chineese software (200000 different users but not well known outside borders). And of course, the rule is no email, no GitHub, no Stack Exchange, but Weixin ...
0
votes
0answers
10 views

How do I make a bar chart that parses comma separated arrays in Google sheets?

I have a Google form with a multiple choice question. In the Google sheet, it places all of the checked responses in one cell separated by commas. I'd like to generate a chart that counts the ...
-1
votes
0answers
9 views

Cognito drop down menu calculation

In Cognito forms I have a table where users can select a product from a drop down menu. On the following Performance drop menu, if a user selects and adds more than 1 item can it calculate the total ...
0
votes
0answers
20 views

Gmail importing filter XML “Failed or Skipped” when selecting “Apply new filters to existing email”

I created an XML by exporting my filters. Then modified it and imported it again. All runs fine. However, when importing and ticking Apply new filters to existing email, the status of all imported ...
0
votes
1answer
22 views

How to extract time out of text in Google Sheets

I have the following issue and I would appreciate your help. I need to get the time values out of this string: SomeText 02/02/2020 9:00 AM-02/02/2020 9:15 AM;"Text" 02/02/2020 10:45 AM-02/02/2020 11:...
0
votes
0answers
4 views

Can I upload Medium post from a file?

I found that I can upload a post to Medium from a link (import a post). But can I upload a post from a file? I want to write a post in some markup editor, save a file and upload it to Medium. Is it ...
0
votes
0answers
7 views

Google Docs self-user cursor

Apologies for the confusing title, I'm not entirely sure how to describe the thing I'm having a problem with. I was signed into Google Docs yesterday to work on a paper. I've just signed in again ...
-1
votes
0answers
31 views

Snapshot G Suite?

Is there a way to snapshot all data in G Suite for a whole organization? The two methods I know about are "Data Export" (for an admin) and "Takeout" (for each individual user). The problem is that ...
0
votes
0answers
4 views

Atlassian Confluence: Changing page icons depending on their template

I would like to visually differentiate different page types in Confluence search results, ideally through the use of different icons. When creating content through the "Create..." button, pages, ...
0
votes
0answers
6 views

Can I edit trivial details of an event without causing the invitation to be sent again?

I have a large meeting in my calendar that a bunch of people have already accepted. I made a trivial change to the meeting notes tab that seemed to cause the invite to be sent a second time to all ...
0
votes
0answers
8 views

Can I upload a GIF larger than 480px in a Facebook post?

I am trying to upload a GIF in a Facebook post. The original GIF is 414x614 pixels. After I upload it I understand that it is automatically converted and the resulting size is so small that the text ...
0
votes
0answers
24 views

Recovering an ancient YouTube account

I have a YouTube account that dates from at least 2011, before the Google Accounts were fully integrated. I know the username and the email address, but not the password. Here's where it gets tricky....
0
votes
0answers
4 views

Different google profile pictures on different google sites

Ok so recently I was exploring my about me page, and changing up some stuff, but I noticed that on some google pages (about me page, most google apps bars) i had some profile photos, and in others (...
0
votes
0answers
8 views

Youtube supports a feature, when I click any item in transcript, player would jump to the corresponding time point, what the name of this feature?

Youtube supports a feature, when I click any item in transcript, player would jump to the corresponding time point, what the name of this feature? click here to have a try.
2
votes
1answer
16 views

How to calculate a sum based on a date range

I am trying to find dates within 30 days in Column B. If the date matches the range it should sum all those that match in column I. I have tried this formula: =SUMIF(B:B,">="&TODAY()-30,I:I)...
0
votes
0answers
4 views

Facebook video player in mute by default when uploading a video to own page

Everytime I upload a video to a Facebook page of mine, for me the video appears in the timeline in mute by default. I'm not sure this happens only with videos uploaded to my Facebook pages though. Is ...
0
votes
1answer
8 views

How to bulk delete YouTube comments without deleting or deactivating the channel

This question was posted a while ago, but the answer does not work anymore as YouTube settings have changed. Plus, the answer will have your YouTube account disabled for a while before you're able to ...
1
vote
1answer
12 views

How do I run multiple onEdit functions in the same spreadsheet in Google Sheets?

all! I hope I can count on your expertise to help me with a project I'm working on. I want to call different functions based on which spreadsheet the event happened. Ex. Typing 1 in B6 on "Room ...
0
votes
1answer
7 views

Move/copy one of the repeating events between calendars

I have a series of repeating events in a calendar "Schedule". I want to move a single one to my other calendar "ActuallyGoingTo". As far as I can tell Google only allows moving/copying the whole ...
0
votes
0answers
7 views

Create an automated post in a channel

I'd like to create an automated post in a slack channel, from Monday to Friday every day at around the same time. I would prefer not to have the admin add any apps to slack, and to do it natively. ...
1
vote
1answer
13 views

How do I display the first 40 rows from one sheet into another sheet?

Simple Question How do I display the content of the first 40 rows from one sheet into another sheet?
1
vote
1answer
19 views

How to get LOOKUP to do an exact match only?

I have a column of form response numbers, and on a separate sheet a column of a random (but sorted) subset of those response numbers with another column next to it that has some scores. I need to ...
0
votes
1answer
14 views

Google maps: why does text for Macau look smaller than Hong Kong?

I thought Macau and Hong Kong only differ by size but are both SARs of China. Why does Google Maps make the text "Hong Kong" bigger?
1
vote
0answers
26 views

Is there a way to add a specific Google Calendar as a forwarding address in Gmail?

I wanted to create a filter in my Gmail account to forward specific calendar invites I receive to one of my other Google calendars (using its @group.calendar.google.com id). Unfortunately, I can't ...
-2
votes
0answers
10 views

Message enter valid email addrezs [closed]

How come when try to sign up for things and enter my email there's a message saying please enter a,valid email address
-1
votes
0answers
15 views

How to protect different row sizes following sort in google sheets?

My rows differ in size depending on the differing aspect ratios of images I have inserted into an "image" column. Following sort, many of the row sizes no longer match the pre-sorted sheet. Do I ...
0
votes
0answers
7 views

Why does a shared Google sheet arbitrarily revert to a previous version of the sheet?

I've been working on various shared Google sheets with teams of 1/2 dozen to 20+ over 2 years now. Every so often a shared sheet will arbitrarily revert to a previous version and override all the work ...
0
votes
0answers
28 views

Did Gmail's Google Voice Integration Recently Cause a Regression in Firefox?

Up until this week, I was able to share my microphone in Firefox to facilitate Google Voice calls via Gmail. I run Kubuntu 19.10 and Firefox 73. My question at AskUbuntu (addressing the client-side ...
0
votes
0answers
8 views

Download PDF fro Google spreadsheet gets weird

I'm downloading PDF from my spreadsheet, and it's working grate with the formatting. But now suddenly it stopped working. The formatting is totally off. I have tried to change the formatting, the ...
0
votes
1answer
24 views

How do I search the Chrome Web Store for apps?

Ok, Chrome apps still exist, u just cant search for them because you will get extensions results… BUT, here is an example of one App Cookies if u search “cookies” this app wont show up… very simple ...
0
votes
0answers
16 views

Unable to Sign-Up and Create a Free IBM Cloud Account

I am here because IBM Cloud support is useless and hope somebody here may have better suggestions. As stated in the title, I want to sign-up with IBM Cloud to try out Watson. I have already created ...
0
votes
0answers
6 views

Analytics - active page/users - change url for group up

I have a custom dashboard where I have an real-time table. This table shows what pages are seen by users which are now on website. There are pages like /checkout/xxxxx. If there are 2 users on /...
0
votes
0answers
9 views

Creating a Table in Google Sheets from XML Output with Multiple Children Levels

How to create a table in Google Sheets from an XML output with multiple children levels? I'm trying to create a table in Google Sheets with data sourced from an XML output. The XML source is here. ...
0
votes
2answers
31 views

How do you create a filter to MOVE emails in Gmail

I get a lot of email alerts that I need but don't want cluttering up my inbox. If I right click on them, there is an option to move them to a folder. I want to set up a filter to do that ...
0
votes
0answers
8 views

My filter for issues I worked on no longer shows resolved issues

I have a filter that should, and until recently did, show issues that: I worked on AND are either NOT resolved, or were resolved less than month ago The filter looks like this: project = PROJECT_ID ...
0
votes
1answer
19 views

When code is inserted to Medium, all the spaces or indentation is lost

I wonder why when I typed 3 back ticks (`) and then use CMD v (on the Mac) to paste some code into Medium, all the indentation / spaces are lost. I have to manually add the spaces back and indent ...
0
votes
0answers
18 views

How to sort by drop down option and secondary date range

I have a data validation range (drop down) list. I'm using a query to bring back info from the choice of that drop down. I would like to then filter the information further with a date range that will ...
0
votes
1answer
25 views

What works with the new Apps Script runtime powered by Chrome V8 for this project?

Post edited to clarify: I found the following code that allows me to query my 3dCart store database and dump the information into a sheet. I tried upgrading to the new Apps Script runtime powered by ...
-1
votes
0answers
19 views

moving script between google sheets files

I have a script I have written for a file. I would like to move it to different files so I can use it in them. I do not mind re-authorization. Is there a simple way to do this? Like having an addon ...
1
vote
1answer
29 views

How to select everything from two columns that have matching rows on google sheets

My mobile teams rely on a spreadsheet for localization. With time I realized that each team are using their own keys rather than using the same one. I need to start from scratch and have both teams ...
0
votes
2answers
25 views

How can I calculate a future date in google sheets when I know the number of months?

I have a date (TODAY()), and I have a number of months in a google sheet. How can I get a future date from this? I tried =DATE(TODAY()+MONTH(B63)). But the problem is that the months in B63 are not in ...
-1
votes
0answers
7 views

What is the primary metric to be used to evaluate a classification model for training dataset which is highly unbalanced?

The model is planned to be created in Azure ML by using automated machine learning

15 30 50 per page
1 2 3 4 5 589