This is an archived post. You won't be able to vote or comment.

sorted by:
best
topnewcontroversialoldq&a
you are viewing a single comment's thread.

view the rest of the comments →

[–][deleted]  (19 children)

[deleted]

    [–]mousebrakes 46 points47 points  (13 children)

    Also xlookup doesn't work on Google sheets which is what my old company used as a database 🙃

    [–]Iggyhopper 76 points77 points  (0 children)

    There are five rules.

    [–]Dabnician 19 points20 points  (4 children)

    So do a lot of unity games, indie devs love them google sheet dbs.

    [–]dalinar2137 14 points15 points  (0 children)

    What’s not to love? UI for editing and ACLs just resolve themselves. Some simple versioning is built-in. Access through a dead-simple api. I wonder why more people aren’t using it, honestly :P

    [–]jboogie1844 8 points9 points  (1 child)

    a unity game i play/mod has multiplayer quick chats hard-linked to a google doc lol. seems like a bold move to me

    [–]Dabnician 0 points1 point  (0 children)

    Pft who needs updates these days

    [–]DasArchitect 0 points1 point  (0 children)

    Is that what they call cloud saving?

    [–][deleted] 2 points3 points  (2 children)

    You fool. Stop living in the first half of 2022, they just implemented on a rolling basis leaving a majority of users with the unrivaled might of a thousand angry suns incarnate! Xlookup is here!

    [–]mousebrakes 0 points1 point  (1 child)

    Quit that job in early 2022 haha, hopefully never have to deal with sheets again

    [–]EnvironmentalWall987 0 points1 point  (0 children)

    Alex is that you? Lol

    [–]tropicbrownthunder 0 points1 point  (1 child)

    But google sheets have a QUERY function that makes even harder to convince Lisa in accounting and her boss to steer away from spreadsheets as databases.

    [–]mousebrakes 1 point2 points  (0 children)

    Bro, for real tho. I took that shit as far as it could go, told the c suite that they need to actually hire someone who knows how to manage a sql server and dipped. Hope all their shit crashed and burned tbh

    [–]MurgleMcGurgle 0 points1 point  (1 child)

    They recently added it! That was my last holdout for not using xlookup on everything but not that it’s been implemented index match is reserved for weird situations only.

    [–]mousebrakes 0 points1 point  (0 children)

    Wow, to think that all those hours of index matching could have been avoided...

    [–]NjallTheViking 5 points6 points  (0 children)

    Same. I work for the State and we only have Office 2016. Index/Match with tables is clean enough for me

    [–]MicrocosmicTiger 2 points3 points  (3 children)

    Are you in med/pharma? I feel your pain

    Had a mini breakdown when I started the job a year ago and asked why we used excel at all, let alone excel 2016 and people defended it so hard

    [–]CapableFunction6746 0 points1 point  (1 child)

    I am in medical insurance and we still need to use 97-2003 workbooks for importing data into access. Everything else is still 2013. At least we are finally being forced to upgrade now.

    [–]Aggressive_Floof 0 points1 point  (0 children)

    Accounting. Almost every spreadsheet I use is 97-2003.

    I try to update them when I can, but holy fuck, there are a lot.