Forum Discussion
Solved
Sharepoint list Hide/Unhide column with "Person" linked formula
Hello everyone,
I am writing into this blog as I got stuck while building up a SharePoint list with conditional hide/unhide column formatting.
Basically what I am trying to do is to make a field in a SharePoint to appear/disappear depending on who is the user logged into the account. The formula of the interested column should be the following:
=if([$Assignedto.email]==@me, ‘true’, ‘false’)
For your better understanding, here is a yt video from the great Reza Dorrani where he shows exactly what I am talking about at the minute 9:58 (with the only difference that it worked for him).
I tried every scenario even with different formulas all referred to "Person" fields but nothing works. Is any of you facing the same issue with the formatting when it comes to getting info from a "Person" field?
Thank you everyone in advance!
mauripard Is this single selection person column or multiple selection person column?
Person or Group ,column with multiple selections is not supported in conditional formula.
Also, make sure you are using correct internal name of your person column in formula. I just checked and it is working fine for me in case of single selection person column.
For more information, check the documentation at: Specify conditional formula to show or hide columns
Related read: How to find the Internal name of columns in SharePoint Online?
Please click Mark as Best Response & Like if my post helped you to solve your issue. This will help others to find the correct solution easily. It also closes the item. If the post was useful in other ways, please consider giving it Like.
mauripard Is this single selection person column or multiple selection person column?
Person or Group ,column with multiple selections is not supported in conditional formula.
Also, make sure you are using correct internal name of your person column in formula. I just checked and it is working fine for me in case of single selection person column.
For more information, check the documentation at: Specify conditional formula to show or hide columns
Related read: How to find the Internal name of columns in SharePoint Online?
Please click Mark as Best Response & Like if my post helped you to solve your issue. This will help others to find the correct solution easily. It also closes the item. If the post was useful in other ways, please consider giving it Like.
Hi mauripard
You got the wrong backticks "‘"=if([$Assignedto.email]==@me, ‘true’, ‘false’)
This works for me=if([$Assignedto.email]==@me, 'true', 'false')
Best Regards,
Sven
