Blog

I have a Google Form that asks people to fill out their name, gender, and then their size preference for shirts and pants. The form automatically outputs the 2 sizes in separate columns. I want to combine the size columns while retaining the name and gender of the respondents, like this: I know I canRead more

I am working with a fee sheet that goes up in $ increments based on time and I would like google sheets to do the math to calculate the cost based on the time entered into a cell. EXAMPLE: a time value of “1” entered into a cell will always equal $ 800. Every additionalRead more

Originally my commits would just say “Username committed…”, but now they say “Username authored and committed…”, and it appears gray and no longer lists me as a contributor. It lists me as both the committer and author and shows a default image instead of my profile pic.Read more

I know my gmail account, my user name and phone number. The problem is I forgot my password, recovery account and I already changed my phone number that’s the reason why I cannot receive a verification code everytime I want to my password..Read more

Somehow several emails get not delivered to my Gmail inbox, but are available within search for the sender. If I click on “all message” they will be inside the list but have no lable like e.g. “inbox”. They however have one thing in common, all those “lost” emails are from my internal domain like support@domain..Read more

Is there a way to name a range so that it doesn’t automatically change when rows are added in between? Ex: Range1 = ‘Sheet1’!K5:K36 Add a row between rows 6&7 and now this automatically changes to Range1 = ‘Sheet1’!K5:K37 When i go into the named range sidebar, i’ve tried to change the formula to say:Read more

How can one tell the action triggered the onEdit function in Google Apps Scripting? The actions I have found to trigger it include: edit a cell delete a cell or range cut or copy a cell or range Copy a sheet I would like something similar to the onChange’s changeType attribute that tells me whatRead more

This is a nested if loop I wrote in google spreadsheets Whenever I enter a value for B5 between 0 and 1 like 0.5, it says there is “no match”. I think there is something wrong with the last section of the code. I was wondering if anyone knew how to fix this? Thank youRead more

please can some one help me with the low down on the schema and idea on how to develop or include a payment portal with the description below (it is a school portal where by a student logs in and generates an invoice, with the invoice he proceeds to a bank pays in the cashRead more

I’m working with Google Sheets and want to highlight cells in long date format (e.g. 11/13/2018 21:00:00) that are Tuesday and 21:00:00. Here is my attempt: =AND((weekday(C4:C124)=3),(EQ(RIGHT(C4:C124,8)),”21:00:00″)) What I understand this to say is “if the weekday is Tuesday AND the eight characters at the end of the cell is equal to 21:00:00, then highlight.”Read more