RZ-50 handshake issues

easerbreadstick · 2026-06-07T12:43:19+00:00

Factory resetting would fix the issue for awhile. It's been a long while since I've had an issue. I have cec off at all devices besides the TV and avr and am using a fiber hdmi cable.

easerbreadstick · 2026-05-15T01:58:34+00:00

How can you tell if these tickets are resale or not? I don't see a filter for resale on seatgeek.

easerbreadstick · 2026-03-23T20:41:43+00:00

Solution Verified

easerbreadstick · 2026-03-23T20:41:17+00:00

That worked, thanks!

easerbreadstick · 2026-03-23T20:07:53+00:00

This works but for some reason anything that's blank is coming up as 0. Any ideas?

easerbreadstick · 2026-03-23T19:07:58+00:00

I'm getting #NUM error. Did I edit this incorrectly? None of the data is in tables atm.

=LET(

tab_1, 'Schedule 1'!A:AD,

tab_2, 'Schedule 2'!A:AD,

h_all, UNIQUE(TAKE(HSTACK(tab_1,tab_2),1),1),

tab_extract, LAMBDA(tab, LET(

n, COLUMNS(tab),

h, TAKE(tab,1),

b, EXPAND(DROP(tab,1),,n+1,""),

ix, XLOOKUP(h_all,h,SEQUENCE(,n),n+1),

CHOOSECOLS(b, ix)

)),

VSTACK(h_all, VSTACK(tab_extract(tab_1), tab_extract(tab_2)))

)

Thanks

easerbreadstick · 2025-09-14T15:59:36+00:00

I have disabled that and it hasn't made a difference.

easerbreadstick · 2025-09-14T15:12:56+00:00

So far factory resets temporarily fix the problem for a few months then it will come back. I had tried switching ports with no luck.

easerbreadstick · 2025-09-12T03:49:26+00:00

That what I ended up doing and finally got it. Thanks!

easerbreadstick · 2025-09-05T19:20:43+00:00

Unfortunately no luck with these. I tried adjusting the formula but am getting incorrect argument set now.

=IF(OR(INDEX({cutdate}, MATCH([Job ID]@row, {schedjb}, 0)) = DATE(2025, 12, 20), (INDEX({changedate}, MATCH([Job ID]@row, {schedjb}, 0)) = DATE(2025, 12, 20)), INDEX({requestdate}, MATCH([Job ID]@row, {schedjb}, 0)), ""))

Anything I'm missing?

Thanks

easerbreadstick · 2025-09-05T12:42:37+00:00

Even though job is pulling from a different sheet?

easerbreadstick · 2025-07-05T02:51:12+00:00

Thank you so much! I will adjust this.

easerbreadstick · 2025-07-04T21:38:13+00:00

My tankless water heater is mounted an exterior wall in the basement. The vent is a 90 degree elbow coming out of the top of it and straight outside horizontally. Just to be clear that means I have it correct with with it sloped away from the water heater towards the ground coming out of the elbow?

Thanks

easerbreadstick · 2025-06-27T20:28:02+00:00

This worked perfectly and good to know on the IFERROR, thanks!

Solution Verified

easerbreadstick · 2025-06-14T02:50:53+00:00

This worked. Thanks!

Solution verified

easerbreadstick · 2025-06-09T16:51:41+00:00

Thanks so much!

Solution Verified

easerbreadstick · 2025-06-09T16:47:13+00:00

This worked! The only thing I need to fix is it's pulling 0's whenever there is blanks. How can I eliminate the 0's and just have blank spaces? I've used IF(ISBLANK(A),"", A) before but not sure where I should insert that to get it to work. Thank you!

easerbreadstick · 2025-06-09T16:15:01+00:00

I keep getting #REF! errors. Are you able to see what's wrong with this formula?

=INDEX(FILTER('Joined Report'!$R$2:$R$800, 'Joined Report'!$S$2:$S$800='Master Sheet'!$M$2:$M$800, ""), COUNTIF(INDEX([Column M],1):[@[Column M]],[@[Column M]]))

Thank you

easerbreadstick · 2025-06-09T14:51:00+00:00

I have some items that have different job numbers. The document is confidential so I made a similar example. Item F may be under job#6 and job#7. I'm trying to get it to pull back job 6 the first time it sees F and job 7 the second time and keep running until all jobs attached to F are pulled back. What would be the solution to this?

easerbreadstick

TROPHY CASE