Valid_If not validating

AppSheet AppSheet Q&A
1

I have this ISBLANK in a Valid_If and I do not get the Valid_If Message in the case where the Order Number is not returned by the SELECT() and thus BLANK
This Valid_If is in a Column that is Required

ISBLANK(ANY(SELECT(Orders[Order Number], [Order Number] = [_THIS].[Order Number])))

Any suggestions

2

Try [_THISROW] instead of [_THIS].

3

Thanks @Steve. I keep on making that mistake.
Will not make it again

1 Like