Help

If statements and search function

Topic Labels: Formulas
709 0
cancel
Showing results for 
Search instead for 
Did you mean: 
frijoleronovent
4 - Data Explorer
4 - Data Explorer

Hello, for context I am creating a form that will be shared publicly, that will be shared widely, where the names of people will also be able to be seen in a public view (it is for a petition). I am afraid of people writing inappropriate/joke names and would like to catch as many as I can with an if statement that would turn them blank in this public view. I am not sure how to go about this exactly especially since I know the case matters. For instance

IF(OR(Name=“Jesus christ”,Name=“Jesus”),Blank(),Name)

is there a function i can use that disregards case and/or just searches the string for certain inappropriate word?

Thanks

0 Replies 0