Hi everyone
I have a “MAINTENANCE” table with a column named “N.S” that refers to a “GSE” table.
In the table “GSE” .- (column “N.S” numbers), (column “STATE” inoperative).
In the “MAINTENANCE” table, how can I display only the numbers in the “N.S” column that are inoperative
In the “GSE” table?
thank you
Solved! Go to Solution.
For the Valid If expression for the N.S column of the MAINTENANCE table, try:
SORT(
SELECT(
GSE[N.S],
AND(
ISNOTBLANK([STATE]),
([STATE] = "inoperative")
),
TRUE
)
)
It might be helpful to create a slice of “Inoperative” records from the GSE table.
I would make a slice to hold the Inoperative records, then use the slice to restrict the options for your reference by using a Valid If formula like this:
Inoperative_GSE_Slice[Tables_Key]
You can read more about slices here:
Hello
thanks but I have already created an inoperative slice.
in the maintenace form screen when I have to assign in the N.S column all the operative ones also appear
For the Valid If expression for the N.S column of the MAINTENANCE table, try:
SORT(
SELECT(
GSE[N.S],
AND(
ISNOTBLANK([STATE]),
([STATE] = "inoperative")
),
TRUE
)
)
Perfect!!!
thanks a lot!!!
User | Count |
---|---|
42 | |
29 | |
22 | |
20 | |
15 |