The IMPORTRANGE function doesn't copy formatting, so the cells in the "Languages" section mark the languages with an "x" and uses Conditional Formatting to convert any non-empty cell to a grey bar because that's prettier and stuff. This formatting was inspired by a post on /r/DnDBehindTheScreen, which unfortunately I can't find again, but I think it looks nice.
#Google sheets reference tracker update#
So when I update a cell on the DM Reference sheet that this links to, those same cells update on the Player View. Basically this just uses the "Share" URL to import any arbitrarily large range of cells from another spreadsheet, live and in real-time. The fundamental mechanic behind everything on this sheet is the IMPORTRANGE function.If you will kindly click here, I'll walk you through what's going on, section-by-section. The only tab that should be visible pulls all of its data from other tabs within the same spreadsheet, which helps prevent linking back to my "DM Only" spreadsheet and spoilers, whether unintentional or not. That led me to create this Player's Reference Sheet! Since I was tracking all this information anyway, I thought it would be simple to share a version of it with them, but I ran into two limitations: I didn't want to simply share my whole spreadsheet with them (for obvious reasons), and I didn't want to have to constantly check to make sure a separate "Players Only" sheet was still up-to-date. Well, my players were asking every week for an update on their XP for leveling up, or what the specific effects were for the weather table I was rolling on, or other quick-reference stats. I'm proud of the work I put into it, but that on its own probably isn't enough for a post here, because it's nothing you haven't already either seen or put together for yourself.
#Google sheets reference tracker full#
Months later, that's evolved into a multi-tabbed Google spreadsheet full of player information, an in-game "day planner" of sorts, collections of random tables I've found on this subreddit, et cetera. Since this was (and is - we're still going) my first experience as a DM, I was looking for a simple and streamlined way to keep track of all the various things that come into play. Hey, all! As is tradition, if you are in a campaign with Gwenneviere Walker, Nataly Dewpearl, and Geoff Pron'Ouncedgif, stop reading!Įarlier this summer I dipped my toe in the water of D&D the same way hundreds of others did: I got a group of friends together and started playing through the Lost Mines of Phandelver module. Combat areas for every conceivable encounter. Collection of Podcasts, Vidcasts, and other D&D Multimedia for your consumption. Worldbuilding, Storybuilding, DM Discussion. The DM Help Multireddit Check out our wiki! Message the Moderators
We welcome DMing questions, DMing advice or tools to help DMs old and new. The aim of this subreddit is to serve as a platform for learning to DM.
Before Submitting a Question, Please Check our Rules Remove All Need Advice See Advice Only See Resources Only Join the Discord
0 kommentar(er)
