If Cell Blank Return "N/A"

Options

If Date of Calibration is blank, return N/A instead of DUE.

=IF([Calibration Due]@row - TODAY() > 90, "GOOD", IF([Calibration Due]@row - TODAY() > 30, "3 MONTHS", IF([Calibration Due]@row - TODAY() > 0, "1 MONTH", "DUE")))

Tags:

Best Answer

  • Anjanesh Vaidya
    Anjanesh Vaidya ✭✭✭✭✭
    Answer ✓
    Options

    Hi JNorman,

    You can try the following formula to achieve the required output.

    I hope it will work.🙂

    =IF([Calibration Due]@row - TODAY() > 90, "GOOD", IF([Calibration Due]@row - TODAY() > 30, "3 MONTHS", IF([Calibration Due]@row - TODAY() > 0, "1 MONTH", IF(ISBLANK([Calibration Due]@row), "N/A", "DUE"))))

    Thanks,

    Anjanesh Vaidya

    Smartsheet Development, Ignatiuz Software

    Did this answer help you? Show some love by marking this answer as "Insightful💡" or "Awesome❤️" and "Vote Up⬆️

Answers

  • Anjanesh Vaidya
    Anjanesh Vaidya ✭✭✭✭✭
    Answer ✓
    Options

    Hi JNorman,

    You can try the following formula to achieve the required output.

    I hope it will work.🙂

    =IF([Calibration Due]@row - TODAY() > 90, "GOOD", IF([Calibration Due]@row - TODAY() > 30, "3 MONTHS", IF([Calibration Due]@row - TODAY() > 0, "1 MONTH", IF(ISBLANK([Calibration Due]@row), "N/A", "DUE"))))

    Thanks,

    Anjanesh Vaidya

    Smartsheet Development, Ignatiuz Software

    Did this answer help you? Show some love by marking this answer as "Insightful💡" or "Awesome❤️" and "Vote Up⬆️

  • JNorman
    JNorman ✭
    Options

    Solved, thanks Anjanesh 👍

  • Anjanesh Vaidya
    Anjanesh Vaidya ✭✭✭✭✭
    Options

    Happy to help!👍️ 😀 JNorman

    Thanks,

    Anjanesh Vaidya

    Smartsheet Development, Ignatiuz Software

    Did this answer help you? Show some love by marking this answer as "Insightful💡" or "Awesome❤️" and "Vote Up⬆️

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!