To create a more efficient process in pricing materials I’m working through different ideas and it’s just becoming messy. I’m trying to figure out if a formula would provide the best option or possibly a drop-down based on conditions.
Example : I’d post a picture of my base, but it’s not quite finished, which is why I’m reaching out.
If I need to purchase paint and paint supplies to bid materials needed correctly I’m trying to find the best option to fill in QTY TO ORDER
gallon of paint is $30.00. Coverage area is 200 SF
paintbrush is $2.00 needs replaced after 100 SF
All materialS, coverage/price breakdown, is listed in a materials table.
In the Bidding table I’d like to:
|COVERAGE AREA||MATERIAL||QTY TO ORDER||PRICE|
|Manual input SF, LF, tile count, etc.||Manual input based on linked field||based on the details from the materials table, this info is auto calculated||Calculated by formula|
|EXAMPLE OF WHAT I’M TRYING TO ACCOMPLISH|
|400 SF||PAINT||2 GALLONS||$60.00|