-
Trigger Notification
Hi there, I'd like to have a notification trigger when a box is checked in a "Complete" column for one particular row to send a notification to all contacts in an "Owner" column. What is best practice for this? Owner Column with email contacts Checkbox for "Complete" Column (other checkboxes were formatted to basically…
-
How to send alerts with link to the sheet WITHOUT sharing changes?
I have a smartsheet that includes automation to alert users when the sheet is updated. We want for emails this triggers to include a link to the sheet, as most users won't work primarily from smartsheet, but we cannot allow users to see the email address of the user who made the change for security reasons, and therefor…
-
Changing Email due to employee quit
We have an employee that is no longer with the company and I need to change that email on his account. I can not figure out how to do this. Any help?
-
Is there a way to make the form link clickable in google chat notifications from Smartsheet?
Right now, when I send a reminder to fill out a form with the link, it is not clickable (the smartsheet app is, and the email notification is), but, this is odd as for a while I only had my G-chat notifications on for receiving smartsheet updates/notifications, but had to turn on my emails again in order to receive the…
-
How Do You Document a Log of Notifications of Sheet Changes
One complaint that I am getting back from shared users of a sheet is that many times they don't know when something has changed. I can certainly make this manual task outside of the Smartsheet but I'd really like it to be captured in the sheet. For instance, I could use "File --> Email Shared Users" as the method to create…
-
Is it possible to add the current date for an email alert?
I am trying to add the current date when sending out a weekly notification. As part of the customized message I would like to add the current date in the subject field/line. Is that possible?
-
Reporting - Updates
Hello - I'm tracking ~40 different sheets on a monthly basis for updates. Is there a reporting mechanism for automatically updating a report with an update date or check mark when each of these sheets is updated? Right now, I just create a workflow to notify me if something has been added/changed on each of the sheets,…
-
Row Change Notification Being Triggered by Rows Added Through Form
Hi there I've setup a notification that's triggered by a row change. However when a new submission is made via the form (i.e. a new row is added via the form) it's triggering the notification as well. The notification is: "Trigger: When rows are changed AND when column1 changes to any value, or when column2 changes to any…
-
When sending an automated email, is there anyway I can pick which order the customized fields go in?
Each time that I try to put certain fields from the sheet into my customized message in a certain order, it keeps changing it to something random.
-
Hyperlinked Text on Automated Notification / Workflow
One of my cell {{Video Link}} has the text of the title and the url of the video. When I send the notification and select the third option on Message to include (Message Only), it only sends the text and not hyperlinked. I dont want to select the second option as it does not look professional and clean. Is there a way to…
