Connect with peers, share your expertise, and inspire what’s next in Smartsheet — from proven practices to practical how-to insights from fellow users and product experts.
Sign in to join the conversation:
We have created a smartsheet for all our tradeshows. I would like to share certain columns in that sheet with our customer when a show is created and hide ones that we use for our internal info only. I know we can uncheck columns we do not want when we share in an email but with so many events we have to uncheck those in every email we send and someone could forget to uncheck a column in error and our customer would get that information. So is there a way to save that email format as a sort of template so everytime we send the show information it only sends those columns? Also it would be helpful to have the same email template to select from with a standard message we create since it's the same message each time.
Have you looked into a report? You can select which columns are displayed in the report and send it separate from the sheet.
Hi Becky,
I'd also suggest using reports and maybe multiple to fit what you need.
Another option could be the Premium Add-on, Dynamic View.
More info: https://www.smartsheet.com/product/dynamic-view
Would that work?
Hope that helps!
Have a fantastic day!
Best,
Andrée Starå
Workflow Consultant / CEO @ WORK BOLD
It sounds like you might be using the "Send Row" feature to send an email and select the columns again each time you send the email. Another option might be to setup an Alert in Automated Workflows. You can set it up to only send when the event reaches a certain status or if a checkbox is checked on that row, for example. Some of the constraints this would place on the user's workflow is that the recipient would have to be in a field/column the row, and you'd have to follow a different process for sending out the message. However, the set of columns and the message subject/body would be sent consistently every time.
Hope this helps and I'd love to know what solution works best for your particular scenario.
Hello, smarter friends: I'm trying to learn how to utilize automations to move certain rows to new sheets in order to explore if my larger/longer ranging goal is possible. Where I'm Currently Stuck: I can't even figure out how to create functional auto to send a row to a basic sheet. That is my immediate need. But if…
I'm having issues accessing Smartsheet in both the desktop app and web browser and continually get the below error message…I need to refresh multiple times to get it to work. And sometimes it works and sometimes it doesnt:
This just started today… For some reason, I can no longer edit fields in my Smartsheet. One I'm the owner of. I do see an icon in the upper right that says "Comment Only", but can't figure out how to change it. Here a screenshot of what I am seeing:
