I have a inventory list that staff will be able to view and make requests for those items. I have a "person or group" column in the inventory list that the user will add their name when making a request. How can I hide that item row or prevent other from making requests on the same item with a formula?
There is a column setting called "Enforce unique values" that only allows one item to have specific data in the list.
For example if you apply this to a people picker column in a list you can only have one item in that list with your name. When users add other items and choose your name they will be notified that that value was already used.
This option is available on other types of columns such as choice menu to choose from.
This does not hide but it limits new data to be duplicated in a list if used correctly.
Create a default view that only shows inventory items where Person field is blank. this way when someone goes in and adds their name to an item, it disappears from the view.