-
Is there a formula for referencing a different cell daily?
I've automated emails to send out schedules to our field employees but their sites can change daily and I was wondering if there's a way to reference a different cell everyday so I don't have to manually change the site cell in the automated workflow.
-
Auto uncheck at the end of the day.
Is it possible to clear a check column using Automation. We are planning to use this as a Evacuation check list. We are looking to have it cleared daily (Overnight)
-
Approvals for multiple lines
I've seen this question asked a few times and I understand it isn't possible to set up a workflow to approve multiple lines as once, but a comment that has appeared as a workaround is to use a report to mark the lines as approved, declined, etc. I am relatively new to Smartsheet and don't understand how to make this work.…
-
Workflow incorporating "AND"
I have a smartsheet that consists of rows of information some 100 columns wide and am trying to set up a single workflow that says: When you reach "this date" Check these specific10 columns for each row and if any of them contain a number that is greater than 0 send an email to: this person if column 1 is greater than 0,…
-
Developer needed....
I'm looking for a developer to help a business with a business / operations set up and on going support. We currently use Smartsheet and want to extend our use of it - manage projects, flow, contact with clients, contact with consultants.
-
Auto populate data and allow customers to update
Hi! I work for a membership based trade association and I'm trying to build a form that would allow me to share profile information on file with our customers (member companies) and then allow them to update outdated information. For example, I would auto populate contact information, # of employees, etc. and they would…
-
Record a Date automation keeps updating to today's date.
I am using the "Record a Date" function to identify an Approval Date when the status of a request changes to "Approved." The automation does record the date once the status is changed. However, once the date is recorded, the automation continually updates the date to the current date. For example: If a request was approved…
-
Is it possible to to be notifed after an automated email is sent?
I've set up daily emails for our employee schedules but I'd like to receive notification after the automated emails are sent.
-
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…