I have a dropdown column that I need the choices to associate with a value?
I have a dropdown column [Session 1] that has 7 different options.
-Juvenile Parole Reform Update: Using Mitigation Best Practices Focused on Healing from Harm
-The Intersection of the New Mexico Indian Family Protection Act, Culture, Geography, and Law in Child Welfare*
-Improving Resource Access to Families - NMCAN Youth Panel
-Special Immigrant Classification Act (SIJCA) - Implementation of the new law protecting vulnerable youth
-The Role of the Guardian ad Litem for Represented Individuals
-Interdisciplinary Engagements with Mental Health Professionals: Building Trust and Common Goals
-The Story of Our Families: Who They Are, How We Are Serving Them, and Why They Matter- Panel
-Round Four Child and Family Services Review
-Kinship Guardianship: Creating Opportunities, Changing Outcomes
When an option is selected, I have a help column [Day 1 Session 1] that has the following formula to assign the text a value.
=IF(HAS([Session 1]@row, OR("Juvenile", "Intersection", "Improving", "Special", "Guardian", "Mental", "Story", "Round", "Kinship")), 1.5) but the column is coming up blank. No error message, just blank.
I tried the following formula and it is producing a result but I want to search for a word from each title not just the one =IF(CONTAINS("Juvenile", [Session 1]1), 1.5)
Answers
-
You have to nest multiple CONTAINS functions inside of an OR function.
=IF(OR(CONTAINS("Option A", [Column name]@row), CONTAINS("Option B", [Column name]@row), CONTAINS("Column C", [Column Name]@row)), 1.5)
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.1K Get Help
- 348 Global Discussions
- 199 Industry Talk
- 427 Announcements
- 4.4K Ideas & Feature Requests
- 133 Brandfolder
- 127 Just for fun
- 127 Community Job Board
- 455 Show & Tell
- 28 Member Spotlight
- 1 SmartStories
- 282 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!