Smartsheet Forms - Show field when (multiple validations)
I have a form where if 3 fields are blank I need a 4th field to be shown and be required. I have logic right now to show the 4th field if the fields are blank, however it's OR logic and I can't see a way to change it to AND. Is this possible and if so, how? (Below is the 4th field and the current logic)
Answers
-
@Erika.DeFalco There's not currently an option for this to be "AND" logic. But it's a great idea! You should post it as an enhancement idea here: https://community.smartsheet.com/post/idea
The only way I see of getting close is by cascading the logic: If Device Retuned By is blank, then show Device Phone Number; if Device Phone Number is blank, then show IMEI; if IMEI is blank, then show Notes. So all four would be there at the start, but the Notes field would disappear if any of the three others was not blank.
Regards,
Jeff Reisman
Link: Smartsheet Functions Help Pages Link: Smartsheet Formula Error Messages
If my answer helped solve your issue, please mark it as accepted so that other users can find it later. Thanks!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.8K Get Help
- 437 Global Discussions
- 138 Industry Talk
- 470 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 65 Community Job Board
- 486 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!