Determination of Request Type based on form answers
Hello all, my org handles a few types of requests that are broken out based on need and qualifications. I am attempting an integrated request form that will remove the need for multiple form types.
I am wanting a column [RequestType] formula to come up with results based on the answers in the form.
One thing that may complicate this, is that the answers that make these determinations are contained within multi-answer allowed dropdown questions. Here's the logic I am trying to create:
RequestType = "HRSN Climate" if [Request Category] contains "Climate Devices" (the actual dropdown answer is a longer text string) AND [Circumstances] has any multi-select box checked, AND [Health Conditions and History] has any multi-select box checked.
Otherwise, [RequestType] = "Flexible Services"
We have some benefit expansion coming soon that will require me to make the formula have a few more branches, but this would suffice for now. I know I'm close but not quite there. Somewhat new to Smartsheet so help would be appreciated.
Thanks all!
Best Answer
-
Give this a try:
=IF(AND(CONTAINS("Climate Devices", [Request Category]@row), Circumstances@row <> "", [Health Conditions and History]@row <> ""), "HRSN Climate", "Flexible Services")
Answers
-
=IF(AND([Request Category]@row CONTAINS("Climate Device"), NOT(ISBLANK([Circumstances]@row)), NOT(ISBLANK([Health Conditions and History]@row))), "HRSN Climate", "Flexible Services")
Here is my current attempt, getting an unparseable error though.
-
Give this a try:
=IF(AND(CONTAINS("Climate Devices", [Request Category]@row), Circumstances@row <> "", [Health Conditions and History]@row <> ""), "HRSN Climate", "Flexible Services")
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.1K Get Help
- 349 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!