First time working with Sharepoint/lists etc and am not even sure if what I want to achieve is possible. I've created a list where users can submit requests, however I want 3 columns only to be accessible to specific users (approvers) who are approving these request - all columns need to be visible to all.
I'd also like to apply some logic to a column, based on the outcome of another column. Eg a user makes a request, an approver reviews the request and updates the status to "more information required" at which point a comment box is available to the requestor to add further information
Any guidance appreciated!