-
Send alerts hourly with placeholders in subject
Hi, I need to send my coworker updates from the Smartsheet that run hourly, but I need to have placeholders in the subject line. I need one alert per unique subject line - so each email alert would contain all updated rows for which the placeholders are the same. Is this possible?
-
Workflow automation - update requests
Hi, I need help. I have a workflow to send an automatic update request when a deadline is achived. The workflow is working perfect but I would like to send line by line and not all lines in same request. Anyone can help me to solve this? In addition i would like also to send an automatic e-mail when the first request is…
-
Quantity in cell to rows
Hello, I have a column named "Quantity" and the cells of that column, I have numbers (any number). Is there a formula or a function that can create new rows (specifically of the quantity) in that sheet or another sheet automatically? Is that something this is automate-able? Example: If cell A1 in Sheet 1, has a quantity of…
-
VLOOKUP Reference Vacation Calendar to Update Approver via Automated Workflow
Hi, I have an employee Vacation Planner sheet with a status column/formula that indicates whether an individual is currently on "PTO" based on today's date and whether it falls in the range of their vacation's start and end date. In a separate Smartsheet, we will be managing service tickets and certain types of requests…
-
Automation - One Email Per Trigger
Hello, I have got a very basic sheet setup where my co-workers submit a request via form, and when it drops into my sheet I have rudimentary automation set up to email me "when triggered". This all works fine and dandy. However, if someone submits multiple lines in quick succession, I get multiple lines wrapped into a…
-
Notification except if attachment are available
I want to be able to automate notification to certain users in case a row is modified, but only if this row does not have an attachment. How can I do it? I tried adding a condition to the trigger for notification, but the field "attachment" is not there, so I can't put a condition on the presence/absence of attachment. Any…
-
Request for new functionality: Automated entry of cell-completer
Hi, I love the new automation features (e.g. automated entry of dates into a column). I would really benefit from similar automation for population of a column for the cell-completer (i.e. the person who made an entry into a cell). The flow would be similar to this: Automation is set up and enabled John Smith makes entry…
-
Health status formulas and automation
Hi, is anybody able to help with automation formulas for the Health column? I'm very new to Smartsheet and struggling a bit! I'm trying to do the following: Green - Status='In Progress' and more than 1 week before end date, or status= 'Complete' Yellow - Status= 'In Progress' but end date 1 week away Red- Start date is…
-
Inconsistency with copy row automation
Hello! I am running into some issues when attempting to utilize a copy row automation. Sometimes the rows are copied to another sheet, and sometimes they're not. Here's a breakdown of my process... Sheet 1- approval workflow is automated upon form submission, records a date when approval is granted Sheet 2- utilizes a…
-
approval automation sending multiple emails
I have a smartsheet with a couple automation rules set up to email PM's about submittals. My "request an update" rule runs nicely and sends a single email to the PM with MULTIPLE requests when they click the form in the email. However, my "request an approval" email sends a single email for EACH item to be approved, which…