IFContains formula

Michael Green22

Hi

I am having an issue writing a formula.

I have dropdown fields on my sheet, with either "yes" "no" or "n/a". I want a checkbox formula that ticks when any of the dropdowns contain "no". Then another that specifies the information related to the field next to it that contains the answer "no".

FYI - For each question, as each question has a dropdown field and a comments field next to it which is freetext.

I tried this formula above, but it ticks when it shouldn't. It may be because some fields say "not" or another word that contains the two letters of "no" so it gets confused.

I can provide a clean version of the sheet if needed for data protection purposes.

Any ideas?

Paul Newcome

Try a COUNTIFS instead of a CONTAINS.

=IF(COUNTIFS([Exception report]@row:[Cut-Off and Unauthorised Spend POs - AP Comments]@row) > 0, 1)