All Questions

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

How to get correct TimeZone in googlesheet using script?

I have wrote following script in my google sheet hoping to convert a timestamp in GMT to a customized timezone. function myFunctions(datetimeString,timeZone,format) { var moment = new Date(...
0
votes
0answers
23 views

Slack not showing unread channels + wrong “No unread” indication

Update July 3nd: Resolved Update July 2nd: Signing out and in shows the unread channels. Also, it seems the behavior changed. Now, if I choose a starred channel and then refresh, I can see unread ...
0
votes
0answers
2 views

How do I change my gmail app language to English without changing my iOS language setting? [migrated]

I want to set my gmail iOS app to English without changing my iOS system-level language. Is it even possible? Thanks,
0
votes
0answers
21 views

Email sheets by cell value

I have 4 sheets that feed off the responses, they are time sheets. When the 1st 16 rows of job descriptions are filled in sheet 2 takes over etc. Is there a script that lets me email only the sheets ...
0
votes
2answers
21 views

Auto Create New Google Sheet With Column Headers Based on List of Names

I'm trying to create a VERY basic CRM tool. I want to create a running list of customer names. Once I enter a name in Column A I'd like a new Sheet automatically created with pre-set columns I can ...
0
votes
0answers
8 views

Content not fluid in Nordic theme on blogspot

I'm using the Nordic theme on blogspot, and while in their demo, the content is fluid for any screen size, it is not the case in my blog. I tried this solution and it didn't work as I can't find ...
0
votes
1answer
12 views

How to combine between compose and HTML modes easily in blogger?

I need to edit a blogger post to add some HTML snippets, when I switch to the HTML mode it becomes very harsh to find the place I want to add the HTML snippet in, in contrast to the Compose mode, that ...
0
votes
1answer
37 views

Gmail inbox shows 1 unread message, but if I click inbox it won't show

If I search for in:inbox, it also won't show. If I search for both in:inbox is:unread then it does show. If I search for in:spam is:unread it no longer shows, or in: [anythingelsehere] basically. ...
0
votes
1answer
14 views

How to block all followers except followed

I have a lot of followers due to spam. I want to block and unblock them all to make them unfollow me except ones I followed. how to do that? is there any script to do that?
0
votes
2answers
31 views

How to open a single tweet in a separate tab with a single click?

Currently if I want to open a tweet in a separate tab (usually so I can read the replies later), I have to: Click the tweet Go to the URL bar in my browser Copy the URL Open a new tab Paste URL and ...
0
votes
1answer
27 views

App Script to move a row of data from one Google sheet to a different one (different sheet id's) based on a cell entry

I'm currently trying to adjust a script I found that copies the contents of a row from one tab of a google sheet, pastes it into the next descending empty row in a different tab and then deletes the ...
1
vote
0answers
11 views

Read email returns to being unread after receiving another email from the same sender

Having read an email and it being marked as read it returns to unread next time we get an email from the same person, along with all previous emails from that person. It only happens with certain ...
0
votes
0answers
56 views

In a Facebook group, how to show all “Announcements” by default without clickng “see all”?

I am the admin of a Facebook group. There are two polls that were pinned to the top of the page. By default, one of them shows but the other you need to click "see all" to view. The one that is shown ...
1
vote
1answer
28 views

How to programmatically drag new rows - running total?

I have the first few rows of my mortgage payments set up, and I want to know how to programmatically print the rest of the rows, as opposed to dragging the little corner box to output the rows. This ...
0
votes
1answer
8 views

How to combine these funcions (FILTER + IMPORTRANGE) in one?

I have all data in one sheet and I need to filter the imported data to another sheet. How can I do that in one function? Function to filter data which I use: =FILTER(A7:C,RIGHT(A7:A,7)="?id=999") ...
1
vote
1answer
33 views

How do I get Google forms edit url to work

I want to generate an edit url link in the google sheet for a google form which is linked to it. There are already instructions on how to do it. However they do not work for me. I have followed the ...
1
vote
1answer
26 views

Array Formula with IF function and SUMIFS function

I am trying to convert the below formula into an array formula. I can make it work in an array, but it displays the wrong values, compared to the normal formula which I have to drag down. Normal ...
0
votes
1answer
27 views

Dynamic Data Validation in Google Sheets

I want to restrict a value in a cell based on another cell in the same row. The value in A must not exceed what is in B. If the value in B is zero, any figure is allowed in A A | B --- 4 | 9 – ...
0
votes
1answer
9 views

Tap to overwrite cell Google Sheets on Android?

I have a Google Sheets golf scorecard which I use on my Android 7 phone. I use it to capture my scores at the end of the round, to calculate stableford points and adjust my handicap. Each time I want ...
0
votes
1answer
20 views

Is it possible to set different languages for different Google apps?

If I change my Google account's default language, it sets it for Search and Google Maps, and Gmail and so on... Now I want my Search to default to one language and my Google Maps default language to ...
2
votes
1answer
5 views

How to create draggable sheet reference with the same cell?

I'm not very familiar with Google Sheets and have a question that may be very simple but I can't seem to find an answer. I am trying to pull information from one same cell example, H47 from multiple ...
0
votes
0answers
4 views

Complex Google Sheet protection making it difficult to give user correct access

I am needing to give an executive access to a Google Sheet that was setup with a bunch of overlapping permissions, and I can't figure out why the user still doesn't have access to the column they need ...
0
votes
1answer
12 views

Filter spreadsheet by user-entered value in first row

In Google Sheets, I want to set up a filtered view like this. Row 1 = column headings Row 2 = filter criteria Rows 3... = data I want the user to type a value into any column of row 2, and ...
1
vote
3answers
42 views

Using a script to only take only take cells with values in google sheets

tl;dr how can I make the script take an entire column (eg A:A) and then ignore the first (header) row, and any blank rows? Background I have an array in Google Sheets with date-ordered data (note ...
1
vote
1answer
17 views

Assert cell style onto text pasted into that cell

I'm not quite sure how to word this so I couldn't find any answers to my question after some searching. I am trying to copy and paste values into my Google sheet. These values are copied from another ...
0
votes
1answer
33 views

Google deleted (from 3 accounts) a threatening email that I need as evidence of a crime-how to retrieve?

I received a personalized threatening email that went into my spam folder ("someone" used the message board from rentboy.com to mask their identity). I sent a copy of the email to my sister (also ...
-1
votes
0answers
7 views

3rd Party Twitter Premium API Re-Sellers

A client of mine has the need for data in quantities and level of detail which takes too much time because of the strict rate limiting of Twitter's free API. It would have made sense to opt for ...
1
vote
1answer
13 views

Count unique values in second column corresponding to unique value in first column

I have a Google sheet with cities corresponding to countries like this. Notice that neither countries nor cities are unique and there can be duplicates. | A | B | ----------------------...
-3
votes
0answers
5 views

Find out google drive user name belongs to [duplicate]

Someone hacked my drive. I have it fixed and I recovered everything, But how do I find out who is behind the user name LALA LALA.
-1
votes
0answers
44 views

Facebook Page is unable to join FB groups

I am admin of a page. The page is been created by someone else and that person made the admin of the page. I have been trying to join groups as my page. When I go to a group and click "Join Group". I ...
0
votes
0answers
20 views

Show to, from field in results in Gmail (using 3rd party Software is allowed)

I am trying to get rid of duplicate accounts on some sites. Problem is I don't remember the E-Mail Id I use to register since I use catch-all with GSuite. I want to see all the E-Mail I have ...
0
votes
2answers
16 views

Make a filter but exclude one column

I would like to make a filter on Google Sheet but exclude one column For example: In this case I would like to have the filter on Column A and B but the data on Column B should stay as they are, so ...
-2
votes
0answers
15 views

How to convert VBA to Google Sheet script

Private Sub Worksheet_SelectionChange(ByVal Target As Range) Range("A1").Value = ActiveCell.Address End Sub Please just want to write the same Google sheet script to work just like in Excel. ...
2
votes
1answer
19 views

IF AND not working in Google Sheets for Conditional Formatting

I am trying to use the three following functions... =IF(AND(M3="Funding on Hold",R3>=3,R3<=6),TRUE,FALSE) =IF(AND(M3="Funding on Hold",R3<=9,R3>=7),TRUE,FALSE) =IF(AND(M3="Funding on Hold"...
1
vote
0answers
8 views

Reporting a group chat [duplicate]

For the past 3 days, I have been getting group chats from some non-English speaking people and I keep blocking them! Now I am irritated and want to report them. I've blocked and deleted them but they ...
1
vote
1answer
10 views

Create list by cell color

I have a master list of trading cards. I'd love to be able to use a color coding system. For example, if Green is cards I've already collected, when I highlight the background of the cell green, I ...
1
vote
1answer
36 views

Gmail alias - Automatically “send mail as” alias when alias is recipient [duplicate]

It's all in the title, but I'll spell it out: Let's say my primary Gmail address is bob@gmail.com, and my alias is bob@bobscrabshack.com. I have my personal mail server forwarding mail addressed to ...
0
votes
0answers
9 views

Dynamic dropdown option load dissapears html modal dialog [migrated]

My Html form has dropdown which load dynamic options using api request. I'm using google HTML Service to link google app script with html file. My problem is my modal dialog getting disappear as soon ...
1
vote
1answer
15 views

How can I add details to goals in Google Calendar?

I have been using goals in Google Calendar for quite sometime now. They are very handy and easy to use. Just create a goal you want to accomplish, set preferred time and frequency and you are all set. ...
0
votes
0answers
23 views

How to copy cell to clipboard

I have a hyperlink on every row (in multiple worksheets) that I would like to, when clicked, copy the info from column 9 of the same row to the clipboard before opening the link so that it can then be ...
1
vote
0answers
87 views

Can't get search results on Google anymore

Since this morning, it appears that I can't get any search results anymore when I am logged in my account. If search anything, all I will get is "did not match any results". The only thing I ...
0
votes
0answers
7 views

MinervaNeue style in Wikipedia stopped showing image overlay

tl;dr: Recently MinervaNeue style in Wikipedia stopped showing an overlay with Media Viewer. In addition, my setting to not use Media Viewer at all is ignored. I'd like to know, if this is only me (...
-1
votes
0answers
31 views

Merging profile and fan page pages on Facebook

I am wondering to know what is the best way to merge my personal profile (~2k friends) with my fan page (~1k likes). Is it possible to merge them? Should I delete the fan page and convert my personal ...
0
votes
1answer
18 views

How to hide the display of formula in Google Sheets?

How to hide the display of formula in a protected range of Google sheet? In Excel, I can do that, but in Google sheet not finding any function. Please help.
0
votes
0answers
8 views

Can I transfer linked number to google voice

I have GV and linked to it number. But I want to transfer this number to GV too. Is it possible? I don't have other american number.
-2
votes
1answer
23 views

Google drive hacked [closed]

Someone hacked my google drive and restricted me from viewing my own files. I have their user name, LaLa LaLa. How do I find out who that person is? No Email address beside it like usual.
0
votes
1answer
25 views

Put Date in Specific Column

I found the following code in another post here to add a date after an edit but it places it in an offset column, I would like the date in Column 8 if column 3 or 4 has been edited. What do I change? ...
0
votes
0answers
12 views

Display another YouTube playlist as default playlist, instead of Uploads

Is it possible to display another playlist instead of Uploads on my YouTube channel? I want to keep the current videos public, but move them in another playlist and feature other new videos and do ...
1
vote
1answer
25 views

How to (easily) clear a Google Doc's edit history?

How do I clear (or hide) a shared Google Document's edit history? I want to share a document with others but don't want the edit history visible to others. The only way I've found is to make a copy ...
0
votes
1answer
25 views

How to timestamp on new added cells in LIVE google spreadsheet?

The code below insert timestamp in google sheet by editing another column. However, there an issue which I have no idea how to solve. When I add new row manually, it successfully adds timestamp, BUT ...

15 30 50 per page