-
Automation Workflow - Exclude Hidden Fields
I have a SmartSheet that has several hidden columns that drive other visible column values, conditional formatting, etc. I set up an Automation Workflow to send an update via email when rows are added or changed. The email that is sent from the workflow includes ALL the hidden columns, whether those values changed or not.…
-
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…
-
Sheet Connection
scope: I have several states working and adding every day into smartsheet sheets, those sheets are required to be seen / reviewed by the state managers, out of this information I want to create a daily updated sheet from this on a master sheet for CEO level. Client requirement: to see an overall update daily with the new…
-
Approval Workflow - Send to contacts in a cell
Hello, I am creating an Approval Workflow with "Unrestricted" Automation Permissions so that the approval request can be sent to any email. The Requestor is prompted to enter the "Approver Email" within the request form. When creating the workflow under "Request an approval" I have selected "Send to contacts in a cell" but…
-
Selection of form in automated update request
I want to use differnt forms to request task updates, depending on my defined user group. E.g. an external user shall only see basic infomation and update a few fields, internal user shall see all information and update all fields. How can I restrict fields in a form, by user group? How can I select a specific form,…
-
Create workflow off of date and time column?
Hello, I understand smartsheet cannot accomodate date and time in the same column. Is there a way to create alerts and workflow off of tasks with date and time in 2 different columns?
-
Copying Multipe Rows to a New Sheet based on the Number entered into one cell from the master sheet
Hi Everyone, I am trying to create a copy workflow where the value of 1 cell in a particular row will let the system know how many copies I need in my new sheet. For example, My master sheet will have columns for company, department, location, etc. and another column which says "How many employees". If I enter in 5 into…
-
Workflow to Sync Rows between sheets
I have 2 to-do lists with teams that I work with and I am trying to to simplify adding and updating my tasks to just one list. I've created a workflow to copy rows from one sheet to another but instead of creating a new row in the destination sheet as I update the information I would like for the row to be updated in the…
