If and Question for At Risk Flags

Zach Henderson

How do I make this work (combine into a single statement)?

=IF(ISBLANK([Days Overdue]@row), 0, 1)

AND

=IF(AND([Days Overdue]@row > -5, [% Complete]@row < 1), 1, 0)

New to smartsheets! Thank you.

Find more posts tagged with

Formulas

Accepted answers

All comments

Gia Thinh

Try this

=IF(OR(Days Overdue]@row <> "", AND([Days Overdue]@row > -5, [% Complete]@row < 1)), 1, 0)

Zach Henderson

When I just use this:

=IF(AND([Days Overdue]@row > -5, [% Complete]@row < 1), 1, 0)

Everything looks good. I want to clear the flag if days overdue is "".

When I add this =IF([Days Overdue]@row <> "", 1, 0)

to the function

such as:

=IF(OR([Days Overdue]@row <> "", AND([Days Overdue]@row > -5, [% Complete]@row < 1)), 1, 0)

I then see this:

I want to clear those flags if days overdue = "". Thank you!

Gia Thinh

Try this:

=IF(AND([Days Overdue]@row > -5, [% Complete]@row < 1)), 1, IF([Days Overdue]@row = "", 0, 1))

Gia Thinh

@Zach Henderson,

Try this also. I think it better:

= IF([Days Overdue]@row = "", 0, IF(AND([Days Overdue]@row > -5, [% Complete]@row < 1), 1, 0))

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.