Forecast using if function

Tim Kuykendall
edited 12/09/19 in Formulas and Functions

I am working on a budget tracking sheet where I have a forecast column.  The forecast column is dependent on if there is a value in an estimated cost column or actual cost column. 

If there is no value in the actual cost column, then the forecast column is equal to the value in the estimated cost column.  If value exists in the actual cost column, then the forecast cost is equal to the actual cost.

I'm not sure how to set-up the formula.

 

forecast smartsheet formula.JPG

Comments

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!