Formula Error


I can't seem to know where the error on the formula is. Or am I just using the wrong one.

What I would like is that if there is not date on the Actual Completion Date, for it to be 0. If there is a Date, to enter the month number.

=IF(NOT(ISBLANK([Actual Completion Date]@row), "", IF(ISBLANK([Actual Completion Date], 0) @row), "", MONTH([Actual Completion Date]@row)))

Best Answer

  • KPH
    KPH ✭✭✭✭✭✭
    Answer ✓

    I think you may have over complicated it @dnavarrete

    Does this do what you want?

    =IF(ISBLANK([Actual Completion Date]@row), 0, MONTH([Actual Completion Date]@row))

    IF Actual Completion Date is blank it returns 0.

    If it it not blank it returns the month number from Actual Completion Date.


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!