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

 

[Treesh1994]

Take a look at your sheet. I think it's what you want.

Yes that is exactly what I was looking for! I am sorry if i wasn't describing it good enough before.

Thank you so so much for doing this for me!

 

[skillilea]

Glad to help

Make sure to remove my access from your sheet.

 

[Treesh1994]

Glad to help

Make sure to remove my access from your sheet.

For some reason A10 ang going after on the "2024 SEP Work Chart "B" Shop" isn't auto filling column I which is the column you said I could hide.
Any suggestions?

 

[skillilea]

I'm confused. Ask it again. It looks like PD11 is pulling "Yes With Problems" just fine.

I'm not sure what this means "A10 ang going after "

 

[Treesh1994]

I'm confused. Ask it again. It looks like PD11 is pulling "Yes With Problems" just fine.

I'm not sure what this means "A10 ang going after "

I meant to say that on A10 and after it is not working on the "2024 SEP Work Chart "B" Shop"
I made a copy of the sheet for you to edit and copied the formula that you provided to the original sheet. Everything works as intended until I get to A10 and after.
Once I changed the drop down Column AD on the "2024 SEP work Chart" to "yes" or "Yes With Problems" the A10 and after on the "2024 SEP Work Chart "B" Shop" nothing shows up on column "I" where you put the index and match formula.

I hope this makes sense

 

[skillilea]

I can't edit this sheet "Copy of 2024 SEP Work Chart" to test. Can you open that up?

 

[Treesh1994]

I'm confused. Ask it again. It looks like PD11 is pulling "Yes With Problems" just fine.

I'm not sure what this means "A10 ang going after "

try to request again and I will accept you

 

[Treesh1994]

try to request again and I will accept you

You should be able to edit now

 

[skillilea]

Still locked out of the one sheet

 

[Treesh1994]

Still locked out of the one sheet

View attachment 105810

Sorry you should be good now. I changed you to an editor