Subtracting two cells and getting Invalid Operation error

Michelle Basson

Good day,

I am struggling with a formula that keeps giving me an Invalid Operation error.

Am I doing something wrong?

Regards

M

Andrée Starå

Hi @Michelle B

How are the values for the two columns added to the sheet?

I hope that helps!

Be safe and have a fantastic week!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!

Michelle Basson

Hi Andre,

Apologies for the delayed response.

The values for the 2 columns are generated by formula.

Total Stock Non-Serialized formula

Total Non-SN Stock assigned to warehouse formula

The Total non-Serialized stock on hand is then just a standard deduction (picture as in original post)

What am I doing wrong?

Regards

Michelle

David Joyeuse

Hi @Michelle B

You're working on text cells, so obviously, you cannot substact.

Do that instead in your formula:

=IFERROR(VALUE([Total Stock Non-Serialized]@row)-VALUE([Total Non-SN Stock assigned to warehouse),"")

The IFERROR is here in case one of your formula returns an error. But otherwise, you're good to go.

One tip on smartsheet:

If Smartsheet sees a number, it is displayed on the right part of the cell. Otherwise, it's in the middle of the cell. So if there's a "2" in the middle of the cell, Smartsheet sees that as a character, not a number. And thus cannot do any math on it.

So, as a whole, try to always use VALUE([Cell]) when doing maths. just in case :)

Andrée Starå

@Michelle B

No worries!

I saw that David answered already!

Let me know if I can help with anything else!

Best,

Andrée