Only perform calculation if cell is not blank

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

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:
· Share on FacebookShare on Twitter

Comments

  • Mike Wilday
    Mike Wilday Community Champion

    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.Β 

    · Share on FacebookShare on Twitter

Help Article Resources

Create and edit formulas in Smartsheet

Formula combinations for cross sheet references

Smartsheet functions list

Categories

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!