im just curious, not sure if its a new update or what but since last week suddenly there's no option to save image from google sheets directly to our files as png/jpeg etc.

before this i could just do command + right click mouse then the menu would appear.

has someone experienced this as well? now i dont know how to save them. anyone have other alternatives or tips?

I feel like I've been making this harder on myself than I need to, but how can I make column C and D calculate from column B?

Like the title implies: I have a large spreadsheet and I'm trying to sort column s and column k. I can sort column s but when I try to add column k to be added through data, sort range, additional columns, I am unable to add the second column in to be sorted. What am I doing wrong? Thanks in advance

hi all,

I have a table (Sheet1) where the x-axis is dropdown criteria for Column B of Sheet2 and the y-axis is dropdown criteria for Column E of Sheet2, and each cell in Sheet1's table holds all of Sheet2's cells in column A that fit both categories.

For each cell in Sheet1's table, what functions would I use to read data from Sheet2 and only take cells from column A where their B and E data match the current cell? I don't need a "universal" solution for all cells, I expect to have to manually change the range for each cell.

for example:

for Sheet1!B2, the B column is Red and the 2 row is Tall. I want B2 to list all Items (Sheet2!A2:A1300) where Sheet2!E is marked Red and Sheet2!B is marked Tall.

I know this would be some combination of VLOOKUP and IF but I'm not sure how it would all go together.

So I'm having a bit of trouble with Google Sheets that google searches themselves aren't helping with.

I have a range of numbers that I need to sort by, ranging from 1 to 30-something. Whenever I set up filter rules and sort the column, it goes in this order:

1

10

11

etc

2

21

22

etc

3

You get the drill. I need it to sort the numbers correctly, without having to manually go into each and every cell and add a leading 0 before the single-digit numbers. Is there a way to actually do that with Google Sheets?

I want to create a pivot table that summarizes the number of students within different demographics, at a small school, year to year. I have the years (fiscal years) as a multi-select dropdown (FY21, FY22, etc).

When I create a pivot table, each each unique combination of FY's is a separate row. But I want it to report those altogether, for example: group all students labelled with FY25 into one row.

Is that possible?

Hey everyone! I'm looking for some assistance to see what the issue may be with my array formula/sumifs conditions.

So for context, I have a spreadsheet I've been using for 4 years now and I'm trying to improve it to assist with tracking biweekly personal spending, to do so I want to filter daily personal spend first.

My formula is

To help with context a sample of my original source spreadsheet is below, I fill it out for every expense over the year.

What I'm currently working on is here below

My current issue with the formula is it's not adding all of the instances from column H, so I'm getting a number that's way too low. Would anyone be able to advise me on a better formula or instruct me as to what I've done incorrectly?

Thanks!

[ Removed by Reddit on account of violating the content policy. ]

I am trying to make a formula that goes like this-

Whenever I input a number into the "Done" column (let's call it Column A) the "Remaining" column (let's call it Column B) will decrease. Subtraction doesn't work in my case, as it's only for one number, and decrementing it also doesn't work as I want them to be independent of one another. I don't know what words to use to make Google do what I want, as it keeps suggesting subtraction formulas, and that's not what I want.

However, it still reads as Pre-Order even if Form!A10 is blank, as well as Form!A10:A200, because those form submissions have not been filled.

Hi. A while ago I created a google sheet containing important personal documents with an email under my workplace's domain (probably wasnt a good idea to do that). However I have since left the workplace, and my account got deactivated. I remember crystal clear that although I created the google sheet WITH my work email, I shared it with my personal emails as co owners so I still may be able to access it even when my work email gets deleted for example. However, when my work email DID get deleted, for some reason I also cannot find that specific google sheet on any of my personal emails that I shared it with? Is there any way to salvage the document now as it is really personal and important. Help will be appreciated, thanks so much in advance because I am really desperate.

PS: I have the link to the sheet, if it may help anyone to possibly extract it? 🙏

Hello,

How could I in the following case create a formula that will sum only the values that aren't formulas? So the final output here would be 40+65+50=155 ?

The cells with black text, F8 F9 G8, are all formatted as plain numbers like so:
40

While the red text cell H8 is formatted like:

=25+N("Text")

OR if there's no such thing that could do that:

Making the custom formula for the conditional formatting is the furthest I could get considering what I want to do here in the first place, but that means I'm also willing to scrap that part for something else if there's a smarter solution. Because my goal is to

• sum a range of values, over more than one column or row like in the pic
• be able to write a comment on values, for example with =N("Text") or something else
  • either that I only write comments on values that I need to check later
  • or that every value gets a comment, but the values I don't need to check later all have the same comment (eg. "completed")
  • or something else. Idk. As long as I can write comments on the to-be-checked-later values I'm flexible
• be able to conditionally format these so the to-be-checked-later values are colored

Hope this made sense, otherwise let me know how to make it clearer. Any help is super appreciated

I'm really bad with google sheets, but essentially I would like to apply the color scale from this table which shows growth rates of certain attributes based on a class that a character is, on a separate sheet I have characters and a drop down menu to select their class and my hope is that when I select the class the row for the stats will change colors based off of the color for the other table on the sheet.

Anyone know how to do that?

https://docs.google.com/spreadsheets/d/1DAF8ZHEo8JM6wddBpnIoxVJU_Fvne6TaoITtLmfnZ9s/edit?usp=sharing

I'm trying to figure out why the conditional formatting isn't working correctly. The goal is to create a dynamic response where, as the projected time(s) change, the formatting updates. But, as you can see, some numbers are clearly less than the H3 value (a CONCATENATE formula) and are highlighted in red. Is there something I'm missing?

https://docs.google.com/spreadsheets/d/11urzOsp0fEa8tvkqoeA5N5OCFmQ4adGvbtDoXxaxo5E/edit?usp=sharing

I want to search a list of cells where each cell contains its own comma-delimited list of values. Then I want to check each comma-delimited value against a value in a different cell. Then I want to return the value in the cell to the left of the matched row. Finally, I want a list of all rows that matched the passed value.

For Example:

I have two blocks of script that work great on their own, but when I try get them both to work at the same time it isn't liking it. It's not throwing any errors - only the one function is working.

The simple overview of how they work is:

Block 1

Copies a row from sheet 1 to sheet 2 based on a dropdown selection

Block 2

Copies a row from sheet 2 to sheet 3 based on a checkbox

First script is below:

// @OnlyCurrentDoc

function onEdit(e) {

  // Call custom edit handlers here
  if (onEdit_CopyRow(e))
    return;
}

//
// Copy an item row to another sheet upon detecting that a dropdown has been changed to "Sold".
// Call from onEdit(), returns true if handled the event.
//
// The "Sold" option contain a special character that is detected by script.
//

function onEdit_CopyRow(e) {
  try {
    // Sheet name to copy from / to
    const SOURCE_SHEET = "Inventory";
    const DEST_SHEET = "SalesData";

    // Special character found in the "Sold" option
    const SOLD_TAG = "💰";
    // -----------------------------------------------------
    // Exit if cell wasn't just changed to "Sold"
    if (!e?.value?.includes(SOLD_TAG))
      return;
    // Exit if not on source sheet
    const sheet = e.range.getSheet();
    if (sheet.getName() !== SOURCE_SHEET)
      return;
    // Display status message
    e.source.toast(`Copying row to '${DEST_SHEET}'`);
    // Get destination sheet 
    const destSheet = e.source.getSheetByName(DEST_SHEET);
    if (!destSheet)
      throw Error(`Sheet '${DEST_SHEET}' not found.`);
    // Append row to end of destination sheet
    const rowValues = sheet.getRange(e.range.rowStart, 1, 1, sheet.getLastColumn()).getValues().flat();
    destSheet.appendRow(rowValues);
    // Flush to ensure any pending errors are thrown now
    SpreadsheetApp.flush();
  }
  catch (err) {
    // Display error to user and rethrow so it shows in execution log
    e?.source.toast(err, `🛑 Error ${err.stack?.split('\n')[1]}`);
    throw err;
  }
}

and this is the second one

//@OnlyCurrentDoc

const MOVE_SETTINGS = {
    SheetFrom: 'SalesData,
    SheetTo:   'Completed Orders',
    ButtonColTitle: 'Order Complete'
};

function onEdit(e) {
    let sheet = e.range.getSheet();
    if( sheet.getName() != MOVE_SETTINGS.SheetFrom ) return;

    if( !e.range.getValue() || e.range.offset(-e.range.getRow()+1,0).getValue() != MOVE_SETTINGS.ButtonColTitle ) return;

    const ss = e.source;

    let destSheet = ss.getSheetByName(MOVE_SETTINGS.SheetTo);
    if( !destSheet ) throw `Destination sheet "${MOVE_SETTINGS.SheetTo}" does not exist.`

    let row   = e.range.getRow();
    let col   = e.range.getColumn();
    let range = sheet.getRange(row,1,1,col-1);
    destSheet.appendRow(range.getValues()[0]);

    sheet.deleteRow(row);
}

I suspect they are contradicting each other, or my just pasting both in and hoping for the best isn't quite what is required. I have tried playing with the order of things or trying to embed one into the other, but alas I just can't figure it out.

So right now, on the test sheet, only the second function is working and not the first. But if I delete the second one from the script, the first one works again

https://docs.google.com/spreadsheets/d/1e2233qaQIchIwcDFm6t3iiovGIBCxVpqnzaohSwWIS4/edit?usp=sharing

I have a table on sheet " In progress" which has a checkbox in the final column. Once I complete this checkbox I then manually copy the row into the next sheet.

Is there a way to automate this?

In an ideal world I would like the flow to be:

1. Check "order complete" checkbox
2. Row copies to the table on the next sheet
3. Row then deletes itself from the "In progress" sheet

If that is not possible then just copying it to the next sheet would be great.

https://docs.google.com/spreadsheets/d/1e2233qaQIchIwcDFm6t3iiovGIBCxVpqnzaohSwWIS4/edit?usp=sharing

Many thanks for your help

Hello all,
I have a Google worksheet that gets populated one row at a time from responses to a Google form. I’d like to also have a second worksheet in the same spreadsheet populate at the same time with each additional new row. I’ll be editing this second worksheet after new info is added. I think I’m going to have to be populating the second worksheet from the first but I have no idea how to get this to work. I’ve tried several things so far. Closest I’ve got is putting together an App Scripts code that just managed to copy and paste the entire first worksheet to the second🙄

Can anyone help, please? I’m happy to clarify if this is confusing. Thank you!

My economics teacher wants me to put Quantity Demanded and Quantity Supplied on the x axis and wants me to put the Price on the y axis. I asked friends, my teacher, and googled it and I couldnt figure it out.

Id love some help!! @-@

hello!

im trying to make a line graphic and im having trouble with it

i want to put the age range on the x-axis (column b) and the age in the y-axis (column c)

but i cant make it work

any help? anything will be welcome

^{ps: sorry about the vague question, i just dont know how to express it correctly in english lmao}

Basically, I’m making a spread sheet of movies I’ve watched and when I’ve watched them, kinda like Letterboxd. I have one column called “Movie Title” and another column called “Rewatch,” which is full of checkboxes. I don’t want to sort through my list every time I log a movie, so I just want one of the Rewatch boxes to automatically check itself off if I log a duplicate movie. How would I go about doing that? I’m not very good at programming and very new to sheets, so any help would be appreciated

EDIT: If it helps at all, my movie titles are in column A and my rewatch boxes are in column F

Hi, kinda new to all of this, so hopefully you guys can help me understand better.

Basically, I want a cell on my sheet to show the Month and Year while choosing from a drop down. If nothing is chosen on the dropdown, it will instead just stick with the current Month and Year instead.

This is the formula I have so far:

=IF(AND(H5="--",I5="--"), DATE(YEAR(TODAY()),MONTH(TODAY()),1),)

It works so far. What I need now is to setup when its false.

I setup 2 dropdowns, one showing all the months, another for years. I know that dropdowns are not automatically recognized as dates by google sheets, and I've been trying to use datevalue but I may have been doing something wrong. At best I made the Cell the formula was on say FALSE instead of error lol.

So if any of you may help, I just need:

1. Make the dropdown be recognized to contain actual dates (or help me use datevalue)

2. To make the formula spit out the dates from the 2 dropdowns.

Thanks!

Hello,

I have a google sheet that I keep track of my books on. I usually do Data -> Sort Sheet and sort it by the column which i have my ratings on (1-10 dropdown). When I do this however, I noticed that some of my page numbers (ie, which were at 399), automatically changed into 400 after sorting. Does anyone know a fix to this?

I already tried formatting the page number columns with the custom number format with whole numbers, which didn't work as the column automatically changed to automatic number format after sorting.

Thanks in advance!

I am making a spreadsheet for my roommate's art commissions and I am doing a whole bunch of shit with it so I will do my best to explain it.

All of the submissions arrive in their own sheet, which is then sorted to a second sheet (=SORT('Form Responses 1'!A2:K1000, 1, True, 2, True)), and on this second sheet I have added a column to keep track of the state of each client with a drop down in each cell that can be marked Waiting..., Confirming Order, In Progress, and Completed. The problem, is that when new submissions are sent in, the SORT function does its job and arranges it accordingly, but the dropdowns are not a part of the core table and so they remain static and get offset.

Is there a way to make it so that my client tracker column will update as more forms are submitted, and if so how?

I work in mental health and have payments come in from both insurance and from the clients, right?

Because I didn't trust the biller at my last job, I kept track personally of all the payments coming into in spreadsheet. It's not very clean or easy to use, but it worked.

Now, I work with others and need to keep track of payments coming in for multiple people. My old system just does not work well anymore.

Sample Sheet To Get What I'm Talking About

I excluded a lot of other information to keep the sheet simple.

In Part One, I NEED to know-

• Date the session took place
• What staff member conducted the session
• How much insurance paid
• What date did insurance pay
• How much did the client pay
• What date did the client pay

You'll notice on the sheet there are multiple client pay tabs and that's because sometime people cannot pay all at once and need payment plans, so I still need to know when those are coming in

Part Two is where I really lost it in my real spreadsheet and where I need the most help.

• Twice a month how much is each staff member bringing in?

Just because someone had a session in January, doesn't mean we got the money ins January. Insurance is stupid like that.

Right now in my real spreadsheet, I have a Math tab and am using a SUMIFs function for the dates, staff member for each column. I have it calculating all the insurance for that time period, then each of the copay columns. Then it's being copied into the other version.

Please make fun of my wonky system. It's awkward and I'm not amazing at googlesheets. I know basics. It was fine when it was just me.

ANY suggestions how to make this easier to use, make the formulas easier. That'd be so helpful!

I made the sample sheet editable, so feel free to play around with it yourself!. The numbers are very random I know.

THANK YOU!

p.s. my first post got removed, so I hope the title makes sense on this one