I'm trying to create a Google Sheet to track pitches (I'm a baseball coach). I have a current sheet that I have a check box to click if the pitch was a strike or not, and then you have to choose a &...
I need help with a formula that needs to calculate the max sum held at one time for each month.
In this example it would be 54 for March (12+13+14+15, held on the 29/03/2021). Month is determined by &...
I need to create a unique ID from an existing list of order numbers. Pls see the image below:
What I want is for the existing duplicate order numbers to be made unique by adding an extra digit to the ...
I have a sheet in which I have 2441 words (hashtags) on their own rows in the first column and in the next (adjacent) column, a number related to them (occurrences of the hashtag in our data).
I want ...
Let's say I have a column of values, each of which is a string.
This is a string
This is longer than that
My favorite is short
But sometimes short is longer
How is a short longer
I would like to ...
(This is an updated version of this question - I am trying my best to make myself clearer this time.)
I am trying to use a query to copy values from one column to another.
Both source and destination ...
I have a list of files' names that I would like to sort based on the date that's impeded within the file name text (Column A folder). When sorting them, the number 10 comes after 1 instead of 1,2,3,4,...
I want to copy down filter formula using Arrayformula. I also gave a hand to copy down add-on but it's not giving required result. Here is a picture of an example sheet:
I am filtering the non blank ...
Assuming I insert every day some rows into Sheet1, this formula stops working and I have to manually edit every day --- can the reference to Cell A2 and Cell E2 be a variable that remains hardcoded as ...
I am trying to count the total cells that have a single decimal value.
Editable spreadsheet here:
You can see each non-blank row contains two lines. I'm trying to find a ...
I'm trying to create a simple Customer Lifetime Value calculation in Google Sheets that takes 4 variables:
Income first year
Retention rate (% chance of being a customer the year after)
Discount rate ...
I have created a scorebook sheet in google sheet for tracking live basketball stats.
One sheet with the scorebook table for the team with each player one a row.
I want to have a separate tab for data ...
I want to show the average of a range if any cell is populated.
However, my formula shows the average only if the first cell is populated.
I'm using the below formula: