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

Hello

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

Find more posts tagged with

Accepted answers

Dan W

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")))

All comments

Dan W

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")))

Ibrahim Khalaf

thanks Dan

it works good

thanks again

Dan W

Happy to help!

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.