Formula Question
I am having a problem with the following formula:
=IF(AND(COUNTIF([W9 or 1099 Received]@row:[NDA Received]@row, 1) = 8, COUNTIFS({Bullhorn ID}, [Bullhorn Candidate ID #]@row, {OB Complete}, "Green")), "Green", "Yellow")
The formula is supposed to return the text "Green" if the following conditions are met:
- There are 8 cells in the range
[W9 or 1099 Received]@row:[NDA Received]@row
that contain the value 1. - The Bullhorn ID in the current row is found in the range
{Bullhorn ID}
. - The text "Green" is found in the range
{OB Complete}
.
However, the formula is not returning the text "Green" for all rows that meet the criteria. Instead, it is returning the text "Green" for some rows and the text "Yellow" for others.
Answers
-
Does this help?
=IF(AND(COUNTIF([W9 or 1099 Received]@row:[NDA Received]@row, 1) = 8, COUNTIFS({Bullhorn ID}, [Bullhorn Candidate ID #]@row, {OB Complete}, "Green")>0), "Green", "Yellow")
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.9K Get Help
- 441 Global Discussions
- 139 Industry Talk
- 471 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 68 Community Job Board
- 496 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!