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.

Need another expert on formula?

Not so formula savvy

Scenario,

need to edit an existing column formula to exclude any $$$ (greater or less than 0) scenarios for a specific column value from a different column ("TYPE") is "Cost Avoidance" or "Optimization" so it does not produce a "YES".

So for e.g.

The Column "Type" has the following values:

New Contract

NPR

Cost Avoidance

Optimization

The Column "Implemented Top 10" formula:

=IF([IMP $]@row > 0, "YES", "")

must produce a "YES" for any row greater than "0" - no matter what "Type" value.

I need to produce a "YES" for any row greater than "0" but exclude those $$$ (negative or positive) dollar amounts with a "Type" value that is "Cost Avoidance" or "Optimization".

let me know if that made sense or is possible?

(

YES Column formula 1.PNG

YES Column formula 2.PNG

see attachments)

Trouver d'autres publications étiquetées avec

Accepted answers

Paul Newcome

Give this a try:

=IF(AND(Type@row <> "Cost Avoidance", Type@row <> "Optimization", [IMP $]@row > 0, Status@row <> "Dropped", Status@row <> "Hold"), "YES")

All comments

dojones

Try this.

=IF(OR(Type@row = "Optimization", Type@row = "Cost Avoidance"), "", IF([IMP $]@row > 0, "Yes", ""))

Not so formula savvy

Oops, I forgot to factor in another couple values from an additional column that i need to factor in:

In addition to the scenario above, I also need to factor in ONLY those rows with a "Status" of:

Active

Completed

Validated

(see attachment)…

fx 3.PNG

Paul Newcome

Give this a try:

=IF(AND(Type@row <> "Cost Avoidance", Type@row <> "Optimization", [IMP $]@row > 0, Status@row <> "Dropped", Status@row <> "Hold"), "YES")

Not so formula savvy

You both came through for me…yes it worked…🤩…and thanks once again Paul!!!!

Paul Newcome

Happy to help. 👍️

Sign in to join the conversation!

Liens rapides

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.