Use Script to update table Hi all, I need to update the transaction table with invoice numbers in Col U if there is a sales ord…

0 Updates 0 Recommended Answers 1 Reply 0 Upvotes

Query Function trouble with Time/shift selection Hi, I currently have some query functions picking out times depending on when they are free. ​​=QUER…

0 Updates 0 Recommended Answers 8 Replies 0 Upvotes

Multiply and add quantities by numbers in another column Hi! I'm working on a meal planner and grocery list generator and I'm having trouble combining some f…

0 Updates 0 Recommended Answers 2 Replies 0 Upvotes

Privacy question I want to link a Google Sheet with Excel. I am concerned that if I "Publish to the web" (as seems to…

0 Updates 0 Recommended Answers 0 Replies 0 Upvotes

My first keypress in Sheets is "ignored" - i.e. I try to type "Apple" and get "pple" I'm using the official Sheets app on an older Chromebook using physical keyboard. My problem is as d…

0 Updates 0 Recommended Answers 0 Replies 0 Upvotes

Tracking system using Appscript with google sites and google sheet Hi helpers, I have created a simply courier website in Google sites and I want my customer's to trac…

0 Updates 0 Recommended Answers 1 Reply 0 Upvotes

Form results inserting a new row I have a form that displays the form values in a sheet (Sheet1), I then have another sheet (Sheet2) …

0 Updates 0 Recommended Answers 0 Replies 0 Upvotes

Mathematics Hi all, So this might be a weird question but I am struggling to work this out, yes we did this at s…

0 Updates 0 Replies

Array Formula for Partial Text Substitution I've got a long list of data I'm trying to categorize. The ARRAY FUNCTION, IF & SUBSTITUTION Functio…

0 Updates 0 Recommended Answers 1 Relevant Answer 3 Replies 0 Upvotes

Attempting to find formula that would assign a value from table I've been trying to figure out which formula would work best for this sheet. In this case, I'm attem…

0 Updates 0 Recommended Answers 1 Reply 0 Upvotes

I am trying to access a google excel document created by a former employee I am trying to access a google document excel sheet, i am able to view it but unable to edit it - th…

0 Updates 0 Recommended Answers 1 Relevant Answer 3 Replies 1 Upvote

product and sum within date range https://docs.google.com/spreadsheets/d/1fruIZx7E5C78B783Islo1G3WqrX3X80jOq0If4tCplQ/edit?usp=sharing…

0 Updates 0 Recommended Answers 4 Replies 0 Upvotes

COUNTIF() formatting highlighting the rows above the duplicates Hi all and thanks in advance , using formula =COUNTIF($E$3:$E,E3)>1 to find duplicates in column E a…

0 Updates 0 Recommended Answers 2 Replies 0 Upvotes

Show Delivery Price in Cell from sheet 2 when Location name is typed in Sheet 1 Hi all, I am trying to automate my sheet so that it will update price in specific cell when a locati…

0 Updates 0 Recommended Answers 3 Replies 0 Upvotes

Cant add more decimal places to the percentages of my pie chart. Please help omg this is so frustrating. I just want to know how do I edit the percentage of my pie c…

0 Updates 1 Recommended Answer 7 Replies 0 Upvotes

Seeking App Script to allow multi-selections, in two different columns. i found an App Script which allows the user to select multiple items in a cell, adding each new sele…

0 Updates 0 Recommended Answers 1 Relevant Answer 3 Replies 0 Upvotes

Looking to highlight the time based on a half hour schedule I've tried most solutions, as people will see I tried a simple ​=Hour($A2)=Hour(now())​but that didn…

0 Updates 1 Recommended Answer 4 Replies 0 Upvotes

スプレットシートでタブごとでリンクが変わらない。 スプレットシートがタブごとにリンクが変わらなく、同じシート内でタブごとにリンクが変わりません。他のドメインスプレットーシートはタブごとにリンクが変わります。対応方法を教えて頂きたいです。

0 Updates 0 Recommended Answers 0 Replies 0 Upvotes

How do I show a blank cell if a calculated number is less than 0? How do I show a blank cell if a calculated number is less than 0?

0 Updates 0 Recommended Answers 1 Relevant Answer 2 Replies 0 Upvotes

Combine 2 google survey results into 1 form I would like to combine 2 identical surveys that were sent to different people into 1 page result

0 Updates 0 Recommended Answers 1 Reply 0 Upvotes