Drop down selection adds value from one text box to another

Explorer ,
May 04, 2022 May 04, 2022

Copy link to clipboard


I apologize for my horrible description. I will share the document that I am trying to create. So I am making a document that handles two types of calculations. The data that is needed to calculate both calculations have some overlap which is what I would like to try to extract to minimize double entry. 

Our technicians sketch out floorplans and most floorplans are not four walls. So our guys have to use boxes, rectangles and/or triangles and from there calculate out cubic and square footage. Multiple boxes, rectangles & triangles can make up one room so I was thinking of using a dropdown box that can have a number (1-15). 

For example the first 3 rows are all inside Room 1. So, the dropdown at the end of each row is showing "1" (with the value of 1) - Is there a way to have a running tally from the square feet row total entered into a text box named "Room 1 SF" based on the Dropdown selection that has "1" choosen. So those 3 rows with the Dropdown "1" - "room1SF" will total up those 3 rows. And if I changed one of the Dropdowns to "2" that square footage total will move to "room2SF". 

Again, I'm sorry if this is all over the place/confusing. I will include the PDF that might do a better job of describing what I mean. I appreciate all of your help & advice.








Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
no replies

Have something to add?

Join the conversation