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.



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!