How to divide (any math operation) a regular number by number in a currency format?


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:



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!