B
B. B
Guest
B. B Asks: In google sheets is it possible create/embed a dropdown fillable table?
What I am trying to do is have a cell be the sum of a set of values that are from a table, and for the values of this table to be easily accessible/changeable from the near the cell. The issue is that I am using a premade google sheet that I cannot (and don't want to) change the formatting on.
I was wondering if it was possible to embed a table within a cell or a nearby cell and have that cell display a sum. I was thinking similar to the dropdown menu where (if it is possible) to create a dropdown editable table.
I don't have any experience with sheets or excel unfortunately so ideas are all I have. I know the summation is easy, I'm just wondering if its possible to have it easily accessible without changing the formatting.
Image 1: Current Formatting for Context
So the tan miscellaneous cells display the sum of a simple table (Image 2):
For further context this is a sheet that a friend made for our tabletop game where he made a single miscellaneous cell for a bunch of bonuses. Basically what I'm trying to do is separate the bonuses back out and have their sum in the box. Also he will not work on the sheet anymore.
Here is a view only version of the sheet, feel free to make a copy and try things: Current Personal Version of the Sheet
Edit: The misc boxes I'm specifically talking about are L112-L167 and AQ112-AQ167.
What I am trying to do is have a cell be the sum of a set of values that are from a table, and for the values of this table to be easily accessible/changeable from the near the cell. The issue is that I am using a premade google sheet that I cannot (and don't want to) change the formatting on.
I was wondering if it was possible to embed a table within a cell or a nearby cell and have that cell display a sum. I was thinking similar to the dropdown menu where (if it is possible) to create a dropdown editable table.
I don't have any experience with sheets or excel unfortunately so ideas are all I have. I know the summation is easy, I'm just wondering if its possible to have it easily accessible without changing the formatting.
Image 1: Current Formatting for Context
So the tan miscellaneous cells display the sum of a simple table (Image 2):
For further context this is a sheet that a friend made for our tabletop game where he made a single miscellaneous cell for a bunch of bonuses. Basically what I'm trying to do is separate the bonuses back out and have their sum in the box. Also he will not work on the sheet anymore.
Here is a view only version of the sheet, feel free to make a copy and try things: Current Personal Version of the Sheet
Edit: The misc boxes I'm specifically talking about are L112-L167 and AQ112-AQ167.
SolveForum.com may not be responsible for the answers or solutions given to any question asked by the users. All Answers or responses are user generated answers and we do not have proof of its validity or correctness. Please vote for the answer that helped you in order to help others find out which is the most helpful answer. Questions labeled as solved may be solved or may not be solved depending on the type of question and the date posted for some posts may be scheduled to be deleted periodically. Do not hesitate to share your thoughts here to help others.