Need help for a formula

edited 12/09/19 in Formulas and Functions

Hello everyone, I am pretty new to smartsheet so thanks in advance for your help. I am creating budget template sheet, and I have a BUDGET COST column, an ACTUAL COST column and a DIFFERENCE column. When my actual cost column is blank, the difference automatically calculated like if it's at 0.

Let's say I have an estimated cost of 500.00$, and my actual cost is unknown at the moment, so I leave the cell blank. In the difference column, it shows 500.00$. But the reality is it shouldn't be calculated because we are not in the positive or negative yet, we don't know.

Is there any way I can add a IF formula to my =[Budget Cost]1-[Actual Cost]1 so it's only calculating if the actual cost is not blank ?



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!