-
Copying a cell with an auto number from one sheet to another overwrites existing auto numbers
Hello, I'm using two intake sheets for different project types. Each intake sheet is populated by an idea submission form and the entries receive a unique number with an Auto Number column. So far so good. Situations come up where a project of type A needs to be moved to type B. We do this with a checkbox, which when…
-
Executing multiple conditioned automations with one trigger.
Hey Folks, Basically, I am looking to use an automation (or other tool) to check and fill multiple cells based off of a single checkbox. Specifically: When ticked, check Col 1, if Col 1 is empty, write HELLO. Then check Col 2, if Col 2 is empty, write HELLO. Then check Col 3, if Col 3 is empty, write HELLO. And so on. The…
-
Automations not being consistent - sometimes running, sometimes not
Kia ora, I've got an automation set-up on a sheet when certain criterion is checked on the row it will send an email to a particular person (with the data on that row). I've tested it numerous times to get it right and it's worked fine, however using the sheet today, it worked once, but that's it. I tried changing the…
-
Resource Management: Regional Public Holidays
Official Public Holidays in Resource Management are not helpful when team members work across different states or countries. The ability to define Public Holidays based on team member location (automatically would be best) is needed. The Location of each team member is defined in their profile. Use this to update the…
-
Automate a sql query of public information to merge with Smartsheet
Hello! I'm seeking steer on an automation. I am manually mining publicly available data (ClinicalTrials.gov) using a query of this database - - and I merge the results into my sheet via a data shuttle upon attachment to the sheet. At present, I do this about once a month (or whenever I think about it). I would like to…
-
Merged: Timestamp Automation
This discussion has been merged.
-
Copying a Checkmark Field from one to another on the same sheet.
Hello, I have a process set up where I pull data in from another sheet, and then I have a handful of Columns with formulas that will fill with a Check or Uncheck based on the information in the data that was pulled in. My goal was to be able to use these Checkbox columns to track processes, but since the columns are locked…
-
Improved User Auto-Provisioning
It would be great to be able to specify some additional options for user auto-provisioning: Have the ability to add auto-provisioned users to Groups automatically - Being able to add new users to an "All Employees" group automatically would mean they could have access to some resources by default. In my case, users…
-
Email alerts on reports?
We have 100+sheets that I have rolled up into a single report that contains due dates for tasks. I would like to be notified if any of those due dates are not met, without having to set an email alert on each of the underlying sheets.
-
Smartsheet Automation Sender/Reply-To email causing confusion
With reference to the above, I have recently tested the automation and it doesn't seem in-line with the above. I am the sheet owner, I created the workflow, but whether single user or multiple users who triggered the alert, it is showing my name as the sender. And there also inconsistencies at times which we do not…