Best Of
Automation Email Alert Issue - Grouping Notifications with Unique Subjects
Hi everyone,
I've been experiencing an issue with an automation setup and was hoping to get some insights or solutions from the community.
Problem
When I configure automation to send an email alert to a contact after a trigger change, the system groups email notifications together even though each has a unique value in the subject line. This grouping starts occurring with as few as two-row changes.
Specifics - This only happens when I select the "Message only" option when configuring the automation, omitting the link to the sheet. I want to simply notify specific contacts but do not wish to provide them access to, or a link to, the sheet.
Has anyone else encountered this? Any ideas on how to prevent the emails from grouping? I need each alert to be sent as a separate email to avoid any confusion. Appreciate any help you can provide!
Jeremy W.
Formatting change on group headers in reports
Please allow formatting changes on group headers in reports!
- Colour change for the whole header - so that group divisions are clearer
- Removal/editing of the grouping parameter (e.g. "Sheet name") - looks ugly and means nothing to viewers
- Extension of the group title past the first column - sometimes the first column does not need to be as wide as the length of the group title!
Additionally, it would be very useful if column titles changed in size and alignment together with the contents of the cells! What is the point of having large text in the table if the column titles can't be read? I know you can zoom - but sometimes this does not do the job.
Lyn
Re: How to best track Outstanding Update Requests
Hi,
I hope you're well and safe!
My initial thought at a glance.
You could do what I do in many of my client solutions.
I don't specify the message in the Update Request; I put it in the sheet instead, which makes it easier to make it dynamic. It's a fine line between adding more workflows, using formulas, or a combination of the two.
Does that make sense?
Would that work/help?
I hope that helps!
Be safe, and have a fantastic day!
Best,
Andrée Starå | Smartsheet Expert Consultant & Partner / CEO @ WORK BOLD
✅ Did I help answer your question/solve the problem? Please support with 💡 ⬆️ ❤️ and/or ✅ Answer. This will make it easier for others to find a solution or help answer. I appreciate it, thank you! 🙏
Andrée Starå
Free Collaborator User Bulk Upload - exclude Premium Application
The concern is that Free Collaborators should not have access to premium applications. However, during bulk uploads, premium apps are still being added.
There is an option to 'Edit User Properties in Bulk', Furthermore, removing premium apps through 'Edit User Properties in Bulk' is only possible after users accept their invites, which creates a bottleneck and delays the task.
Ideally, this should be handled in a single step of Bulk User Import.
Is there a way to streamline this process? While importing users "Premium Application" should not enable by default. Specifically, can we leverage PowerShell scripting (or another automation method) to import bulk users directly into the Free Collaborator plan without assigning premium applications?
Manjunatha G
NO REPLY Email.
Hello all,
Does smartsheet has the ability to send a NO REPLY email from an automation? I build a solution and now i am getting a lot of emails from the recipients. i need to kind of have them not be able to answer or reach me through my email. i did change the owner of the sheet as well but still getting emailed. Also in the setting of the automation is set to say that was send by smartsheet. Any thoughts?
Tony Oxa
Re: Don't miss these table view updates: performance boosts + new features now live!
Really cool to see what can be achieved with the new Table view over the Grid view.
Will have to wait for a lot of the coming soon features before I can do any switch overs from Grid view first though.
Bligh
Re: Contact List, with Upates
@aschneiderheinze1025 You can use a formula to output an email address as a usable email address for automations so long as the formula is in a contact type column. I do this very frequently.
Do you have screenshots (of sample data)?
Paul Newcome
Re: Contact List, with Upates
@Naeem Ejaz Please double check your sources before posting. Your response is not accurate.
Paul Newcome
Re: Global Regional Preferences
Being based in Australia we write our dates DD/MM/YY (or YYYY), however we are constantly getting asked about the dates in various Smartsheets that default to US. Asking each individual user to change their settings is inefficient for starters and when people are entering dates in forms who are not "users" in our environment this just doesn't work.
This isn't just a nice to have this is a clear problem.
We currently use Smartsheet to submit bookings and are constantly having dates entered wrong despite all the instructions in the world. This needs to be fixed.
Jodie Le
Restricting cells to numbers only
I noticed there's a way to restrict columns for most column types except Text/Numbers. I want to only allow numbers to be typed in and not letters because when letters are typed into those cells, it messes up all my formulas. More specifically, I'd like the editors to only be able to type in a range of numbers, for example only allowing numbers between 0-400,000. What is the best way to approach this?
Thanks,
Mike
Michael Culley