Cell Linking User Distro List from one Sheet to another Sheet Summary for Copy and Pasting

mmac

Hello, I have a user column contact list with user emails in one sheet (1) and two additional columns for different distro lists that each user is a part of.

I am linking these columns/cells to a project roadmap sheet (2). As part of Sheet 2, I am utilizing the sheet summary and I have added fields within the sheet summary and included a formula to pull in the users for each individual distro list they are a part of.

The end goal is to be able to copy and paste from each distro group field in the sheet summary and email those users. However, the issue I am running into, is that admins/owner of the sheet, when clicking into the fields to copy the user emails from the sheet summary, the formula is exposed. Does anyone happen to have a work around, or a different idea on how to accomplish this?

Thank you in advance for your support.

James Keuning

Unless something has changed, and I do not think it has, you cannot.

How can I copy the value from a smartsheet summary? — Smartsheet Community