Formula help = if date contains NA then show NA in the target cell



im working on sheet managing calibration task , i have 4 columns as following :

1- calibration frequency

2- last calibration

3- next calibration

4 -calibration status

what i need a formula in the 4th column calibration status based on date done, over due and NA , i have complete the easy part of formula for done and over due, the problem is i need to say if cell blank or contain NA the NA

this is formula i have done

=IF([Next P/M]@row >= TODAY(), "P/M Done", IF([Next P/M]@row < TODAY(), "P/M Overdue",IF([Next P/M]@row=NA."NA")))

and it dosnt work for NA it shows #INVALID OPRATION

I hope that my question is clear

Best Answer

  • Dan W
    Dan W ✭✭✭✭✭
    Answer ✓

    Looks like you need a good ole ISBLANK

    =IF(ISBLANK([Next P/M]@row), "N/A", IF([Next P/M]@row >= TODAY(), "P/M Done", IF([Next P/M]@row < TODAY(), "P/M Overdue")))


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!