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!
Best Answer
-
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)
Answers
-
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.
-
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)
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.5K Get Help
- 402 Global Discussions
- 213 Industry Talk
- 450 Announcements
- 4.7K Ideas & Feature Requests
- 141 Brandfolder
- 135 Just for fun
- 56 Community Job Board
- 454 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 296 Events
- 36 Webinars
- 7.3K Forum Archives