How to divide (any math operation) a regular number by number in a currency format?
mbsamuel6
✭✭✭✭
Hi,
I have one column written in a currency format. Lets call this column A.
Another column written in a regular number format B.
When I try to create a column formula in Column C like: Column A/ Column B, I get an error called invalid operation.
As you can see in the screenshot below, that formula I have in the Test column errors into "invalid operation".
The "Terms in Months of Contract" column, I tried converting that into both a currency and decimals, but since its a formula column, it looks like it won't let me.
Any ideas to get around this?
Screenshot for help:
Tags:
Answers

I said any math operation, but it only gives me the error for divide and multiply

I figured it out. You'll have to use the value function.
=value(column a/ column b)
Help Article Resources
Categories
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!