Do Not Apply Formula IF Field Is Blank

saraha83081
saraha83081 ✭✭✭
edited 12/09/19 in Formulas and Functions

I am trying to calculate a variance by subtracting two columns but only if one of them is not blank.  I'm having trouble getting the ISBLANK condition to work.

My current formula is  =[Budgeted Total]4 - [Amount Spent]4 but I only want to apply that formula if Amount Spent is not blank.

Any suggestions would be very much appreciated!

 

Sample.png

Comments

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!