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.4K Get Help
- 424 Global Discussions
- 221 Industry Talk
- 465 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 145 Just for fun
- 62 Community Job Board
- 463 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 301 Events
- 39 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!