How do I remove the leading "$" of a Price column so I can then use SUM

Hi all,

I am a complete novice here. I have imported an XLS spreadsheet and one of the columns has "Sales Price (Converted)"

It has a leading "$" that I am trying to remove to sum the prices.

Can anyone help me with a formula to remove that leading "$" please?

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!