Need help for a formula

kroux

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 ?

Andrée Starå

Hi,

Yes, it is.

Try this.

=IF(ISBLANK([ACTUAL COST]@row); ""; [BUDGET COST]@row - [ACTUAL COST]@row)   

The same version but with the below changes for your and others convenience.  

=IF(ISBLANK([ACTUAL COST]@row), "", [BUDGET COST]@row - [ACTUAL COST]@row)

Depending on your country you’ll need to exchange the comma to a period and the semi-colon to a comma.

Did it work?

Happy New Year & have a fantastic weekend!

Best,

Andrée Starå

Workflow Consultant @ Get Done Consulting