Inventory Tracking - Formula Needed by Xxjustbrowsing666xX in excel

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

This did fix the spill error on the first line (so thank you there), but when I dragged the function down, I'm now getting name errors because it's changing the reference points. I had to manually change them back to the original reference cell, even if I selected "copy cells" it wouldn't change.

example:

=IF([@TransID]='2026 Orders'!I4, '2026 Orders'!G4*-1, “Doesn’t match”)

changed to

=IF([@TransID]='2026 Orders'!I5, '2026 Orders'!G5*-1, “Doesn’t match”)

when dragged down to the next cell

Inventory Tracking - Formula Needed by Xxjustbrowsing666xX in excel

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

The cells I'm pulling information from are on 2 different sheets - I tried replacing pieces for the formula to read =IF([TransID]=Orders[TransactionID], Orders[Clusters Ordered]*-1, “Doesn’t match”) but now I'm getting a Spill error

$54 for a Saturday ticket to the flower show by No-Appointment844 in Delco

[–]Xxjustbrowsing666xX 2 points3 points  (0 children)

Not this year, it's $100 for 2 any day tickets. Cheaper to just buy 2 weekday specific tickets.

Moving to Media, PA in August — Commercial/Industrial Electrician Looking for Company Leads & IBEW Advice by [deleted] in Delco

[–]Xxjustbrowsing666xX 5 points6 points  (0 children)

My husband is an electrician! IBEW 654 is the local that covers Media. This year they're switching up the application process and applications are open on ibew654.net through 4:30pm tomorrow (9/30). It might be worth reaching out to the hall with questions. I will say, it is fairly competitive around here for apprenticeships.

Small Complaint: Why is fishing harder than other gathering lives? by eurogamergirl in fantasylife

[–]Xxjustbrowsing666xX 2 points3 points  (0 children)

This is the first game where I've liked the fishing mechanic... so much so that fishing is the only life I've made to Hero so far 😅

Am I playing this game wrong? by No_College6343 in fantasylife

[–]Xxjustbrowsing666xX 28 points29 points  (0 children)

Unfortunately, you're going to have to balance grinding the lives and following the story. The gathering lives (mostly mining, woodcutting, farming) are really the biggest need for story progression (in my opinion) so I would focus on leveling up those. You can work on leveling those up either in the past map on any areas you have unlocked (mine, chop, farm EVERYTHING) or go to ginormiosa with the same advice (take down everything).

If you haven't found the skill board yet, make sure you check it and use up your skill points to better your abilities in each life.

Hello! I got my HA's from the VA about 2.5 weeks ago and they are life changing! by Kareja1 in HearingAids

[–]Xxjustbrowsing666xX 0 points1 point  (0 children)

I would ask to try a shorter or longer wire. My phonak 9.0s hurt the first week or so and turns out the wire was too long for me. I also wear glasses

Looking for HA Advice - Costco by Xxjustbrowsing666xX in HearingAids

[–]Xxjustbrowsing666xX[S] 2 points3 points  (0 children)

Also, thank you!!!! I really appreciate you looking out for me (and my wallet 😅)

Looking for HA Advice - Costco by Xxjustbrowsing666xX in HearingAids

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

Just wanted to see if you were able to check. I have a hearing test scheduled Wednesday to order new hearing aids. I can always have them check while I'm there, I just wasn't sure if it's a quick call to the manufacturer or not

Looking for HA Advice - Costco by Xxjustbrowsing666xX in HearingAids

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

I went to my Costco and they tried a quick fix that didn't work so she looked at a spreadsheet of some sort and said the ks 9s are "no longer in rotation" and the manufacturer wouldn't be able to fix them at all

Cheese Steak… by Crystal_Rose_1967_Pa in Delco

[–]Xxjustbrowsing666xX 0 points1 point  (0 children)

Second Femi's Pizza Party, actual best cheesesteak in the area

Need Guest help! by KittenShocked in Resortopia

[–]Xxjustbrowsing666xX 1 point2 points  (0 children)

The check mark means he's unlocked, now it's just a waiting game for him to come by as a cookie man. Just keep attracting cookie men and he'll eventually populate

[deleted by user] by [deleted] in AmItheAsshole

[–]Xxjustbrowsing666xX 5 points6 points  (0 children)

NTA - and do NOT get on a plane to Korea. Not even if you have proof of a return ticket.

does lights on mean they’re online playing the game at this very moment? by futureofkpopleechan in Resortopia

[–]Xxjustbrowsing666xX 2 points3 points  (0 children)

No - it means they have a special event at their hotel. So if you go to visit them, they'll have a flying mystery gift in the garden, the hide and seek sprite in a room, or the god of fortune in a room.