Order Form - Item Cost Total

Hello Smartsheets Community,

I have created a simple order form for our smaller customers to use to submit their orders. Based on the screen shot below, when a dealers chooses the 1961 Totes to order, the individual item numbers will be visible as check boxes. If a dealer clicks on an item number to order, it will open up an order qty field and a total field.

Does anyone know if there is a way to have the total field automatically populate based on the order qty inputted into that field? For example, if someone clicks on GRN_1961_01 and inputs an order qty of 3, and that item costs $1.00, then $3.00 will automatically populate into the total field? I hope that makes sense.

Any help or ideas would be greatly appreciated and looking forward to the responses.

Hope everyone is doing well and having a great week so far!


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!