Hi, I need to hide the action button if the column/row not empty.
For example, if I click on the action button, then add a new data in this row (Estado).
If this ticket is "respondido", then hide the double check action button.
Again, thanks in advance!
You should put an appropriate expression in the action's
Hi, thanks, but I have no clue about the expression.
I have read a lot of Q&A here and I can't reach the solution.
ISNOTBLANK(SELECT(...)) or ISNOTBLANK(column to check) can be used.
I have a complete answer, with more data, but something happend...
I actually use tihis formula:
and((LOOKUP(USERSETTINGS("Correo Usuario"), "Usuarios", "Correo Electronico", "Rol Usuario"))<>"Apoderado", (NOT(IN([Resuelto], Ticket[Resuelto])))) ,ISBLANK([Resuelto])
but hide in all Estados
Thanks!
and(
LOOKUP(
USERSETTINGS("Correo Usuario"),
"Usuarios",
"Correo Electronico",
"Rol Usuario"
) <> "Apoderado",
NOT(
IN(
[Resuelto],
Ticket[Resuelto]
)
)
) ,
ISBLANK([Resuelto])
Your expression (somewhat cleansed) is grammatically incorrect. At least the last piece is not part of AND.
User | Count |
---|---|
15 | |
11 | |
10 | |
8 | |
3 |