Hi all. I am creating a table where I can select several elements, once selected they should no longer appear in the list to choose (or at least if they appear and it is chosen, it should give an error so that it is not selected again)
Right now I am using this formula in "Data Valid":
COUNT(
SELECT(
Alta Ítems[Id Ítem],
AND(
[Family]=[_Thisrow].[Family],
[Usuario que lo agrega]=useremail(),
[Ítem]=[_THISROW].[Ítem],
[Id Ítem]<>[_Thisrow].[Id Ítem]
)
)
)=0
Someone who knows how to make it not appear in the list again or at least not allow me to choose a value that is already previously loaded in the table?
Solved! Go to Solution.
Listo, ya lo he solucionado, expongo mi solución:
and(
COUNT(
SELECT(
Alta Ítems[Id Ítem],
AND(
[Rubro]=[_Thisrow].[Rubro],
[Usuario que lo agrega]=useremail(),
[Ítem]=[_THISROW].[Ítem],
[Id Ítem]<>[_Thisrow].[Id Ítem]
)
)
)=0,
lookup([Ítem],"Ítems","Ítem","Ítem")<>[_thisrow].[Ítem]
)
Listo, ya lo he solucionado, expongo mi solución:
and(
COUNT(
SELECT(
Alta Ítems[Id Ítem],
AND(
[Rubro]=[_Thisrow].[Rubro],
[Usuario que lo agrega]=useremail(),
[Ítem]=[_THISROW].[Ítem],
[Id Ítem]<>[_Thisrow].[Id Ítem]
)
)
)=0,
lookup([Ítem],"Ítems","Ítem","Ítem")<>[_thisrow].[Ítem]
)
User | Count |
---|---|
33 | |
29 | |
29 | |
20 | |
18 |