Sum difference between two cells only if one cell is not blank
Hello. I am trying to write a formula that calculates the difference between the "Pitch $" and the "Closed Deal $" only when the "Closed Deal $" cell has a value (aka I don't want inaccurate values reflected in the "Pitched to Closed $ Difference" cell because it's considering a blank cell to be $0). Help?
Best Answer

will this work?
=IF([Closed Deal $]@row="","",[Closed Deal $]@row[Pitch $])
Answers

will this work?
=IF([Closed Deal $]@row="","",[Closed Deal $]@row[Pitch $])

Thank you @Michael Coulson  that seems to work! I found the ISBLANK works as well. Formula rookie over here.
Help Article Resources
Categories
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!