i need help creating a formula

josmith

I have this row with dropdown options that contain the Quantity and the Price. I want the formula at the end to generate the Total $ for that row so the customer knows the total for the items they want. How do I do this?

SteyJ

=VALUE(MID([QTY + SIZE]@row, FIND("$", [QTY + SIZE]@row) + 1, 5)) + 
VALUE(MID([QTY + SIZE (2)]@row, FIND("$", [QTY + SIZE]@row) + 1, 5))

If you need to get the total of all of the rows, you can also do this:

=SUM([LINE TOTAL]:[LINE TOTAL])

josmith

I tried to enter this and it wasn't working. I appreciate the Help though!

SteyJ

https://community.smartsheet.com/discussion/comment/421896#Comment_421896

You will need to match up the appropriate column names. It appears that the sheet you screenshotted was made in a program outside of Smartsheet. If possible, please provide a screenshot with PII redacted of the sheet you are working on and I will be able to help further

josmith

Yes it is Google Sheets.