-
Multiple pre-built Approval Columns not available for selection in an approval workflow
I am building a process that will have up to 6 different people approving an action. I'm building separate workflows to control the trigger as some are dependent on others: 3rd, 4th, 5th will all trigger simultaneously with a field condition and a 2nd approval value of 'Approved". I keep trying to build the separate…
-
Reporting on Workflow Automation
Hello, I have several sheets that have quite extension workflows set up on them. Is there any way to produce a report or print the sheet which details each of these workflows? Is this what the Workflow ID can be used for? At the moment you can sort the workflows and then go into each workflow individually to see the…
-
Log the date and time a cell changes to a specific value
Hello. I've got a sheet I've developed to track approval of purchase agreements. After an agreement makes its way through the approval process, I have the cell "Final Approval" display the words Agreement Final Approval, and the cell is conditionally formatted to red. The main users would like me to log the time and date…
-
Approval Workflow Emails
Hi, I have an approval workflow set up in a form I've created. The email "from name" that is sent to the approver is the name of the person who created the form though. Is there any way to update this? Thanks!
-
Approval Workflow
Dear Sir/Madam, Kindly note that email is not capturing while Approver forwarded to another user in absence of Approver. If Mr. Sam is approver for request # 123, Mr. Sam is in leave till end of month so he has forwarded approval request to his Personal Secretary Ms. Tina as a delegates approval. Tina approved the request…
-
Using Workflows to Populate Cell Values
Hi, I'm trying to use workflows to auto-populate a Date Column. Example: When "Work Order State" changes to "Scheduled" populate a system time-stamp in "Scheduled Date". Is this possible? Thanks, Quinn
-
Outlook custom emails
Hi, Is there a way for Smartsheet to capture Requests For Information from contractors and suppliers if they have a dedicated email address for a sheet? I'm new to SS so not sure what is out there. I know there is an outlook plug-in to push content to a Sheet but what if a team member just emailed 'abcdefg@smartsheet',…
-
Automation: If new line wasn't submitted for the last business day, then notify
I have a smartsheet that is populated by data it pulls from a form that's submitted daily. One of the columns is a date column, another is a location. I'd like to set up an automation that emails me when a form hasn't been submitted for the previous day. Logic: If yesterday was a business day and there's no new line with…
-
How do I prevent a reference to the tracker sheet on an Alert Someone workflow?
I created two workflows: Alert Someone 4x a month to send an email to specific people as a reminder to fill out a form AND an Alert Someone 4x a month to send notifications on an MS Teams channel. In both cases, it references the master tracker sheet. I only want my users to follow a link to a form I created for the…
-
How to block a requestor from also approving his own request?
Good morning SmartSheet Community! We currently have a form for employees to submit Internal Sales Order, in which they must add their functional approver (usually their manager). This request is then sent for approval to 3-4 people/teams. We have an issue with one type of request where the requestor is adding himself as…