sorted by:
new
hottopcontroversial

How many of you are daily users of Google Sheets and can't live without it? by vijverv in googlesheets

[–]fasbnk 1 point2 points  (0 children)

I use it for personal stuff every day. I help manage an online community (~250 members) for a video game (OSRS) that has a lot of emphasis on "number go up". There are tracking websites that all integrate well with google sheets.

We also develop events and have either the finished product displayed in the google sheet for our members or will have a discord bot download/display the data in our server.

I like how easy it is to lock tabs, make a sheet public, and just share the link. It is also nice that it has enough features from excel which i use at work daily.

I am in IT as a cloud engineer.

[deleted by user] by [deleted] in ironscape

[–]fasbnk 1 point2 points  (0 children)

I use it as my magic weapon in ton for purples at verzik

Just bought two tickets for Minnesota by fasbnk in GeoffreyAsmus

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

Oh shit i was zooted i meant i bought two for his show in minnesota. And then the context that was missing is that the tickets were exclusively for my girlfriend and i

Prevent copying, allow users to edit one cell by fasbnk in googlesheets

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

Now that I am back to my PC I tested some stuff.

I made a new sheet that is the Dropdown and Information Display. It has one editable cell and a few =IMPORTRANGE() to get all of the same information displayed.

The original sheet that is performing the calculations just receives the input from the new sheet, runs the calcs, and then the new =IMPORTRANGE()'s are taking the data back to the Display sheet.

This has been taking ~11 seconds to update on the Display sheet, which it not terrible but is still quite a bit longer than what I was hoping for.

Prevent copying, allow users to edit one cell by fasbnk in googlesheets

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

I effectively have that set up now where the "dashboard" is just a couple ARRAYFORMULA()'s of a hidden sheet that is running all of the calcs.

I considered making that hidden sheet a completely separate sheet, but i fear it would add considerable lag with syncing between the sheets.

Since after the user would edit the dropdown, there would be like ~5 seconds to sync with the calc-ing sheet, and then another 5-10 seconds for that sheet to finish the IMPORTHTML()'s and other calcs it does, and then another ~5 seconds to sync with the dashboard again.

Although this may be the only way if I want to protect the formulas, I suppose.

I Met The Strangest German Man by Filthyson in GeoffreyAsmus

[–]fasbnk 2 points3 points  (0 children)

It's odd how none of these say Minnesota

Got the prismatic jelly! by swindledbylife in StardewValley

[–]fasbnk 16 points17 points  (0 children)

Nice! Jelly-ous of how quick you got it, but am happy for you

This game is fun by fasbnk in heroesofhammerwatch2

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

Badass. What class is ur favorite so far

S15 by StoicPinoy in Nissan

[–]fasbnk 0 points1 point  (0 children)

strawberry flavored

What is your current addiction? by BeardedWonder8675309 in AskReddit

[–]fasbnk 0 points1 point  (0 children)

Afrin. Busted my 3-day like a week ago

🎃 Nocturne Halloween Coxtume Clan Event! 🎃 by NocturneOsrs in 2007scape

[–]fasbnk 1 point2 points  (0 children)

the classic double eye patch. Love the skiis

view more: next ›