Timeline for REGEX Validation Rule error on blank field
Current License: CC BY-SA 4.0
3 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Feb 5 at 16:44 | comment | added | prem22 | Yes I agree, using AND (as per your answer) is a better approach, as we don't need the false evaluation in the IF statement. I just posted this answer, as I tried doing it using IF approach and it worked. Posted the answer just to show that it could be achieved this way too. Thanks for your valuable feedback, appreciate it! | |
| Feb 5 at 16:37 | comment | added | Derek F |
Generally speaking, using IF() to return a true/false value is a bit of a red flag. It'd work just fine, but extra typing means extra chances to make mistakes. IF(<condition>, true, false) simplifies to just <condition>. In this scenario, it would simplify down to AND(<not blank check>, <regex>).
|
|
| Feb 5 at 16:26 | history | answered | prem22 | CC BY-SA 4.0 |