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

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!