@ariestav So, in your example, I’m not quite sure how I could set that up. Are you pointing to specific comps within a project, or different projects? I’m trying to utilize different pieces of information within the same project, but that may just not be possible in a clean, easy way for outsiders to easily update information I suppose.
I’ll give you a working idea of my particular implementation:
I currently have a “scoring box” in the top left. It lists the team name, current score, the inning, what bases are loaded (which is being driven by manual checkboxes) and how many outs there are (which is also being driven manually by checkboxes)
Then in the top right I have a “Due Up” box which simply lists the player and their respective number.
I also have another info box that swaps spots with the “Due Up” box I call an “Info Box” which houses the current batter along with the next 3 batters and the numbers for ‘Runs’, ‘Homeruns’ and ‘Errors’.
Right now I have a controller setup using mostly if/else statements and dropdown menus to control what boxes are being shown.
So, I guess my question is, is there a better way to do this? I would sort of like to keep this within Google sheets just because it’s an easy to understand way for the team to update the numbers, but if there’s a better way, I’m all for it.
Thanks for your help thus far, you’re very kind and I appreciate that.