AND statement in smart sheet

I am having issues getting results back when using AND statement

I am trying to compare two conditions, and show if an action is late or not using the following formula

I want to say if the End date is before today and the completed is blank then the action is late.

the line circled in red should show 1 cause both criteria's are true but it still shows 0

=IF(AND([End Date]@row<TODAY(),Completed@row=" "), 1, 0)

Find more posts tagged with

Sheets

Formulas

Accepted answers

Joe M.

Hello,

Try this formula:

=IF(AND([End Date]@row < TODAY(), ISBLANK(Completed@row)), 1, 0)

This should work when the Completed column type is set to date format.

All comments

TDXEV

I also tried this

=IF((AND(ISBLANK([Completed@row])),[End Date]@row < TODAY()), "Late", "OnTime")

Leibel S

@TDXEV

Try this:

=IF(AND([End Date]@row<TODAY(),ISBLANK(Completed@row)), 1, 0)

Joe M.

Hello,

Try this formula:

=IF(AND([End Date]@row < TODAY(), ISBLANK(Completed@row)), 1, 0)

This should work when the Completed column type is set to date format.

TDXEV

Thank you so much everyone

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.