-
Automation Question: Can they be this specific?
Ideally, we'd like to alert our vendors if the the Faxed date is greater than 5 days of the Eval Date. Kinda prompting them to take a look as we'd like these cases seen WITHIN 5 days. Is this possible with smartsheet automations? I thought it was but the more Im digging into it, the more Im realizing its not going to work…
-
Reoccurring workflow start based on date in cell and end when a condition is met
It would be awesome to have be able to set a custom recurrence for a workflow that is triggered based on a Date Field instead of a hard coded date. This would be extremely useful for Update Requests and Alerts. For instance having it resend the UR/ Alert/ Approval until a condition changes that shows they have responded.
-
Has anyone seen this issue before with column references inside the message body of an alert?
The template is setup with references to columns in the sheet for notifications. After the project is provisioned through Control Center, the message body is showing {{INVALID COLUMN}} instead of the column name set in the template.. I've never seen this issue before personally. Has anyone seen it?
-
Edit Default Messages for time-based alerts
Would be great if we could edit the default message that Smartsheet sends for time-based alerts when 6+ rows are triggered. I like that it groups requests into one email, but I want to update what the email message says. The text reads "please update my online sheet" which reads a little funny because we're sending these…
-
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!