yogi_Create A Quilt Or Tile-View Of Selected Results

Google Spreadsheet   Post  #2029

Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.   Jan-21-2016

post by: danielrucci :

https://productforums.google.com/forum/#!topic/docs/N4HaSXQ1CuI;context-place=forum/docs
Create a "Quilt" or Tile-view of selected results

Team,

I have a long list of clients and certain aspects about them, which I'd like to pull into another tab and reformat into a "Quilt"-like view, if they meet certain criteria.

So if any customer in the spreadsheet is selected to be in the quilt (in order) then it gets pulled into a possibly endless quilt in another page. I'm also adding counts to the quilt page.

editable version here

https://docs.google.com/spreadsheets/d/12bqbc3ZB-ZKKKa8I2FUUI8GQIoEn_vGHfsa7X_c1UH4/edit?usp=sharing

thanks for your help

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

yogi_Conditionally Format Rows In Which Column A Houses 'closed'

Google Spreadsheet   Post  #2028

Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.   Jan-20-2016

post by: Marc Simmons126 :

https://productforums.google.com/forum/#!topic/docs/2HjB3a4jeFQ;context-place=mydiscussions

Conditional formatting of row (not column)

 

I have a google sheets spreadsheet that includes a column where the the cell's optional content is "open" or "closed".  I would like to make the row have a fill color of grey automatically when the value in this cell is "closed". Is there any way to do this?  Thanks for any help

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

yogi_Split Row By Row Set Of Courses Keyed In As A String With Comma Delimiter And Then Lookup Corrsponding Course Numbers From 'Course List'

Google Spreadsheet   Post  #2027

Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.   Jan-20-2016

post by: Michelle Roach:

https://productforums.google.com/forum/#!topic/docs/PnjVGtJvSEI;context-place=forum/docs

Remove a leading space that appeared after a split function

I have cells that will contain multiple parts for example French 1, French 2, French 3. I split it up but now would like to find a way for the space to be removed that is in front of French 2 and French 3.  I need the space gone because I'm also trying to do a vlookup in the following columns, using an array in another sheet. Here is a test spreadsheet:  https://docs.google.com/spreadsheets/d/174bTY332ZnlaOViWGVCD0q8kXTXeewVvZx-ycrxJxvM/edit?usp=sharing

Any help is appreciated!
-------------------------------------------------------------------------------- 

yogi_Restrict Entry 'Completed' Into Rows Of Column A Until Hours Have Been Entered In Column B Or D

Google Spreadsheet   Post  #2026

Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.   Jan-20-2016

post by: Tom:

https://productforums.google.com/forum/#!topic/docs/p2pqQ_KEJzU;context-place=forum/docs
Possible to restrict adding value if adjacent cell is empty?
Hi Again!

I'm at risk of running out of goodwill here after asking so many questions but this might be an interesting challenge to some of you geniuses!

In the sample sheet here - is there anyway to prevent setting the status to "Completed" until the hours cell next to it has been completed? The practical purpose for me is to remind (make) staff enter their hours working on a task prior to marking a job as complete.

Thanks as always :)

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

yogi_Compute Instance Of Most Occurring Weekday For Tasks In E20:E For Categories Specified In B1:E1

Google Spreadsheet   Post  #2025

Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.   Jan-18-2016

post by: Nuclear Buckeye:

https://productforums.google.com/forum/#!mydiscussions/docs/F8fhYOeU2aM
Find most productive day of the week - HELP!!!
...
from post 0f 10:21 AM Jan-18-2016

Thanks for the help so far.... I'm lost (as H***) as to how to use array formula and queries... you guys are too good.

I'm sharing a dummy sheet (sorry, didn't think of making a dummy sheet)

I have the categories up in Row 1. I actually want the most frequently reoccurring day, for each category

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

https://docs.google.com/spreadsheets/d/1Vx9ugj4c4ho5wK1PPJhzfD8vxNc-WNi0yiVDeBYKeXw/edit#gid=0

Cells B5:F5 are editable. I cleared a lot of it out to make it less busy.

Also, if possible, to have Cell F5 also since it'll be the best overall day of the week.

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

yogi_Split Entries In Sheet 'yC' With Collection Column F Delimited By Specified Character Into DataBase Layout

Google Spreadsheet   Post  #2024

Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.   Jan-18-2016

post by: Training Development Changi Airport:

https://productforums.google.com/forum/#!topic/docs/NL7QojMMoYs;context-place=forum/docs
How to generate new rows from multiple comma-separated values in a single column

Hi, I do not have any programming background in JavaScript but have been attempting to do the Apps Script to write codes based on what I read online.

I have reached a roadblock on one of the posts by Martin Hawksey on "Data Shaping in Google Spreadsheet – Generating New Rows from Multiple Values in a Single Column" (https://mashe.hawksey.info/category/mooc/page/4/).

Basically I need to do exactly what he did in his article, and I have my spreadsheet here https://docs.google.com/spreadsheets/d/1gqB4qZOvBXDBITZaxDfe8pUmx3EObLiUcIzmZ1U1xLg/edit?usp=sharing 

In the tab Form Responses 2, I have a Google form linked to it whereby people can enter multiple names by separating them with commas. I need to generate new rows from each name, and have the other columns and their contents duplicated into the corresponding rows. However when I try to use the below code, I am still unable to obtain the new rows with each name.

Is anyone kind enough to assist?

function splitColumnAndRepeatRows(anArray, splitColumnIndex) {
  var output = [];
  for (var i = 0; i < anArray.length; i++) { // for each row
    var splitArray = anArray[i][splitColumnIndex].toString().split("\n"); // split values in specified column
    for (var j = 0; j < splitArray.length; j++) { // for each split cell value
      if (splitArray[j] == "" && j >= 1)
        continue;
      var row = anArray[i].slice(0); // take a copy of source row
      row[splitColumnIndex] = splitArray[j];
      output.push(row); // push new row to output
    }
  }
  return output;
}

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

yogi_From Data In Table A16:E Compute The Most Productive Day (the day with fewest 'inc') In Column E

Google Spreadsheet   Post  #2023

Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.   Jan-15-2016

post by: Nuclear Buckeye:

https://productforums.google.com/forum/#!topic/docs/F8fhYOeU2aM;context-place=forum/docs

Find most productive day of the week - HELP!!!

I have a list of dates in A17:A in format eg, Sat. 16-Jan. 

I also have the categories for the type of work are in cells E17:E. One category is labeled "inc", short for incomplete.

How can I find the most common day of the week, eg. Wed or Tues, that I complete the work?

Desired Result format: Saturday, e.g.

(PS - cannot share spreadsheet since it has client info on it)

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