yogi_Automatic Sorting Of Form Responses Data By Columns D And B

                                          Google Spreadsheet   Post  #1336
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.   Aug, 17 2013
user Carrie Sanders 695 (http://productforums.google.com/forum/?zx=w2l93ktjgxm4#!category-topic/docs/spreadsheets/eU2MVSDIPRg)
Sorting Issue
I am using a sheet that was created for me by another user.  Up until the last week it has been working wonderfully.  Last week, no longer allowed me to sort any of the data.

https://docs.google.com/spreadsheet/ccc?key=0At-TqrcM25CfdE5hcG9OX2NRcThSeUpyNnFUeHJDeXc#gid=8  Here is the sheet.  Data comes from a form. 

When I enter new data via the form it shows up at the bottom of the form.(see lines 523 and down)  I want the form to be sorted alphabetically by column D (breed) then by column B (name).  When I click on column D and click on the Data tab the option to sort is greyed out for me.

Question1: How can I sort if it is greyed out?
Question 2: Is there a way to autosort the data when it comes into the sheet itself? (so I don't have to sort it later)

Thanks for your time!
----------------------------------------------------------------------------------------------------------------------------------------------

yogi_Compute The Quantities Of Items To The Right Of Items In A Multi-Column Item_Quantity SetUp

                                          Google Spreadsheet   Post  #1335
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.   Aug, 16 2013
user JGmero (http://productforums.google.com/forum/?zx=qf6jms75czic#!category-topic/docs/spreadsheets/_RkDFZJOZrs)
Find the name of an item and pull the number on the column beside on the right
Hello Everyone,

I am almost bald because of this problem!

We are using the forms to enter pie orders to a spreadsheet but the orders can be several different pies in one column, i need to count each particular pie that can be in 4 columns (see attached)

Employee Name

Order Number:

Pickup DATE

PickUp TIME

Purchase 1

Qty

Purchase 2

Qty 2

Purchase 3

Qty 3

Purchase 4

Qty 4

Pumpkin Pie

Apple pie

Cherry Pie

Antino

12345

11/24/13

AM

Pumpkin Pie

1

Apple Pie

2

Cherry Pie

1

Coconut Custard

1

1

2

1

Luis

12346

11/25/13

PM

Pumpkin Pie

1

Apple Pie

2

Cherry Pie

1

Pecan Pie

1

???

??

??

Test

12347

11/26/13

PM

Apple Pie

1

Pecan Pie

2

Pumpkin Pie

2

Cherry Pie

2

Antino

12349

11/26/13

AM

Pecan Pie

1

Pumpkin Pie

2

Coconut Custard

1

Apple Pie

2

I need to figure out how to search for Pumpkin Pie in the Purchase columns and then get the quantity to the right of the found column.

So search Purchase 1 for Pumpkin Pie in the Purchase1 to Purchase4 columns and if found in any column, give me the total of the Qty1 thru Qty4.

is that possible?

if it doesn't find it - put a Zero or blank 

please help,

thanks in advace,
Jorge Garcia 
----------------------------------------------------------------------------------------------------------------------------------------

yogi_Pull Data For Select Columns For Matching Value of Equipment In Another (Submissions) Sheet

                                          Google Spreadsheet   Post  #1334
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.   Aug, 14 2013
user Wisdomless1 (http://productforums.google.com/forum/?zx=a0wkoqyr2dyg#!category-topic/docs/spreadsheets/_mgjPrzB1V8)
Querying to select and trim to only the first row matching criteria
https://docs.google.com/spreadsheet/ccc?key=0AlDD-0aeaKbHdEF0dHBhU19UR3BSd0FpaWpIcFM5V0E&usp=sharing

Hello, I'm trying to work on querying submissions made from a Google Form so that only the most recent entry shows.

In the sheet I shared for this example, I want to make a function in cell B8 such that it only selects the row in columns A, B, & D that matches the value in A8.

As far as I can get would be:

=query('Submissions'!A2:D, "select A,B, and D where C=X-16")

But this will also add the second row that contains this value.  I also can't seem to figure out how to get it to reference A8 as X-16 instead of having to typing it in manually.

I don't know how to trim it or whatever, but I would really appreciate any help on this matter!

------------------------------------------------------------------------------------------------------------------------------------------------

yogi_From Table Of Item Amount1 Amount2 And Total Columns Create Pie Chart For Item And Total Columns

                                          Google Spreadsheet   Post  #1333
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.   Aug, 14 2013
user TTTECH (http://productforums.google.com/forum/?zx=a0wkoqyr2dyg#!category-topic/docs/spreadsheets/I-TWvmmyqyo)
How would I label the legend in a pie chart?

Attachments (1)

label-chart-question.jpg

86 KB   View   Download

-----------------------------------------

yogi_Set Up A Formula To Extract Spreadsheet_Key From Spreadsheet_URL

                                          Google Spreadsheet   Post  #1332
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.   Aug, 14 2013   UPDATED Jan-29-2018
user Wgalter (http://productforums.google.com/forum/#!category-topic/docs/spreadsheets/P3nuLETTVrI)
Is the a formula to estrack just the spreadsheet key

Hi,

Im looking to be able to extract the spreadsheet key from the google docs active url that sits in between the = and the # signs into a sheet cell of the same spreadsheet

https://docs.google.com/spreadsheet/ccc?key=0AmwF-VlpbalblabalbalbablahcVNM0E#gid=23

is a script or a formula I could do this with?

Thanks in advance! 

Wilson

--------------------------------------------------------------------------------------------------------------

 

<!- ->

yogi_Compute The Nth Instance Of Amount Associated With Specified Item

                                          Google Spreadsheet   Post  #1331
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.   Aug, 12 2013
user Anthony Sparks (http://productforums.google.com/forum/?zx=yefxq03jk0i0#!mydiscussions/docs/vcNNvOANAGI)
VLOOKUP() returning incorrect value

Using = VLOOKUP( "Salary",$A$1:B4, 2 ) to preform a search on this data:

Salary	2000
Salary	1000
Long Term
IRA Contribution	-130

Yields: -130

Expected Value: 1000

Anyone else have a similar issue?

---

I need it to perform as Excel would, if you take the same data, same equation, different results. I don't want them to be sorted because they are in chronological order. I need the last instance of Salary that was introduced.

------------------------------------------------------------------------------------------------------------------------------------------------

yogi_Compute Row By Row Total Of Values With Prices Embedded In Row 1 And Quantities In Row 2 Down

                                          Google Spreadsheet   Post  #1330
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.   Aug, 12 2013
user MenkoJ (https://productforums.google.com/forum/?hl=en-US#!msg/docs/JzGIr3pEdkE/pS1S3iagjGAJ)
Calculating totals from form input using an array formula
I have a form where people are inputting a quantity of an item, each in a column.  I want to create an array formula that will take that quantity and multiply it by a price (different for each column) and have it create a total based on those calculations.  I'd like the array to do that automatically each time the form is submitted.  I've got an example here: https://docs.google.com/spreadsheet/ccc?key=0AhBia3HTZkAVdEV0U0dVYlRNZnl3d1dIOTd0TGptZmc&usp=sharing Any input on creating that would be great.  The price is indicated in the name of each column

Thanks!

Menko
-------------------------------------------------------------------------------------------------------------------------------------------------------------