Return the month of a closed item



I'm trying to create a formula for when a query is closed and the month is return in a separate column. I have managed to complete this for the month the query is opened as all items opened have such a date. However, if the query is not closed the cell is blank and I receive the following error message "#INVALID DATA TYPE"




  • Frank S.
    Frank S. ✭✭✭✭✭✭

    Greetings @Stephen Halsey,

    If you already have a formula that works, except when the reference cell is blank, you can add the following to the formula:

    =IFERROR((Your formula), "")

    This will leave the cell blank if the formula returns any errors.

    Frank Smith, PMP

    Assistant Director | IT Special Projects Mgr.

    Oregon Parks & Recreation Department

    If my response helps, please mark it as an accepted answer. 😎

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!