Formula to pull selected text from a cell into a dropdown list.
Answers
-
@Paul Newcome - Thank you! I got bogged down in trying to join/collect/contain, simpler is always better.
-
Happy to help. 👍️
Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!
-
@Paul Newcome @ker9 thank you so much! It is so easy to look right past the easy answer and try to make a complex formula. This seems to be working GREAT!
-
@Paul Newcome is there an easy tag to the formula that would return "N/A" if none of the criteria matches? I don't want a string of N/As, just one.
-
@damon.tackett It will LOOK like a much larger formula, but really the syntax is pretty basic. We would essentially say
=IF(original_formula <> "", original_formula, "N/A")
If the original formula is not blank, then output the original formula. Otherwise output "N/A".
=IF(IF(CONTAINS("BT1", [Customer Order]@row), "BT1" + CHAR(10), "") + IF(CONTAINS("BT2", [Customer Order]@row), "BT2" + CHAR(10), "") <> "", IF(CONTAINS("BT1", [Customer Order]@row), "BT1" + CHAR(10), "") + IF(CONTAINS("BT2", [Customer Order]@row), "BT2" + CHAR(10), ""), "N/A")
Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!
-
Another method to check if the cell does not contain "BT"
=IF(CONTAINS("BT", [Customer Order]@row) = false, "N/A", IF(CONTAINS("BT1", [Customer Order]@row), "BT1" + CHAR(10), "") + IF(CONTAINS("BT2", [Customer Order]@row), "BT2" + CHAR(10), "") + IF(CONTAINS("BT3", [Customer Order]@row), "BT3" + CHAR(10), "") + IF(CONTAINS("BT4", [Customer Order]@row), "BT4" + CHAR(10), ""))
-
I would rather those little tags for the longer formula than the alternative I was looking at of adding more columns and doing some kind of combine. Thank you again @Paul Newcome! And thank you @ker9 for calling in "the big guns"!!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63K Get Help
- 380 Global Discussions
- 212 Industry Talk
- 442 Announcements
- 4.6K Ideas & Feature Requests
- 140 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 305 Events
- 34 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!