All Questions

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

Extract the first three unique characters of a name to create a code

I have a column D where I store the VENDOR COMPANY NAME. I have a column B where I want to calculate a SHORTCODE unique for each vendor. This code will be the first 3 letters of the VENDOR COMPANY ...
0
votes
1answer
6 views

How can I schedule a Google Calendar event for recurring twice-monthly payday?

How can I schedule a Google Calendar event for recurring twice-monthly payday, which recurs monthly on day 15 or the last day of the month OR if either is on a weekend then the prior weekday? I assume ...
0
votes
0answers
2 views

Is there a script or any 3rd party software that will expand all comments on a Facebook post with thousands of comments?

One of my Facebook posts went viral a few years back. Over the years it has garnered over 57,000 comments and I would love to go back and read my actual friends’ comments prior to it going viral, but ...
0
votes
0answers
4 views

How do I get enough reputation to reply to answers in Web Applications Stack Exchange? [migrated]

See Title. I throw myself at the mercy of the internet. Are humans generally good?
0
votes
0answers
14 views

How can I mitigate needing to change hundreds of Google passwords? [closed]

Google Chrome has been telling me about a security breach where passwords have been stolen from many websites and it's telling me which of my saved passwords are at risk and that I should change them. ...
0
votes
0answers
4 views

gsuite user unable to access google groups

I'm an Owner of Google Groups instance with two different email accounts - my personal one (gmail.com) and my work one (mycompany.com). I can verify that my mycompany.com email is an Owner on this ...
0
votes
0answers
10 views

Google sheets: Regexextract next or previous whole word or number from cell in sheets

How do I extract the next word or number (including comma and delimiter) to a search string from a cell in sheets? And how the previous? ={$AV$14; ArrayFormula(IF(ISBLANK($AT$2:$AT),, iferror( value(...
0
votes
0answers
16 views

How do I update a single Google Sheet tab with information from two tabs on the same sheet when a form is submitted?

I have two forms that contain similar information. One asks for more in-depth information that is needed sometimes from external customers while the internal one doesn't need as much information. I ...
0
votes
1answer
6 views

How to make Google Docs automatically correct misspellings

I would like Google Docs to automatically correct misspellings, not underline them for me to manually correct. Is this possible? "Automatically correct spelling" is already selected.
0
votes
1answer
9 views

where is the option in twitter to view my tweets?

where is the option in twitter to view my tweets? I'm interested in viewing my tweets, the option used to be there but now the GUI seems to have changed and I can't find the option.
0
votes
0answers
5 views

How to get the data associated to a post I started on a private Facebook group?

Let's say I have done a post on a Facebook private group, and that many people have answered/commented on it. How to retrieve this data, i.e. the whole conversation/comments for a post? Example of ...
0
votes
0answers
4 views

Storing song lyrics [closed]

I'm a guitar player and I built a web app that stores my song lyrics so I can view them on my Ipad when I play cover songs at pubs, etc. Until now, I've been the only user but I'd like to allow others ...
2
votes
0answers
14 views

Content control or invisible placeholders

Related to this question dated 5 years ago and where it is stated that "Google Docs doesn't have invisible placeholders at this time, but it has bookmarks." MS Word has 'content controls' ...
0
votes
0answers
12 views

Chrome extension doesn't show number of users

I have built and published my chrome extension. I am not sure why it doesn't show the number of users who installed it (currently 4). Is there a certain limit that the number of users should reach for ...
-1
votes
0answers
5 views

Specific youtube video not playing [closed]

I am having a big problem, whenever I search for this video, it says Sorry, the Wayback Machine does not have this video (xxxxxxxxxx) archived (or not indexed yet). can you please fix this specific ...
0
votes
0answers
6 views

What is the best Javascript python interpreter for what I am working on? [closed]

I am making a website to help teach users Python. What service can I use to run custom Python functions (no other libraries)? For example, the user inputs down(2) on my website, this service takes ...
0
votes
0answers
5 views

Google Voice Text Messaging: Selecting recipient failure

Failure confirmed on Firefox, Chromium and Safari browsers. When sending text messaging a dropdown menu of recipients is provided, however, clicking on the recipient no longer selects the recipient. ...
2
votes
1answer
24 views

google Script insert as HTML

If I have the string: var text = "Altman, R. (1992). Sound space. In R. Altman (Ed.), <em>Sound Theory Sound Practice</em> (pp. 46–64). New York: Routledge."; How can I insert ...
0
votes
1answer
27 views

is there a formula that will allow me to pull data from one google sheet tab to another based on a if contains conditional

I have a list of start dates in one tab in Google sheets. I want to pull only the start dates that reflect 2021 into a new tab, as well as pull the corresponding info for that entry from the other ...
1
vote
1answer
20 views

Is there a way to detect with Google-Apps-Script whether Google Sheets is opened from Android app or from desktop browser?

I have a small script that I have further reduced for the sake of this question. Basically it implements the onEdit function in which it may show an alert (using SpreadsheetApp.getUi().alert()) and ...
0
votes
1answer
9 views

Google sheet sum minus sum gives small number when should be 0

I'm doing accounting in google sheet so my column C and D are all numbers with 2 decimal points. But somehow when I subtract sum of debit and sum of credit, the result is a small number when it should ...
0
votes
0answers
3 views

How do I BATCH download ALL Facebook videos that are under the GUIDES section?

How do I BATCH download ALL Facebook videos that are under the GUIDES section (previously known as UNITS) of a private group which I'm a member(not admin)? I'm already logged in to FB via JDownloader ...
0
votes
1answer
10 views

How to convert a rational number like 1.6 to the higher integer number?

How can i convert the number 1.6 to 2, 3.8 to 4 and 1.2 to 2. Any number that has0.0 to be converted to the next number . Round will round the number to the nearest integer but I want to the higher ...
0
votes
0answers
2 views

Reddit filterline custom filters [closed]

How can I access the filterline of reddit in order to use custom filters on the posts? Can you help me?
1
vote
1answer
16 views

How to solve the issue of sorting numbers in 00-00 format?

https://docs.google.com/spreadsheets/d/1VsEvt2KnYGnlN_qHjkjPohVHF5MUqfyHD7tSk0VpkqA/edit#gid=1418057437 I have this sheet that I enter all data of patients in (Data_Entry) tab and I want these data to ...
0
votes
0answers
13 views

Jump to a cell, address of which is located in another cell

A1 has a formula that shows the address of the last row with data (A958, A959). I need to make a link in A2 to the cell address of A1. (eg. If A1 has Value C456, I need to jump to Cell C456 by ...
1
vote
0answers
16 views

How do I create a list of ranked numbers in Sheets––one that will adjust if I change a number?

I have a column of numbers 1-50 in a Google Sheet, which are a ranking list for a different column of fifty items (items are ranked relative to one another, so 1 is the best in the list and 50 is the ...
1
vote
0answers
9 views

How do I specify a consistent interval for a date-range axis in a Google Sheet Chart

I have a Google Sheet with a set of deposits and withdrawls and the running balance. I have added a chart to the sheet, so I can visualize what the balance has been over time and when deposits or ...
2
votes
1answer
9 views

Does the Internet Wayback Machine API support adding a link to scrape?

I can go to the Internet Wayback machine website and add a link to the site for the Wayback spider to scrape; is it possible to do this using their API as well? From what I've read you can only pull ...
-2
votes
0answers
4 views

unable to Attach documents in Google forms [closed]

i have created a Google form and have mandated attachment of a document but it is not being allowed
1
vote
2answers
15 views

How to test apps script addon

I have created an addon using this guide. code.gs function onOpen() { SpreadsheetApp.getUi().createAddonMenu() .addItem('Start', 'showSidebar'); } function showSidebar() { const ui = ...
1
vote
0answers
8 views

Is there a good open-source blogging system out there written in NodeJS that comes with GUI? [closed]

I've been working with this company for a few years. When we first started, I wrote their website using PHP and their mobile app using Cordova. They needed a blogging system and so since we were using ...
2
votes
2answers
48 views

How to sum a range columns from another google sheet

I get this daily data consumption spreadsheet report from a vendor that looks like this userid feb1 feb2 feb3 . feb29 u1 100 34 23 . 4 u2 0 24 ...
-2
votes
0answers
9 views

I got error in Json-server please help me? [closed]

internal/modules/cjs/loader.js:883 throw err; ^ Error: Cannot find module 'C:\Users\Akshay\AppData\Roaming\npm\node_modules\json-server\lib\cli\bin.js' at Function.Module._resolveFilename (internal/...
1
vote
0answers
12 views

Why can't I access someone's Instagram account if they have not blocked me?

Instagram now deletes all comments and likes from a user that is blocked. So I can't find or access the Instagram account today that I gave some beneficial comments to just a few days ago. From ...
-2
votes
0answers
19 views

So I have this question in one of my interview practice problem and I'm not that familiar with Java [closed]

A Java program to that performs the following tasks: Accepts integer input (one integer at a time) from the user. Inserts the given integer into an integer array of size 10 in ascending order. If the ...
0
votes
0answers
11 views

I am looking for how many times a number has been used [closed]

The formula I use is =COUNTIF($AT$5:$AT$500,AT307) I don't want the formula to run if there is no value in the cell, otherwise it counts the blank cells. The formula sits in column AU and looking for ...
0
votes
1answer
8 views

How to match formatting of one cell in Google sheet with another?

I typed "2:30pm" into a cell in a Google sheet, and it formatted it as "2:30 PM". I typed "2:30pm" into a different cell, and it formatted it as "14:30". What I ...
0
votes
0answers
15 views

Remove duplicates but keep data based on several criterias

I have a database with thousands of rows and want to remove duplicates but also keep records from earlier in certain conditions. Here is my problem: Column A will have unique numbers for referals in ...
0
votes
1answer
18 views

How to apply a conditional formatting rule on the last row of similar cell value across one column?

I am trying to conditionally format the last row that has similar values of sorted data based on country column. In this example of my test sheet, I'm sorting the data from A3:C18 by placing the ...
2
votes
1answer
39 views

Adding together multiple Sum Filter or Sumifs with multiple conditions across multiple sheets?

So I have a budgeting spread sheet. I have an overview page that I need to link to a "Checkings" sheet and a "CC-Chase" sheet. To calculate the amount spent on a specific category ...
0
votes
0answers
15 views

Auto-generate unique sheets when you add a new row in Google Sheets?

I'm a fairly new user to Google Sheets, I'm trying to set up a sheet whereby when you add a new line in one sheet, it creates a separate check-list sheet. So when a new user is added to the master ...
3
votes
1answer
67 views

Calculate time difference within one cell

I'm trying to calculate the time difference and get the result 04:00. This obviously doesn't work because MINUS expects 2 arguments and instead gets a range. Generally, is there a way to output a ...
1
vote
0answers
15 views

Facebook: How to successfully paste formatted text into a group post?

On Facebook, when creating a new post to be posted into a Group (as opposed to onto a standard personal or company page), Facebook allows you to add some simple formatting to the post. If you ...
1
vote
1answer
26 views

Combine multiple IF statement/condition into one Google Sheet column

How can I achieve in Google Sheet so that the column will auto populate the correct "vendor" based on the selection on "model" and "size". Refer below: There will be 2 ...
0
votes
0answers
3 views

Where can I see my early review credit total?

As an Amazon customer I understand there is a $1-$3 credit given under some circumstances when reviewing recent purchases. Where can I go to see my credit total that will apply to my next purchase?
1
vote
0answers
9 views

Facebook videos have no sound until I click to unmute

When I play a video in Facebook desktop web, it starts muted and I have to click to enable audio: This doesn't seem to be related to any of the Video settings I can find - I've tried all combinations ...
0
votes
0answers
10 views

How do I stop the pictures in YouTube search results from displaying frames from the video in rapid succession, when using Chromium browser?

I'm a Linux user, and am having a problem with youtube.com when accessing it with the Chromium web browser (version 53.0). When YouTube lists search results, each result shows a picture. The problem ...
0
votes
0answers
6 views

Shopify API show third-party store products [closed]

Is there a way through out the official Shopify API to simply show third-party Shopify store products without requiring any oAuth or per user accessToken? For instance by their Shopify URL or ...
0
votes
0answers
4 views

Google app: domain verification for Oauth is successful, but status remains “Pending developer action” [migrated]

I'm working on getting a Google app verified, and although I have completed the domain verification, the Oauth consent screen says that it is waiting on me to "comply with domain verification ...

15 30 50 per page
1
2 3 4 5
623