Forum Discussion
JWS7
Aug 23, 2022Copper Contributor
Formula Help Drop Down List Populate Totals
This is for construction and populating the total tonnage per the Square Yardage quantity. It starts with the Square Footage then automatically populates Square Yardage, which is what all of this criteria is based on. The criteria are Material & Thickness. The answer to this scenario is 253 Tons, but unsure of the formula to auto-populate 253 tons under the "TONS" box? I would like to be able to choose from the 4 different types of material, and 16 different types of thickness to get the correct corresponding tonnage that meets the selected criteria. Can anyone please help?
https://lakeridgepavingcompany-my.sharepoint.com/:x:/g/personal/jsprouse_lakepav_com/EfZ1HpKggkpJlAG9XzIjwEoB5ILVdemUzq40sw9pUPvLow?e=6baxAP
2 Replies
- JWS7Copper ContributorThank you very much!