welcome everybody
I have two tables
The first table: Booking
it contains
[id]
[the condition]
Second table :
it contains
[booking id]
[a]
What is required is that it is not valid for [status] = "cancelled".
and cell [a] in the second table ISNOTBLANK
Solved! Go to Solution.
Do you have a question? Maybe you're struggling with an expression for the [Condition] column's Valid if property to prevent its value from being "Cancelled" if the [A] column is blank? If that's the case, try the following.
IF(ISNOTBLANK([Booking ID].[A]), [_THIS] <> "Cancelled", true)
Do you have a question? Maybe you're struggling with an expression for the [Condition] column's Valid if property to prevent its value from being "Cancelled" if the [A] column is blank? If that's the case, try the following.
IF(ISNOTBLANK([Booking ID].[A]), [_THIS] <> "Cancelled", true)
User | Count |
---|---|
32 | |
31 | |
30 | |
18 | |
17 |