-
Sending An Update Request after 30 Days
Hello! I'm trying to send an update request to be alerted during the following time periods: 30 days after the initial row was added 60 days after the initial row was added 90 days after the initial row was added I have an "entry date" field to build off of to serve as the date the row was added. Is there a way to do this…
-
Automation Email Attachment Options
Hello, I am not sure if this is even possible, and not normally how the automation process is used, but its worth a shot. Is it possible to set up an automation to email someone form a contact column, with the email containing information from another sheet when a form is submitted? For reference, the security company I…
-
Can we decide who receives emails when the comments are added?
I use Smartsheet as a request system for our team. We will have tickets that are assigned to the members of our team and the tickets are submitted by anyone. I want to customize who received emails when the comments are added. For example: If the person who submitted the request (Requestor) has added comments, I want an…
-
Automated email subject line text
So, if you automate emails (workflows) and forgo customizing the message, the email title is autogenerated as follows-- For Alert Someone: Changes to [title of sheet]:[primary column text] For Update Request: Update request for [title of sheet]:[primary column text] However, when you customize the message, you can assign…
-
How to get an approval after a decline in the automated approval request workflow?
Hi All, I have created an automated workflow based on a form submission that asks for the Approval of at least 3 individuals/roles. If an Approver declines, it will send and update request to the originator (Project Manager) and ask them to update information in the form. Once the Project Manager has updated the form, the…
-
Updating sheet data before copying row
I have an intermediate sheet with only one row that pulls the results of some calculations from my master data sheet in order create an archive entry. This intermediate sheet has an automation set up to copy the row into my archive sheet at a certain day and time every week, i.e. it extends the archive with a snapshot…
-
Where Can you find Smartsheet consultants?
I'd love to find Smartsheet consultants that could revamp, update how we currently use it to maximize, utilize the portal function, address automation's, alerts, set up some reporting etc. Not looking for instructions, but teams that implement for the client. Would love someone proactive to make suggestions as well. I have…
-
Automation - Referencing and Changing Values Between Sheets
Hi, I have build a functional, if not exceptionally efficient, UAT process in which individual tests for a product feed up via cell links to a "Master Product Test Sheet". In this sheet the "Approver" monitors the testing and when a test is flagged as completed and automation "Approval Request" kicks off asking the…
-
SUMIFS with Multi-Select Criteria
Trying to correct my SUMIFS formula include two criteria from a multi-select column. I'm currently getting UNPARSABLE every time try OR, AND, or HAS. Here's what I have so far with my current criteria, I just need to add an additional option for "CXL - COVID19" in addition to "Approved": =SUMIFS({FY Amount}, {FY}, FY 20 ,…
-
Workflow becomes invalid after each trigger.
Hi, I am also facing the same issue. I have set the triggering point to Modified date which is Auto/System Generated Date Column. This is so because my requirement was whenever any changes are done in form, approval request should get triggered. Since we are not sure, what column user is going to change, we kept the…