-
Update request not working
We are experiencing a significant issue with our Smartsheet used for audits. Currently, only three managers have direct access, while the remaining 26 team members submit their insights through an automated update request workflow. Recently, team members have encountered a persistent message stating, "Smartsheet has been…
-
Help with automation
Hi. I need some help with automations based on upcoming expiry date of contracts. I want to send an email alert when a contract id within 3 months of expiry date. Initially I created a helper/formula field using a formula field called DUCE (days until contract expiry) by using Contract date - Today() and set condition DUCE…
-
How can I set an alert/email to the contact in a cell as well as the triggering user?
I am new to Smartsheet and looking for a way to manipulate the automation templates: I have an automation that once a date is entered an email is sent to the contact in a cell alerting them that the information is ready to be worked on. It has been requested that the person that triggers this action (Enters the Date) be a…
-
Placeholders in automation and column formulas
Do the placeholders {{cell content}} not work on automated messages on columns with a column formula? I can only get columns with no column formula to work when testing. But I heavily use column formulas as I am sure a lot of people do so that really limits what I can use automations for.
-
Email Alert Notifications - Column vs Row Display
Is there a way to modify the way that the email alerts are displayed in the generated email from Smartsheet. Right now, if a sheet has a large number of columns it squishes them together. I have seen the emails come through as a row and a column view. I prefer the column view. Is there a way to set this?
-
Flagging and Counting Consecutive Weeks of 'No Time to Report'
Hi everyone, I'm having trouble with a problem in Smartsheet. I need to flag instances where there is "no time to report" for consecutive weeks and count how many consecutive weeks this occurs. The two highlighted columns on the right show what I'm trying to achieve. Any help would be greatly appreciated!
-
Merged: Allow for more customization in alert automations
This discussion has been merged.
-
Can I insert "Tiggering User" into alert email Text?
When creating and automation alert SmartSheet allows you to register the "Triggering User" within the email address of the sender. However I would prefer all our emails to come from "SmartSheet Automation" but it would be good if the Triggering User name can be included within the body of the alert email text. Does anyone…
-
Alert Automation: Links are not working on our Client's Email but working on others
Hi All, Our problem is not being able to click the Hyperlink we attached to our Automated Alerts. When we test it out on our side, it works. It also works for external emails/personal emails. My initial conclusion is this could be a security issue on their outlook. But I would like to know if anyone experienced this before…
-
Attaching entire sheet of specific rows to a notification...
Odd problem but for example I would have a sheet of subprocessor vendors that includes a category, name, address, business line and other fields, when I add a new vendor to that list I would like to notify the customers who have requested that information of the new vendor name, address and category only, as well as all of…
