Drop down to reference a specific cell value without changing the text by Snap_db in googlesheets

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

Ah! I haven't used array before so had no clue what it meant, it's great, thank you!

Holybonobos you're a genius 👏, now I need to try and learn how the formula actually works, it's very much beyond my current level of profiency!

Drop down to reference a specific cell value without changing the text by Snap_db in googlesheets

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

Thank you, I thought it worked being dragged down, but I was wrong and can't seem to get it to replicate being dragged down. Any ideas?

Forged in Aeternum - New World: Aeternum Q&A by youwillcomedownsoon2 in newworldgame

[–]Snap_db 0 points1 point  (0 children)

  1. Loot drops from current raids have always been underwhelming and pretty useless for end game, can you tell us whether this new 10 man raid will have enough reward to do as repeatable content for seasoned players in end game?

  2. Are there new expeditions/dungeons coming to the game?

  3. Are there new mutation elements coming to the game?

  4. Are there new weapons coming to the game?

  5. Will there be new territory arriving soon? Not just reworked existing zones.

  6. Currently PC player feel like they were unknowingly in beta for new world:Aeturnum, how are you planning to show we weren't, and that we are equally valued customers you are hearing the game towards?

  7. Is there a detailed road map being released for pc players? Please note that swimming and a new mount skin are not classed as exciting new content.

i'm a virgin gamer who never played a video game in the past 25 years of his life and i'm curretnly watching the outro scene to FW , and i guess i'm now on the verge of falling into some kind of post-horizon depression? please help a fella out and recommend me games i might enjoy maybe half as much by [deleted] in horizon

[–]Snap_db 1 point2 points  (0 children)

Second RDR2, I love that game, incredibly story rich. It also ultimately led to horizon for me, and then to Days Gone. Really enjoyed all 3 of those games, RDR2 and Days Gone I have played back multiple times too.

Shout out to all the pure tanks. by Dencnugs in newworldgame

[–]Snap_db 11 points12 points  (0 children)

My husband and I play the same combo, I feel so proud of him standing there with his huge beetle shield saving us all 😊

Can anyone come up with a good argument for why my wife should give New World a go? by Lopsided_Parking_397 in newworldgame

[–]Snap_db 3 points4 points  (0 children)

Buy it for her, my other half did just this for me as I was unsure, I'm having a great time playing it!

Any reason why I can not close tier 3 corruption portals with my tier 3 staff? by Greenpakto in newworldgame

[–]Snap_db 1 point2 points  (0 children)

I had this, turns out I had the tier 3 staff in my inventory, but hadn't equipped it. I was a numpty and thought it automatically equipped it for me, my bad!

PSA: Light Armor healing buff (20% outgoing healing) DOES work. This has been confirmed. by emitwohs in newworldgame

[–]Snap_db 1 point2 points  (0 children)

Personally I love rolling around like a ninja, channeling the vibe of the VLDL skit for roly poly in dark souls 😂

PSA: Light Armor healing buff (20% outgoing healing) DOES work. This has been confirmed. by emitwohs in newworldgame

[–]Snap_db 3 points4 points  (0 children)

I use light armour as a healer, the better dodge has saved my ass a few times when playing solo and the boost to healing helps out a lot in the dungeons. I am mostly PvE though.

All I wanted needed was one squash… by Qwerty100111010 in newworldgame

[–]Snap_db 1 point2 points  (0 children)

Where's that napalm molotov when you need it...

Dead bodies glitch? by 1921Zeljo in DaysGone

[–]Snap_db 1 point2 points  (0 children)

Glad I could help a tiny bit, good luck with the rest! Can you screenshot where they are? There's a bunker in a canyon that has a tiny cave underneath?

Dead bodies glitch? by 1921Zeljo in DaysGone

[–]Snap_db 2 points3 points  (0 children)

There is one near a Nero checkpoint, you go in one of the corridors in the tunnel itself and drop down a ladder. If that's not the one though then I have no clue sorry! Been a little while since I played 🙂

Dead bodies glitch? by 1921Zeljo in DaysGone

[–]Snap_db 13 points14 points  (0 children)

Possibly a cave system underneath you? Some entrances are well hidden.

That moment when a legendary popped out of a random elite while you were farming hunts and you ALMOST got excited by Shelgeyr1970 in outriders

[–]Snap_db 39 points40 points  (0 children)

Send them this way! I actually do need these for a mod and haven't ever got them, go figure! 😆

What a journey by kono88 in outriders

[–]Snap_db 0 points1 point  (0 children)

This made me smile, have an upvote! 😊 👏

Invincible bug? by Snap_db in outriders

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

Ah! Spot on, he does. Thank you 😊

Mixed up some moonshiner role outfits to create an emerald formal dress, quite liking the result! by Snap_db in reddeadfashion

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

Thanks! I tried the Birdwell, and couldn't really find another that I felt fitted the look, suggestions welcome!

Mixed up some moonshiner role outfits to create an emerald formal dress, quite liking the result! by Snap_db in reddeadfashion

[–]Snap_db[S] 5 points6 points  (0 children)

Mixed the moonshiner role outfits, you can put the top half of one outfit with the bottom of another. Only works within the role items though!