Timeline for How do I "validate" a column/field only if it's not blank
Current License: CC BY-SA 4.0
6 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Jun 28, 2018 at 6:39 | history | edited | AlexZh | CC BY-SA 4.0 |
added 248 characters in body
|
| Jun 28, 2018 at 6:36 | comment | added | AlexZh |
If your field is blank then you need to place 6 - the correct sum for the else variant. If you'll change conditions you should change this value in both places in the formula. Or you can use another variant - with OR abd AND function. I just added it to answer.
|
|
| Jun 28, 2018 at 6:33 | history | edited | AlexZh | CC BY-SA 4.0 |
added 248 characters in body
|
| Jun 28, 2018 at 1:41 | comment | added | Chris Plonka | This worked!!! Thank you. Can you explain why you used the syntax you did. Specifically the ,6, | |
| Jun 28, 2018 at 1:40 | vote | accept | Chris Plonka | ||
| Jun 25, 2018 at 5:37 | history | answered | AlexZh | CC BY-SA 4.0 |