User Profile
mauripard
Copper Contributor
Joined Jan 10, 2023
User Widgets
Recent Discussions
VLOOKUP in Sharepoint
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 would eventually like to obtain is to unhide some fields from the form whenever a user from a department X is logged in and is seeing the item. Now, given that apparently something like this is not possible with a simple column formatting you would use for instance in the case of a single individual (=if([$Assignedto.email]==@me, ‘true’, ‘false’), I thought about creating a separate list in the same site which lists all the users with the corresponding department. What would save me at this point is having a VLOOK up field in the original list and then comparing the department retrieved with the "Department X" I would be interested in and making the fields unhide only when "Department X" appears. I know it may sound a bit chaotic as an explanation but the juice of this is : is there the possibility to have a VLOOK up equivalent in Sharepoint list that gets the info from another list present in the same site? Thank you all for any future answers. Bests, Sergiño1.1KViews0likes0CommentsSharepoint 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 https://www.youtube.com/watch?v=y_bdjMRHVmY&lc=UgwChgFO9Y8X4ha5u9F4AaABAg.9khAl00-S5G9khnGhpf8mp&ab_channel=RezaDorrani (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!Solved3.9KViews0likes2Comments
Recent Blog Articles
No content to show