Subtracting with a Formula in Cell

Hi there -


I am trying to do simple subtraction within my sheet.

=Budget@row - [Estimated OSC]@row - [Expenses]@row


This formula normally functions correctly; however, I recently changed the Budget column to an "IF" formula, and now I am receiving an #INVALID OPERATION error. I am not sure how to structure the subtraction formula to include a cell that has a formula.


Thanks!

Best Answer

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!