Hi, I've noticed this issue in two of my smartsheet processes. I have an automation set up as follows: "When rows are added are changed and [Column A] changes to [Any Value], change cell value in [Column B] to "60" " I then set column B to be $ currency format. Up until recently, "60" changed to "$60.00" without issue but…
Please use UTC or a changeable time zone for columns which are system-generated. I have a sheet where I transform the "Created" column which is in UTC to a date in EST for readability. The discussion user however is in PST. That changes the "Created" column which in turn changes the transformed column. Normally, this would…
I saw that there were recent updates regarding email notification we set up through Automation. We can now choose "Send from Smartsheet Automation" and "Send from my organization". Currently using the option "Send from my organization" and then the messages includes "Links to sheet and specific fields" option on the "Alert…
This discussion has been merged.
Create a way to automatically notify an operator as they are updating a form and hit submit that their entries do not match and it's a failed audit other than waiting for an email notification and checking the sheet for conditional formatting. ex. Audit Form is for ensuring batch numbers match from 2 items. If the operator…
I’m running into an issue with a Smartsheet automation not triggering as expected. I have a Project Status Helper column (checkbox) that is a formula column. The formula checks if Project Status is blank, and if so, it checks the box (intended to flag new projects). New rows are being added via Data Shuttle. I have an…
We're using Smartsheet to track the number of vacancies and the subsequent recruitment process to fill them. Most of these vacancies are multiple openings for the same job role and we have how many openings on the sheet (e.g. 3x HR Coordinators). Currently, we're using a sheet to set-up the vacancy (settle on job…