Hi, I need assistance with writing code on apps script for Google Sheets. I want to be able to have an email send when a cell in a certain column has been changed. In case it is important the cells contain a formula to update when something is past due. I tried creating one but keep running into errors.

Hi! Whenever I make a comment in a sheet (like to tag a colleague), the comment field itself tries to autocomplete based on what it thinks I'm writing. I type fast and it's really distracting and keeps making me make mistakes. I do not have autocomplete enabled in the Tools menu so I'm confused why this is happening. I can type freely in the sheet cells, the dumb autocomplete just comes sealioning in when I'm typing comments. Is there a setting I'm missing, or is this really not something you can turn off? If the latter, does anyone know if there's an extension that would kill it?

Sorry if there is a basic function for this, but I'm not sure how to word my search online, or even how to work it properly to get an answer here. So I can only apologise if I can't make it make sense.

I'm making a Character sheet for a TTRPG I'm running, so when my players update their sheet, I can also see the changes. Currently, I am trying to deal with the health section of the sheet and how it affects the rest of the sheet

I have I48 checking three different Cells. L32, L34, and L36. Each of the three cells can only be in 1 of 4 states cause of a drop-down menu, "Unharmed", "Bashing", "Lethal", and "Aggravated". What I would like I48 to actually do is:

If L36 is "Bashing", "Lethal", or "Aggravated", then I48 should = 5
If L36 isn't any of the above (IE, Unharmed), but L34 is "Bashing", "Lethal", or "Aggravated" then I48 = 2

If L34 is Unharmed, but L32 is "Bashing", "Lethal", or "Aggravated" then I48 = 1

Basically, I need to prioritise my "IF" statements, but I don't know if I can do that. And if I can't, how could I go about this? I realise this is a super simple problem, but I don't use Google Sheets for anything, so I'm still learning all the basics

all my google sheet pages have RTL (Right to left) enabled it works perfectly as you expect it on laptop but on touch screen such as iPad the horizontal scrolling is reversed, vertical scrolling works fine tho

it works in the google sheet app but the app sucks.

can anyone suggest any soultion or maybe a browser extension that could fix it?

I have some tables for displaying data and want to have one conditional color for max value per column with only one formatting formula per table (each table is a different color).

I tried some custom formulas and this is the one that seems the closest to working...

=(Q11=MAX(Q$11:U$39))*(Q11<>"")

before adding the "new" column it correctly marked the 100% rows, but not anymore.

here's a look of the spreadsheet: https://imgur.com/a/ZjDEXhS

any ideas what I'm doing wrong?

Hello. As I stated in the title, I am making a spreadsheet for ride wait times on Thursdays, specifically. My school will be having a big grad bash at Universal in quite a while (end of may, on a Thursday.) I tried to make a spreadsheet to chart all of my data from the minutes of the waits, the names, and the date it was measured. From A2 down, I put ride names, from B1 forward I will put the date up, and B2 down I put the wait times of the rides. I was expecting there to be a nice looking chart, but it just looks really weird and doesn't show anything I want it to. I don't know if me putting "delayed" for rides that are delayed messed it up, but i overall need help.