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
- 62.7K Get Help
- 371 Global Discussions
- 203 Industry Talk
- 436 Announcements
- 4.5K Ideas & Feature Requests
- 137 Brandfolder
- 129 Just for fun
- 129 Community Job Board
- 448 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 282 Events
- 32 Webinars
- 7.3K Forum Archives