Looking for some advice here.
I'm trying to convert more data collection over to the worksheets and keep it as automated as possible. What is the best workflow to add in pricing that can vary depending on the material used? Say for a graphic panel, I pull the geometry to get width + height, but the price will change if the panel is PVC or fabric or Plexi, etc. I have a record format set up so that I can describe the material in the worksheet, but is there a way to multiply the dimensions by the type of material being used?
Currently I have a manual entry on the record, also considered a different header line per material.. but that just adds a bunch of extra lines.