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!


Saturday, February 17, 2018

yogi_Rearrange Data In Columns A:D To Data In DataBase Style

Google Spreadsheet   Post  #2374

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

question by: Alexis Matson
https://productforums.google.com/forum/?utm_medium=email&utm_source=best_answer_notification_button#!topic/docs/uja_PxRx9mk;context-place=forum/docs
Automating the reformatting of multiple data points in a single cell separated by commas
Hello,

I would like to know if it is possible to automate the re-organization of multiple pieces of data separated by commas in the same cell.

This is an example of what I am trying to accomplish:


Thanks for any help!

Sam

Friday, February 16, 2018

yogi_Conditionally Format F3:F If The Hyperlink Contained '/btscontentindex'

Google Spreadsheet   Post  #2373

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

question by: Neeve
https://productforums.google.com/forum/?utm_medium=email&utm_source=best_answer_notification_button#!topic/docs/o6X2c3j2SdU;context-place=forum/docs
Conditional formatting
I'd like to create a conditional formatting rule where if any of the cells' formula contain 'bts', they will turn red. Basically the same as 'text contains' but i want it to be able to search the formulas, all of which are hyperlinks.

yogi_Troubleshoot And Fix Formula Using SUM Function For Entries in E2:E22

Google Spreadsheet   Post  #2372

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

question by: Graystrickland
https://productforums.google.com/forum/?utm_medium=email&utm_source=best_answer_notification_button#!topic/docs/pnhEECod1w0;context-place=mydiscussions
=Sum() won't sum, but adding same cells (=a1+a2...) works?!?
I have a sheet where the sum function always returns 0, but if I write a manual formula simply adding the same cells (=a1+a2... etc.) then the function produces the correct answer. This means that the source data is *NOT* formatted as plain text. And I've selected all the source cells and made sure they are, in fact, formatted as numbers. Still the =Sum() function does not work. I am stumped. The only reason that I can imagine Sum() not working is when the source data is formatted as plain text, but that's not the case. here.