I have a form that uses a Report Type field to hide a part of the form based on the selection.
Walkthrough, Testing and Assessment
Walkthrough, Testing and Assessment with Compliance
Compliance is the Default. The form should be hidden if either Walkthrough type is selected.
I have gotten the formula to work with 1 selection, but not if either is selected.
Report Type!='Walkthrough, Testing and Assessment'
works as expected, but I have not been able to get the "or" formula to work. I tried:
Report Type!='Walkthrough, Testing and Assessment'||
Report Type!='Walkthrough, Testing and Assessment with Compliance'
this doesn't work. I also tried:
Report Type!='Walkthrough, Testing and Assessment'||'Walkthrough, Testing and Assessment with Compliance'
I thought about using the Contains function, but I'm not sure how to create the formula.
Solved! Go to Solution.
Thank you for your reply.
I figured it out by using
SharePoint Developer | ProSource Solutions, LLC
773-822-6137 cell | firstname.lastname@example.org<mailto:email@example.com>
Sorry, i could not add an image.
I used the formula builder to create this formula:
!contains(Report Type,"Report Name")
where I typed "!", chose "Contains" from Runtime Functions and "Report Type" is a "Named Controls" and "Report Name" is the name of the report in double quotes.
Hope that helps.