would like to add an IFERROR to a simple formula, can't seem to get it to work


I have a simple formula I am using in one of my sheets to calculate a percentage:

=[Training/90 day complete]@row / FDS@row

I would like to amend it so that if the cell in the Training/90day complete column is blank, to leave it blank rather than calculating it and returning 0%.

How would I do that?

Thanks in advance!




  • Dale Murphy
    Dale Murphy ✭✭✭✭✭✭

    @Emily Sanchez Here is what I would use:

    =IFERROR(IF(ISBLANK([Training/90day complete]@row), "", ([Training/90day complete]@row / FDS@row)), "")

    ISBLANK should catch the condition where Training/90day is blank

    IFERROR should catch the condition where FDS is blank.

    (seems to work in North America)


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!