yogi_Conditionally Format Cells In B2:B If They Occur In 'CHECKOUT SHEET'!B4:B

Google Spreadsheet   Post  #2312

Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     Dec-05-2017

question by: aaronjk

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

Conditional formatting by number from sheet1 that strikes through same number in sheet2

I have a spreadsheet that we are going to use for inventory and checkout via asset numbers.

Sheet1 has the checkout log, and sheet2 has the inventory.

In sheet1, I have column B serving as the asset numbers, which is a data validated drop-down list.

The same numbers in the drop-down list in column B on Sheet1 are listed in sheet2 in column B.

I want an asset number in sheet2 to have a strike-through when sheet1 has the number added in column B.

For instance... If Sheet1 asset number 12345 is selected from the drop-down menu, then strike-through asset 12345 on Sheet2. 

https://docs.google.com/spreadsheets/d/1taFHo0irH8LWuB7GmY7UDl6HB1gEsAbwvyJWVikco8s/edit?usp=sharing

yogi_Conditionally Format A Block Of Cells Depending On Current Time

Google Spreadsheet   Post  #2311

Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     Dec-05-2017

question by: greenscreen20

https://productforums.google.com/forum/#!topic/docs/ThrfEl-r5S0;context-place=forum/docs
Conditional formatting based on Time
Hi guys,

This is a bit of a 2 part question, but it doesn't seem to work well on google sheets.  It seems fairly straight forward.


I want to do a conditional format of one cell, based on the comparison of 2 different cells.


Example, a set of cells turn GREEN if the current time is greater than a certain number.  To break it down further, if it's past 6:00am I want a set of blocks to turn green.  If it turns 6:30 a different set of blocks turn green, and the ones from before go back to normal.

For some reason the sheet doesn't format properly when I try an expression.  I was doing a conditional format such as =A7>S2, comparing A7 (time in the time block) compared to S2 (current time aka =(now() - today()) ) Some of the cells change color but not in the way I would expect. Here is the spreadsheet displaying what I want without the expressions, this is an editable link so if someone has the time / knowhow I would really appreciate it! https://docs.google.com/spreadsheets/d/11YajgdnKuXFLqAOeCkVzZIzQ95fb1ew501sSEsDfJAQ/edit?usp=sharing

yogi_Annual goal split into the months with auto update based on results that month

Google Spreadsheet   Post  #2310

Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     Dec-04-2017

question by: Heather Etzel

https://productforums.google.com/forum/?utm_medium=email&utm_source=best_answer_notification_button#!topic/docs/Q_AUXk4GQyk;context-place=forum/docs
Annual goal split into the months with auto update based on results that month

I am looking to split up our annual goal of lets say 96 (this will need the ability to be changed due to market conditions for the year we are projecting) active listing into a monthly goal to achieve that 96. BUT with the ability to have the numbers auto update for the following months to still achieve that goal based on the actual number obtained in prior months.

So say the 96 is projecting we need 8 listings a month starting in January.. and we end up obtaining 10 listings.. I want it to auto adjust to maybe say like 6 listings in Feb and 8 in the remainder months etc.. can this happen and update as we plug in the actual obtained listings somewhere.. possibly a hidden sheet that feeds the numbers? 

The yellow is where I want the figures to be shown. Thank you. 

https://drive.google.com/open?id=1y2C6i34JxMZavkHO0c0Wn5tXB2FjotV4qUTHPBARPCo

yogi_Create A DataValidation List By Filtering Original Data For Specified Condition

Google Spreadsheet   Post  #2309

Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     Dec-04-2017

question by: Samjco

https://productforums.google.com/forum/?utm_medium=email&utm_source=ba_notification#!topic/docs/miB-3bOsHsQ;context-place=forum/docs

How to add conditions to a filter

I have this example sheet:

https://docs.google.com/spreadsheets/d/1RcRefeWG_a_m0Ll1do3LQxn8AQJtWmAl9Nwm4dreBvQ/edit?usp=sharing

It allows me to pull in data into a dropdown on sheet1 based on data in sheet2 where there is an "X" in the availability.

The filter that does this on sheet2 is:

=FILTER(A2:A,B2:B="x")

However, I am trying to extend the filter a bit by not showing the name in the list where B2:B = "X", if I have selected it on sheet1

yogi_Count of Case Sensitive And Non-Case Sensitive Key-Words In Cell A1

Google Spreadsheet   Post  #2308

Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     Dec-02-2017

question by: appah

https://productforums.google.com/forum/?utm_medium=email&utm_source=best_answer_notification_button#!topic/docs/RJ8D5GyKKwE;context-place=forum/docs

Case sensitive count of occurences in a cell

 

Hi Everyone

I am trying to create a keyword density checker in my sheet, but i'm having problems getting the formula to ignore cases..

I've currently been using this formula:

=(LEN(text)-LEN(SUBSTITUTE(text,word,"")))/LEN(word)

It does the trick but only for exact, case sensitive matches..

This is an example where the text is the blue cell and the text to find the frequencies for are in the green cells: https://docs.google.com/spreadsheets/d/1asP1NHI-UqW0Xu7LxOGY0CCFi6_agfw1u0fAJmhWFPY/edit?usp=sharing

Can any of you help?

Thanks.

yogi_Query Data That Is Not SetUp In Normal DataBase Table

Google Spreadsheet   Post  #2307

Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     Dec-02-2017

question by: Co_Ha

https://productforums.google.com/forum/?utm_medium=email&utm_source=best_answer_notification_button#!topic/docs/Er17yp0xqEA;context-place=forum/docs

Help with query

 

I am attaching a link to a spreadsheet in which I'm hoping to query specific data. 

I'd appreciate any help you can provide. 

https://docs.google.com/spreadsheets/d/10ApNGt6r-s41hkTrfrS3UHBeNQLXUGADvUgm0dqPJVw/edit?usp=sharing

yogi_Pull Information From Multiple Columns Of A Spreadsheet And Show In One Cell Of Another Spreadsheet Concatenated By Rows

Google Spreadsheet   Post  #2306

Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     Dec-01-2017

question by: Robhero

https://productforums.google.com/forum/#!topic/docs/sH_YDBR_D7U

IMPORTRANGE FROM MULTIPLE CELLS FROM ONE FILE TO ONE CELL ANOTHER FILE

How to IMPORTRANGE from multiple cells from one file to one cell in another file?

Click the file here