Only perform calculation if cell is not blank

Options

I have search the community and tried some stuff but have had no luck, pretty sure it is an easy fix. I have "todays" percentage cell subtracted from the previous day.  however it is also calculating " tomorrows" date even though there is no data in the field.  How can i have it calculate only when data is in the cell.

 

propane screen shot.JPG

Tags:

Comments

  • Mike Wilday
    Mike Wilday ✭✭✭✭✭✭
    Options

    What formula are you using? 

    You can integrate it into this IF statement... 

    IF(ISBLANK(Percentage@row), "", INSERT YOUR FORMULA HERE)

    This will return a blank cell if there is no percentage data. 

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!