Alternative to Dynamic View?
We are currently using smartsheet to manage our various projects. We would like to be able to have a project plan (sheet) that has certain columns visible to the customer. We do not like dynamic view - it doesn't look like a project plan and isn't really usable for a customer to regularly update/work in.
We are trying to explore having 1 sheet viewable for the customer, but a master project sheet that isn't. So this master sheet would house internal information (columns), comments, tasks - things we don't want the customer to see. The master sheet would then copy checked rows into the customer facing sheet (which is essentially a pared down version of the master sheet). We are having trouble figuring out the best way to copy as it's static. If we update the master sheet, it doesn't update the customer sheet. Is there a way to have both sheets update each other?