IF Formula - 2 Conditions and 1 Flag

I have a column that houses a flag to notify if the billed hours breach the budget. But I am trying to use two conditions where it doesn't run if Contract Type contains T&M. My first attempt right now:

=IF([Billable Consultant/Developer Hours]@row > [Consultant/Developer SOW Hours]@row, (IF([Contract Type]@row, CONTAINS("T&M"))), 1)

I get INVALID which I can understand but need to know how to structure htis correctly. I have read through similar posts but not capturing what I am missing. Any help is great!

Find more posts tagged with

Formulas

Accepted answers

Mike Buckiewicz

SOLVED:

I was missing the comma delineation. Although if someone figures out how to exclude values based on containing key phrase let mek now as that would be cool.

This is what worked:

=IF(AND([Billable Consultant/Developer Hours]@row > [Consultant/Developer SOW Hours]@row, [Contract Type]@row = "Prime", [Contract Type]@row = "VSP DNE", [Contract Type]@row = "Subcontractor"), 1, 0)

All comments

Mike Buckiewicz

Update:

I went another direction and discovered the AND function however the drop down values on contract type contains "T&M" is what I am trying to filter out:

=IF(AND([Billable Consultant/Developer Hours]@row > [Consultant/Developer SOW Hours]@row, CONTAINS("T&M", [Contract Type]@row), 1, 0))

Feedback welcome.

Mike Buckiewicz

SOLVED:

I was missing the comma delineation. Although if someone figures out how to exclude values based on containing key phrase let mek now as that would be cool.

This is what worked:

=IF(AND([Billable Consultant/Developer Hours]@row > [Consultant/Developer SOW Hours]@row, [Contract Type]@row = "Prime", [Contract Type]@row = "VSP DNE", [Contract Type]@row = "Subcontractor"), 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.