Welcome to the Smartsheet Forum Archives
The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.
Cheery picking data from a sales sheet for customer to view
We maintain orders for customers in a sales sheet, the columns look something like this;
This is our master sheet.
So to update our customers we have to look at the sheet and email them important information from it.
Is there a way to create a copy but filtered view of this sheet that can be shared with the customer.
Id like to create a read only sheet based off the master sheet and then filter that sheet and share it with customer. Filter would be show Customer A orders which are shipped and only these columns;
I have been looking into cell linking but it seems you need to manually select each cell or range of cells as opposed to an entire column that you could then put a filter on on the sheet you are sharing with the customer.
Be great to be able to copy an existing sheet so that is is ready only. From there filters could be added to the ready only sheet and that be shared with the customer.
Any ideas on this?