I use the following function:
if(isnotblank([_thisrow].[Last Name]),
isnotblank([_thisrow].[First Name]),
true)
When I want [Last Name] to not be null.
[First Name] must not be null either.
Otherwise, the data cannot be added.
The effect I see in Test is what I need.
But in practice, it has no effect at all.
Only fill in [Last Name] can still add the data.
I know I can achieve the above effect in "Require?", but I can't customize the Invalid value.
ISNOTBLANK([Column Name] is served by making the column "required". So ISNOTBLANK([Column Name]) in the valid_if has no effect.
Please make the columns [Last Name] and [First Name] as "required" columns.
User | Count |
---|---|
42 | |
26 | |
25 | |
17 | |
13 |