Thanks for the thread! @Jeff Reisman , I have a similar issue, where I am trying to hide a section of a form that opens up when a user hits "Yes" (I want this space, Yes, open 10 more questions!).. however down lets say question #6 also has a conditional field to show if someone hits "other". Is there a work around?
Conditional Logic Not Working Correctly In Form
PKane
✭✭✭✭✭
Hello Community,
I have created a form with logic where a notes field remains hidden unless the user checks a box - this is to help keep the form shorter. It is working correctly for all other examples in the form except the 'IGB Bonded to Grounding Ring Notes:' which seems very odd. The formatting is the same as the other examples and there are no unusual characters being used in the column name.
I have tried redoing the automation, changing the name, characters, formatting of the columns and nothing seems to work.
Hopefully someone can help?
Example - the others are hidden because their boxes aren't checked, but the last one won't get on board...
Best Answer
-
@PKane There has to be a field higher up in the form that has logic forcing that Notes field to be visible.
From my test sheet:
Since the Amount field is higher up than the CheckInData checkbox, its logic overrides the CheckInData's logic.
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!
Answers
-
In the form setup, what does the conditional logic for the "IGB Bonded to Exterior Ground Ring Notes?" checkbox field look like?
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!
-
-
@PKane There has to be a field higher up in the form that has logic forcing that Notes field to be visible.
From my test sheet:
Since the Amount field is higher up than the CheckInData checkbox, its logic overrides the CheckInData's logic.
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!
-
Did a little digging, @Jeff Reisman - and you were correct. It was listed in a higher-level causing it to show.
Thanks for the assistance!
-
👍️ Glad you found it!
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!
-
Thanks for the thread! @Jeff Reisman , I have a similar issue, where I am trying to hide a section of a form that opens up when a user hits "Yes" (I want this space, Yes, open 10 more questions!).. however down lets say question #6 also has a conditional field to show if someone hits "other". Is there a work around?
-
I don't think there's a workaround right out of the box. With two conflicting sets of logic, Smartsheet is going to defer to the one higher up in the form.
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
- 66.7K Get Help
- 438 Global Discussions
- 152 Industry Talk
- 497 Announcements
- 5.3K Ideas & Feature Requests
- 85 Brandfolder
- 155 Just for fun
- 77 Community Job Board
- 509 Show & Tell
- 34 Member Spotlight
- 2 SmartStories
- 307 Events
- 36 Webinars
- 7.3K Forum Archives
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!
Trending in Formulas and Functions
- Hi! I cannot figure this out. I have a "% Complete" column (0, 25, 50, 75, 90, 100, Cancelled). I made a simple checkbox column that should be checked if the item's "% Complete" value is equal to anyt…
- This formula keeps coming up as #UNPARSEABLE. I have checked the name of the columns, they are correct. Any ideas? I am trying to show the days remaining in a project. =IF([% Complete]@row = 1, "", NE…
- Hi All! I´m trying to find the error in this formula but have not been able to find the solution after many attempts. Any ideas? =IFERROR(IF([To Date]@row <> "", IF([To Date]@row < TODAY(), "RED", IF(…
