Math Formula Error
Hi, I am trying to create a formula to divide the Impressions column by 1,000 then multiply it by the Total Price column. This is the formula I am using "=VALUE(Impressions@row / 1000) * VALUE([Total Price]@row)". Not sure what's going wrong. Total price is a column formula that auto fills each cell with the $5.95 price and Impressions is a column formula with a long if/then statement based off of the Confirmed Bag Qty column.
Answers

Are you getting an error or an incorrect result?

I'm getting back an #INVALID OPERATION

What are the formulas you are using to populate the Price and Impressions?

I got it figured out. I had to use the RIGHT([Total Price]@row,4) to remove the dollar sign. I'm rebuilding to have noncurrency columns for formulas and display columns that use the currency signs. Thanks though!

That's pretty much where I was going with my last question. Glad you got it sorted. 👍️
Help Article Resources
Categories
 All Categories
 14 Welcome to the Community
 Smartsheet Customer Resources
 62.3K Get Help
 364 Global Discussions
 199 Industry Talk
 428 Announcements
 4.4K Ideas & Feature Requests
 136 Brandfolder
 127 Just for fun
 128 Community Job Board
 444 Show & Tell
 28 Member Spotlight
 1 SmartStories
 283 Events
 35 Webinars
 7.3K Forum Archives
Check out the Formula Handbook template!