The show if is not working properly right now. Can someone help please. I try to use FALSE so that it will not appear and its not working, still shows to the details. I try to refresh, reload. login logout, try another email still not working.
Since you are using FALSE as condition I guess you don't want to show the Column. in that case you can just untick the SHOW option.
If you are trying something else then please elaborate the requirement
Thank you for response, I tried that already and I know that. I already resolved the logic but the issue is I write different formula and my goal is when the email(the one that is login) is equal to a role="something " then this column should appear.
Issue:
The column address that I want to show is only for technician but my-email role is a manager. I want to show the address column only for technician. The tricky part is when I use the FALSE formula to showif I can still see the column. Its weird right?
My Formula:
LOOKUP(USEREMAIL() ,"tbl_name" ,"email_column", "role") = "Technician"
Note: I triple check clearly my data and formula and its not working.
@mico777 wrote:The tricky part is when I use the FALSE formula to showif I can still see the column.
Can you please share some screenshots
User | Count |
---|---|
18 | |
10 | |
8 | |
6 | |
5 |