Duplicating sheets deleting certain columns and team distribution via viewer mode


Thank you for your time. I am trying to accomplish a few things simultaneously:

  1. I have a master account sheet that I want to send out to the rest of my team but I want to do it in the following way:
  2. Send them a duplicate sheet with certain financial columns omitted
  3. As I update the master sheet, the sheet that is sent to the team via a workflow will also get updated.
  4. Auto send the sheet to the team in viewer mode.

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!