I am using Smartsheet to implement an AM (additive manufacturing) order tool for a SME, which uses AM for prototyping. Objective of that project is to directly set an order out of the CAD programm (STL-file, part specifications) into Smartsheet, which will automatically send a notification to the supplier, who will then have access to an order form to fill in the confirmation data.
It is important that the supplier has an overview over all the orders from us, but since we are working together with more than one supplier, I want to hide orders from other suppliers. With the filtering function, one can only display the orders from one supplier by setting a criteria. Now, I want to ask if it is possible only to enable a filtered sheet for certain users?
Or does anyone has suggestions how to solve this issue?
Thanks in advance for your support!