Restrict field to certain user

[jgiangra]

Hi! My main table has certain financial fields that only one user should see. I tried two routes below but no success. Where did I go wrong? 🙂 

1) I tried USEREMAIL () = "the persons email address" in the Show If formula on the field and selected the setting to apply Show If universally. (this formula does seem to work to hide a view but not a field in the dataset).

2) I read other posts about creating a user table, so I did that with the person's email address and corresponding role as "Finance". Added the User table then applied this Show If formula on the field in my main table: 'Finance'=ANY(select(Users[role],[Email]=USEREMAIL()))

[Tsach]

You should wrap it with NOT()

NOT(USEREMAIL () = "the persons email address")

This will show to all except this user .

[dbaum]

---

@jgiangra wrote:

no success

---

Consider sharing screenshots to illustrate exactly what you're seeing and what you expect.

ICYMI:

• A column's Show if property only governs whether the column's values appear--not whether the column itself appears (e.g., in a table view).
• Links to lots of relevant guidance at  SUMMARY TIP: User permissions, roles, and settings - Google Cloud Community . 

[jgiangra]

@dbaum thanks for the reply! I tried one of the solutions in this post that didnt work but I see more guidance further in the thread. Im going to try that!