IF AND FORMULA

Can anyone help with this formula please as i have tried to get it to work unsuccessfully but might even be barking up the wrong tree altogether

=IF (NOT (AND (G2 = "COMPLETE",C2 < today()),"OVERDUE",""))

Basically i want the cell to flag as 'OVERDUE' if G2 does not have complete in it and C2's date is less than today

Thank you

Find more posts tagged with

Formulas

Accepted answers

Paul Newcome

Try this:

=IF(AND(G2 <> "COMPLETE", C2< TODAY()), "OVERDUE")

All comments

Paul Newcome

Try this:

=IF(AND(G2 <> "COMPLETE", C2< TODAY()), "OVERDUE")

Fialko66

https://community.smartsheet.com/discussion/comment/370199#Comment_370199

Thanks Paul - Problem solved, i think i was over complicating it

Paul Newcome

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, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.