IFContains formula
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?
Answers
-
Try a COUNTIFS instead of a CONTAINS.
=IF(COUNTIFS([Exception report]@row:[Cut-Off and Unauthorised Spend POs - AP Comments]@row) > 0, 1)
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.4K Get Help
- 394 Global Discussions
- 213 Industry Talk
- 449 Announcements
- 4.6K Ideas & Feature Requests
- 141 Brandfolder
- 132 Just for fun
- 131 Community Job Board
- 453 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 293 Events
- 35 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!