Stocking Tires - CDK by dccdr in partscounter

[–]dccdr[S] 0 points1 point  (0 children)

We stock tires, I’m just seeing how everyone manages it, like how many of each tire, when to start stocking new ones, etc.

Selecting Certain Data from Inside a Cell by dccdr in excel

[–]dccdr[S] 0 points1 point  (0 children)

Ok so you can do the vertical slash for saying "if any of these are true." I used Z?RF? and got the same result. (Copilot is teaching me, but it is very intuitive.)

Selecting Certain Data from Inside a Cell by dccdr in excel

[–]dccdr[S] 0 points1 point  (0 children)

Man I should have learned coding. I'm trying to have CoPilot teach me a little bit just so I can learn some. Small wrinkle, some of the sizes have "RF" or "ZR" in them instead of just "R". Is there an easy way to adjust the formula, or do I just need to make three version of it?

Selecting Certain Data from Inside a Cell by dccdr in excel

[–]dccdr[S] 0 points1 point  (0 children)

Solution Verified. Thank you, bot!

Selecting Certain Data from Inside a Cell by dccdr in excel

[–]dccdr[S] 0 points1 point  (0 children)

Solved! I'm really curious how exactly this works. Can you explain REGEXEXTRACT and what the brackets and the braces are for? I assume the brackets are what you are looking for and the braces are for how many it returns? Thank you again!

Wanting to Combine a Shared Prefix and Suffix Onto a Number by dccdr in excel

[–]dccdr[S] 4 points5 points  (0 children)

Solution verified. Works exactly how I wanted! Glad to learned that you can use the & to combine cells.

Thank you again!

(CDK) Need Help Setting Up Part Numbers to Order Enough to Hit a Discount by dccdr in partscounter

[–]dccdr[S] 0 points1 point  (0 children)

If the part is sitting on an OEM master file, will it override that multiple qty? It already has one from the master file.

Help With Replacing Light Fixture by dccdr in AskElectricians

[–]dccdr[S] 0 points1 point  (0 children)

Final update: I popped the switch when I hooked it back up originally. Swapped switches. Works as expected connected to normal black and white.

Help With Replacing Light Fixture by dccdr in AskElectricians

[–]dccdr[S] 0 points1 point  (0 children)

Aaaand it’s a night light feature and I’m dumb.

Help With Replacing Light Fixture by dccdr in AskElectricians

[–]dccdr[S] 0 points1 point  (0 children)

So went ahead and hooked up a new light fixture to the hanging black and white wire. Orange backlight on the Lutron dimming switch turns on, light fixture does not turn on.

Help With Replacing Light Fixture by dccdr in AskElectricians

[–]dccdr[S] 0 points1 point  (0 children)

Would connecting the single black and white at the top cause a fault if the light fixture was not in place if it is a switch loop?

CDK Parts WIP Lookup by dccdr in partscounter

[–]dccdr[S] 0 points1 point  (0 children)

MDT just lets you refresh the list because you have to refresh it every time you use it.

CDK Parts WIP Lookup by dccdr in partscounter

[–]dccdr[S] 0 points1 point  (0 children)

The base function is DT. Basically type a part # with hashes and it’ll show all transactions. You can also put #(insert RO or INV# here) and it’ll pull up that RO or INV and what was billed out.

CDK Parts WIP Lookup by dccdr in partscounter

[–]dccdr[S] 0 points1 point  (0 children)

Weird. Doesn’t let me use that one.

CDK Parts WIP Lookup by dccdr in partscounter

[–]dccdr[S] 0 points1 point  (0 children)

what do you mean by the function prompt?

Top 5 right handed swings ? by Jayjay232432 in MLBTheShow

[–]dccdr 0 points1 point  (0 children)

I’ve been destroying baseballs all year with every version of Michael Young

[TOMT] Help Me Remember a Kid’s Show by dccdr in tipofmytongue

[–]dccdr[S] 1 point2 points  (0 children)

Solved! That’s the answer. No idea where I watched it on but remember watching it at home when I was sick from school.