IFContains formula



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?


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!