I need a formula expanded to include criteria from a couple additional Columns (within same sheet). For example, Existing Column "Status Check Identified" formula reads: =IF(OR(Status@row = "Validated", Status@row = "Completed", Status@row = "Hold", Status@row = "Active"), "YES", "") How do I expand this formula to EXCLUDE rows where "TYPE" column is "Cost Avoidance" or "Optimization", AND EXCLUDES any dates from the "Actual IMP Date" column that is prior to (or before) December 1, 2023…? I apologize if this doesn't make sense (see attachments).? fx 4.PNG fx 5.PNG fx 2.PNG

nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Smartsheet Community

Connect with peers, share your expertise, and inspire what’s next in Smartsheet — from proven practices to practical how-to insights from fellow users and product experts.

Formula Needed... Again...

Not so formula savvy

I need a formula expanded to include criteria from a couple additional Columns (within same sheet). For example,

Existing Column "Status Check Identified" formula reads:

=IF(OR(Status@row = "Validated", Status@row = "Completed", Status@row = "Hold", Status@row = "Active"), "YES", "")

How do I expand this formula to EXCLUDE rows where "TYPE" column is "Cost Avoidance" or "Optimization", AND EXCLUDES any dates from the "Actual IMP Date" column that is prior to (or before) December 1, 2023…?

I apologize if this doesn't make sense (see attachments).?

fx 4.PNG

fx 5.PNG

fx 2.PNG

Find more posts tagged with

Accepted answers

Paul Newcome

Try this:

=IF(AND(OR(Status@row = "Validated", Status@row = "Completed", Status@row = "Hold", Status@row = "Active"), Type@row <> "Cost Avoidance", Type@row <> "Optimization", [Actual IMP Date]@row >= DATE(2023, 12, 01)), "YES")

All comments

Paul Newcome

Try this:

Not so formula savvy

Paul, you did it once again for me…thank you!!!….sadly I have a few more…but I am following the pattern to edit my other formulas ….so this is awesome!!!! 🤗

Paul Newcome

Happy to help. 👍️

If you need anymore help, don't hesitate to reach out (and feel free to "@ mention" me if you want to get my attention on a new thread).

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.