Friday, February 23, 2018

yogi_use QUERY to pull a specific day of the weeks information from a timestamp

Google Spreadsheet   Post  #2381

Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     Feb-23-2018

question by: Elgran MacBeth
https://productforums.google.com/forum/?utm_medium=email&utm_source=best_answer_notification_button#!topic/docs/bajgA4L1NE0;context-place=forum/docs

How do I use =QUERY to pull a specific day of the weeks information from a timestamp

How do I use =QUERY to pull a specific day of the weeks information from a timestamp submitted by google forms. That way I can make a Monday-Friday set of cells on another sheet and have the correct information for that day pull into it. I've been using this formula and changing it here or there where needed, but I cannot figure out what I would need to do to make that jump to a more complex formula. 
=QUERY('Master Layouts'!A2:I, "Select *")

I'm very new to using Spreadsheets and have mostly been able to get by with premade stuff I've found online so far. Any help would be greatly appreciated. 


yogi_look up a value in a cell that has multiple values in that cell

Google Spreadsheet   Post  #2380

Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     Feb-23-2018

question by: Colby Lehew
https://productforums.google.com/forum/?utm_medium=email&utm_source=best_answer_notification_button#!topic/docs/iFyRXjoR4Jk;context-place=mydiscussions
How to Vlook up a value in a cell that has multiple values in that cell
I have a sheet that records shipping & receiving.  I want to cross reference that all the scheduled orders have shipped. However, multiple orders go out on the same truck.   This means there are multiple orders in the same cell.  It also contains how many cases we received which might complicate the situation. I want to be able to Vlook up individual PO to confirm they were sent out. For example, I want to look up 4323753 ( the 3rd one). Bonus if I can get it to say Pass instead of just repeating the number or fail instead of N.A. Is this possible with multiple numbers in the same cell?  I will want the range to be the entire column as this will be an ongoing process. 

Thursday, February 22, 2018

yogi_Compute Sum By Day With Dates In Descending Order

Google Spreadsheet   Post  #2379

Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     Feb-20-2018

question by: Peter Kandell
https://productforums.google.com/forum/?utm_medium=email&utm_source=footer#!topic/docs/tP-pSgJJ3Jc;context-place=forum/docs
Sum per date
Hi.
Can anyone please help me? I want to sum the values of a separate date. Ex. one day I have 4 amounts I want to sum and another day I have 2 amounts I want to sum. In my example I want a formula that creates this Sums automatically.

Thanks a lot in advance.


Tuesday, February 20, 2018

yogi_From MASTER Sheet Create Sheet For Each SubCategory by TYPE

Google Spreadsheet   Post  #2378

Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     Feb-20-2018

question by: Eliza J
https://productforums.google.com/forum/?utm_medium=email&utm_source=best_answer_notification_button#!topic/docs/2mjCBsjKMfQ;context-place=mydiscussions

Have Categories Sorted Into Subsheet, EXCLUDE based on 1 field

Hi all - 

I have set up this spreadsheet to sort into the Subsheets based on "TYPE" from the master list. I would like a 2nd level of sorting, which would tell it to EXCLUDE any field from the MASTER that has "NO" Listed under "PREFERRED". 

For Instance, only TYPE: "PHOTOGRAPHER" + PREFERRED: "YES" Would sort into the "PHOTOGRAPHER" Subsheet. 

Thank you!


Monday, February 19, 2018

yogi_Compute Average $ Per Night For Specified Entity From Data For Number Of Days(column C) And Dollars(column H)

Google Spreadsheet   Post  #2377

Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     Feb-19-2018

question by: Curt Ranta
https://productforums.google.com/forum/?utm_medium=email&utm_source=best_answer_notification_button#!topic/docs/9LOX3I-sLRo;context-place=mydiscussions
Custom formula to look up value in column, then use adjacent column values to create ave.
Hello, here is my question:

Here is my spreadsheet:

Sunday, February 18, 2018

yogi_Compute Average Of Hours Worked By WeekDay From Table Of Date and Hours

Google Spreadsheet   Post  #2376

Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     Feb-18-2018

question by: KentuckyFriedIdiot
https://productforums.google.com/forum/?utm_medium=email&utm_source=best_answer_notification_button#!topic/docs/sZRKQEZVFeg;context-place=forum/docs
Averaging Hours Worked By Day Of Week
Hi guys,

I've been logging the days I work and the hours worked on each date. I'd like to get the averages for each day of the week. Here is my sheet 


Zeros are days not worked, I'm not sure if those would distort the average and if so, how to filter them out. Thanks so much!


yogi_Conditionally Format Column A by Alternate Day Rows

Google Spreadsheet   Post  #2375

Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     Feb-18-2018

question by: BDC_pgh
https://productforums.google.com/forum/?utm_medium=email&utm_source=best_answer_notification_button#!topic/docs/4E0-OhzNw2Q;context-place=forum/docs
Google Sheets - Alternate field color from grey to white, every other day
Hello :-)

Here's the sheet:

https://docs.google.com/spreadsheets/d/1W0MljRH5nJju-QP4hAVASj3080TN01XZNLl2NGuXYIM/edit?usp=sharing

Right now I am using conditional formatting to achieve the effect I want, but I have it set up to alternate field color from white to grey for only about a week (see image).

How can I have the date fields alternate between grey and white, every other day, indefinitely?

There's got to be an easier way to achieve this than what I have set up currently.


Thank you!