If then logic in Smart Forms
While I am aware of functionality that certain fields can be hidden / unfilled / unrequired when an option on another field is not met, I am wondering if forms does have capability of if then logic.
For example:
- If component RRH is chosen, email field is locked to abc@yahoo.com
- If component ECS is chosen, email field is locked to xyz@yahoo.com
- If any other component is chosen, email field is unlocked for entry
Any help you can provide would be much appreciated.
Answers
-
Hi @fahadskazi,
I think you can do this in two ways but they are work arounds to what you are trying to do.
1.) Have 3 separate columns, one for each email. When RRH is chosen then e a column field pops and the only option is abc@yahoo.com. Same for ECS. Then create logic in the form when something or than RRH/ECS is selected pop the third column field which allows the user to enter an email
2.) Similar to above but with less columns, create logic in the form when something or than RRH/ECS is selected pop the column field which allows the user to enter an email. Then in the sheet it's self, write a formula in the email column that will populate it with the correct email when RRH or ECS is chosen in the form.
Hope this helps!
James
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 64.3K Get Help
- 423 Global Discussions
- 221 Industry Talk
- 462 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 144 Just for fun
- 59 Community Job Board
- 463 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 300 Events
- 39 Webinars
- 7.3K Forum Archives