Forum Discussion
Rense620
Aug 17, 2022Copper Contributor
Conditional form format with two conditions not working
Hopefully somebody can help me with this.
I have a list, and a column named "type" with 3 choices. Early, Late, Weekend.
I am trying to hide a field in the New Item form based on these three.
The fieldname/column name to hide has the name "Working hours 1"
I tried this, but it still shows the field "Working hours 1" if nothing is chosen.
=if([$Soortdienst] == 'Early' || 'Weekend', 'true', 'false')
What I want is that only the field is shown when the type Early OR Weekend is chosen.
So nothing chosen yet, nothing wil be shown.
You should try below formula, it should work:
=if([$Soortdienst] == 'Early' || [$Soortdienst] == 'Weekend' , 'true', 'false')
Official Documentation:
Hope it will helpful to you and if so then please mark my response as Best Response & Like to help others in this community.
5 Replies
Sort By
- kalpeshvaghelaSteel Contributor
You should try below formula, it should work:
=if([$Soortdienst] == 'Early' || [$Soortdienst] == 'Weekend' , 'true', 'false')
Official Documentation:
Hope it will helpful to you and if so then please mark my response as Best Response & Like to help others in this community.
- CarlaHobsonCopper ContributorThis worked perfectly! Thank you!
- Rense620Copper ContributorThank you! Now it works well.
Rense620 Also, make sure:
- You are using correct internal name of your column in conditional formula as it does not work with display names of columns.
- You are applying this formula for correct column - "Working hours 1".
Please click Mark as Best Response & Like if my post helped you to solve your issue. This will help others to find the correct solution easily. It also closes the item. If the post was useful in other ways, please consider giving it Like.
- Rense620Copper Contributor
Thanks for your comment! You right.