Automations
Discussion List
- Hello! I have an automation that is supposed to be running whenever an index-match returns a checkmark to change a cell value. However, this automation has not worked and I don't really understand why…
- Hi Smartsheet, I'm looking to remove an automation Copy Row with another process and am looking for ideas, suggestions, help. Currently I'm using the Copy Row automation to drive data into an approved…
- There's been a few times now that I started creating an automation and it wasn't able to find the thing I wanted to reference or there was a minor issue with a reference and I had to completely discar…
- For most users that have been in our Smartsheet account before, the format of the email address changes from "first.last@email.com" (even if they don't set up a profile) to "First Last". It still appe…
- I have nice little script to iterate through hundreds of sheets and update contact fields that lack a display_value, so that names consistently show up instead of email addresses. But there are 'recor…
- I want to create an Automation that triggers when the "Actual Start Date" is greater than the "Expected Start Date" without using a helper column that stores the value of this comparison. Is that poss…
- So I'm trying to create a formula or create conditional formatting for attendance. Every 1 Unexcused Absence within 45 days is 1 Occurrence that must be documented with the employee. Every 2 late arri…
- Hello, I want to generate a report for for the sum of a dollar value received in a month across various business units. for example: in February, McDonalds 1 credited $800, McDonalds 2 $300, Mcdonalds…
- We're exploring ways of using PROOF as a way to get approval on requests. The Proof screen only allows the reviewer to select Approve or Require Changes. If we have the reviewer click on Require Chang…
- In response to a Trigger, I'd like to perform two actions: Change cell value Record date However, when I attempt to add the second action, I get this message: Selecting this action will remove its sub…