-
Email Notification - Limits to Columns in Message?
Our clinic managers perform a monthly Joint Commission readiness walk-through for each clinic (approx 125). I have built a form for them to document their results for each question - Compliant vs. Non-Compliant. When setting up a email notification to send the results to the regional directors, there seems to be a…
-
How to embed HTML hyperlink into form submission email
Hi! I love Smartsheet but I can't seem to find a way to do the following: After a user submits a Smartsheet web form entry to populate my sheet with data, I'd like to embed a hyperlink into both (if possible) the response and email confirmation so that the user is directed to a web page on my site for next…
-
Notification Icon Enhancement - Change Colour when notification successfully sent.
I use the notification icon to set up notifications to staff as reminders to fill out forms on a certain date. I love this feature but what frustrates me a little is that once the notification is sent, the icon disappears. This may have been a good idea from your perspective, however, the removal of the icon once the…
-
Can you add an approval or action button directly to a notification?
Hello - I am new to Actions and Alerts. I would like to set up a workflow to allow our team to submit travel requests for their managers for approval. I have my form and sheet set up fine, and the workflow seems to be working correctly and notifying the indicated approver via e-mail. However, it looks like the approver…
-
Message Only Notifications with Attachments
Hello, I am trying to send a notification with the Message Only setting while including an attachment that is linked to the row. The primary goal of this is sending the notification without sending a link to the full datasheet to an external contact. Any assistance would be appreciated. Thanks!
-
Combining SUM and RIGHT
Hello, How may I find the SUM of multiple columns by using the SUM function and RIGHT function? I am collecting the data via a Smartsheet form and will need to email out the call center representative's score to their managers. I am getting #UNPARSEABLE as the result. Can someone help correct me? A1, Customer…
-
Email Automation Not Following Condition
I've set up a simple workflow to send email notification when the "Email Notification" column's box is checked. When testing, it still sends emails to the rows that have unchecked boxes. Why is this happening?
-
Separate notifications for added rows
Hi, I want to create a separate notifications for each row that is added when certain conditions apply. I'm sharing a screenshot of how the notification is set up. The issue that I have is that if more than one row is added before saving the document, then the email will contain all the rows that where added/updated. What…
-
Can you alert/send an email to contacts in a cell that have been entered via a form?
I have my alert settings to Unrestricted, but even so, it seems those who fill out our form cannot be notified since they are not users of SmartSheet. I am looking for a solution other than the "Send me a copy of my responses" option. TIA! 😁
-
Form: Change "From" on Automated Form Submission
Hello! My team at work recently created a form with an automated email response to confirm to the recipient that their submission was received. When this email is sent, however, it reflects the name of the owner of the sheet. I am wondering if it is possible for us to change the name to something generic for our team,…