IF/AND, OR

Hi All,

Smartsheet newbie here 👋 trying to figure out what seems to be a basic formula with no luck...

I would like my "At Risk" column flag to get checked if the "Due" column date is past today OR if the "At Risk" dropdown is selected on the "Status" column. Here's my started formula that doesn't include the OR:

=IF(ISDATE(Due#), IF(AND(TODAY() > Due#), 1))

Thank you so much!

Find more posts tagged with

Formulas

Accepted answers

All comments

Kelly Moore

Hey @Alexandra Reeder

Try this

=IF(ISDATE([Due#]@row), IF(OR([Due#]@row < TODAY(), Status@row = "At Risk"), 1))

This will check the box anytime the Due# is less than Today, regardless of any other status. If you are tracking 'complete' or some other indicator we might need to also incorporate that into your formula to turn off the checkbox

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.