Indirect Formula

[Treesh1994]

What I am looking to do is if column AD in "2024 SEP Work Charts" drop box says "Yes" Or "Yes With Problems" the whole row in "2024 SEP Work Charts "B" Shop" turns green.

I am new to the indirect formulas and cannot figure out how to get this to work. Maybe using indirect isn't the answer but it's what I have gathered when using 2 different tabs on google sheets.

Any help would be greatly appreciated.

Below is the link to the document.

Copy of 2024 SEP Work Chart

2024 SEP Work Charts Customer,SFL or SEP,QTY,Stock Number(s),Order Number(s),Vehicle,Start Date,Customer Equipment,Package Number,Equipment Status,Ship Date Or Items We Are Missing,Pre Check,Pre Build,Lights Done + Harness Done,System Done ,Lightbar Color,Exterior Lighting,Push Bumper Or Lit Pus...

docs.google.com

 

[skillilea]

Still getting the same error on this sheet: 2024 SEP Work Charts

 

[Treesh1994]

Still getting the same error on this sheet: 2024 SEP Work Charts

When I click share on both pages, it says that you are an editor

 

[skillilea]

Looks like it's working. Let me know if you see different.

 

[Treesh1994]

Looks like it's working. Let me know if you see different.

Did you change something? It wasn't working yesterday past A10 on the copy and the original

 

[skillilea]

Help me understand what requirement is not being met.

all the PD11-PD16 seems to be lining up.

 

[Treesh1994]

Help me understand what requirement is not being met.

all the PD11-PD16 seems to be lining up.


View attachment 105855

So when I copied the formula to the original, once I went past A10 nothing was filled in the column I where it should have said "yes" based off the 2024 SEP work chart. I made sure that it was marked "yes" or "yes with problems" but nothing showed up in column I

 

[Treesh1994]

Help me understand what requirement is not being met.

all the PD11-PD16 seems to be lining up.

 

[Treesh1994]

Okay so I ended up figuring out what the problem is but not sure how to fix it. We have customers that will buy products more than once so in the doc that I shared with you, PD1 could purchase something later this year and I think that it is referencing the first time something was purchased and not the current one. If you look on the "2024 SEP Work Chart" I have over 400 columns that are hidden because we are done with the service. So if PD1 purchases again then it will
1) "2024 SEP Work Chart "B" Shop" will be highlighted if the first time they ordered was marked "Yes" or "Yes With Problems"

2)
2024 SEP Work Chart "B" Shop" will not be highlighted if the first time they ordered was not marked "Yes" or "Yes With Problems".

I have provided an example on the sheet that I have shared with you if you can take a look at it.

Any help would be greatly appreciated!

 

[skillilea]

A couple thoughts, you are really trying to track transactions by client/customer. To do that you probably are looking for more of a database solution. Maybe access or SQL.

If you want to keep it in sheets, maybe:

1. Move the old transactions to an archive sheet and only work with your current transactions.
2. Create a date column and use your existing approach. Find your record by: matching date >= and your PD

 

[Treesh1994]

A couple thoughts, you are really trying to track transactions by client/customer. To do that you probably are looking for more of a database solution. Maybe access or SQL.

If you want to keep it in sheets, maybe:

1. Move the old transactions to an archive sheet and only work with your current transactions.
2. Create a date column and use your existing approach. Find your record by: matching date >= and your PD

Okay that makes sense!
Thank you so much on your help on this.

Sorry for the confusion that this has caused