I have the following configuration of users. In this case, if the name is not two words, or the email is not valid, or the phone number < 10 characters, I want to flag the account as “not approved”. However, it seems to be only checking for “valid name”, and ignoring the other conditions… [image…

[image] Himaladin: If validName >= 2 then true If isPhone >= 10 then true if email is true then true else false Right idea, but I would flip the logic: If validName < 2 then false If isPhone < 10 then false if email is not true then false else true An IF statement will always stop and ret…

If- then - else in data editor

Ask for Help

gvalero December 23, 2021, 3:53pm 6

Hola!

If I were you, I’d use a combination of JS code with RegEx syntax to save columns and time. All in one column.

Something like it here:

Saludos!

3 Likes

Topic		Replies	Views
Is there an easy way to deal with Multiple conditions? Ask for Help	6	663	October 11, 2022
Formula to calculate only if a cell has value, else to be blank Ask for Help	8	1215	March 9, 2020
If THIS and THAT THEN Ask for Help	4	542	August 25, 2022
If then glide column Ask for Help	3	264	February 2, 2021
"OR" in a row Ask for Help	7	367	March 23, 2021

If- then - else in data editor

Related topics