Looking for a wildcard alternate solution

Hi there,
I have a formula that I would usually use wildcards for, but wildcards don’t seem to work in Smartsheet, so I am hoping for an alternate solution.
This is my formula and an explanation on what it does;
=IF(OR([Column B]@row = "Word 1", [Column B]@row = "Word 2", [Column B]@row = "Word 3"), [Start Date]@row + 64, [Start Date]@row + 32)
This formula is in a due date column. It automatically determines the due date as 32 calendar days forward, unless Column B has one of three predetermined words in it, then it counts forward 64 days instead.
This formula works perfectly if Column B has only one word/phrase in it. It is a multi-select drop down column and sometimes there is more than one word/phrase selected. When this occurs, it doesn’t count forward the 64 days and counts forward the 32 days, as it is looking for an exact match. I tried *wildcards* and found this feature is not supported.
Any suggestions on how I could make this work?
Thanks in advance
Best Answer
-
Hi,
This method should work for you when searching for a word within a string, or multi-select scenarios. Hope that helps!
=IF(OR(CONTAINS("Word 1", [Column B]@row), CONTAINS("Word 2", [Column B]@row), CONTAINS("Word 3", [Column B]@row)), [Start Date]@row + 64, [Start Date]@row + 32)
Answers
-
Hi,
This method should work for you when searching for a word within a string, or multi-select scenarios. Hope that helps!
=IF(OR(CONTAINS("Word 1", [Column B]@row), CONTAINS("Word 2", [Column B]@row), CONTAINS("Word 3", [Column B]@row)), [Start Date]@row + 64, [Start Date]@row + 32)
-
Thanks so much Jeff This worked well!
Nat
-
No Problem 😀
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 65.9K Get Help
- 429 Global Discussions
- 147 Industry Talk
- 486 Announcements
- 5.2K Ideas & Feature Requests
- 86 Brandfolder
- 151 Just for fun
- 74 Community Job Board
- 498 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 305 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!