Formula for IfBlank

Options

I'm still stuck on this. I know it's got to be something so simple that I'm missing. But you can see that the blank rows are not calculating correctly.

Thank you!

Answers

  • David Joyeuse
    David Joyeuse ✭✭✭✭✭
    Options

    Hi @kimberlee.adam89166

    If I understand your formula right, it should be like this:

    =IF(OR(ISBLANK([Actual - Cap]@row), ISBLANK([Actual Burndown]@row)),[Forecast - Cap]@row, [Actual Burndown]@row - [Actual - Cap]@row)

    If either Actual Burndown or Actual - Cap are blanked, then display Forecast - Cap. Otherwise do Actual Burndown - Actual Cap.

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!