-
Automation: Value changes FROM and to
Hi, Currently as far as I know we can set an automation when a column changes to any value, Is there any way to set it if it changes From a value To another value? Meaning if a column changes from Blank or #NO MATCH to any value it should record a date. Or, if it changes from 10 to 20 it should Check a box. Thank you,
-
What is the Default data type for "auto-numbers"
I've created a "Client Database" using a sheet. We had 400+ rows of details input via an upload during the setup. Subsequent clients are added via a Form and the new client number is assigned via "auto number". In our project portfolio sheets I am using a Index Match formula to pull client groups and client name instead of…
-
Automation based on specific cell changes?
Hello everyone! I was wondering if there was a way to trigger automation based on changes made to a single cell as opposed to changes made across a whole row. If not, are there any plans to do this?
-
Use automated workflow to send an email to an external contact
Hi, I had a look through the existing questions, and couldnt find an answer to this, so apologies if it out there somewhere! we have a sheet where we log enquiries we receive as and when we receive them. In the log we capture the date the enquiry was answered, along with details of the enquiry and the response we provided.…
-
Automate Cell Linking??
I have an smartsheet "employee table" that contains employee names and employee IDs. I also have a smartsheet "activity" that logs employee activity via a smartsheet form. The goal is to pull the employee ID from the the "employee table" smartsheet and copy / input it into the Employee ID column of the "activity"…
-
How to use a smartsheet to update the form dropdown values in another smartsheet?
I have a smartsheet that contains employee names and employee IDs. I would like to use the employee names stored in this sheet to update a form dropdown list of employee names on a separate smartsheet that tracks employee activity. I was going to use data shuttle, however there is not an upload data from a smartsheet…
-
Contact List Components: build a contact via formula
This is probably a pretty common request but it's frustrating me on a project right now so thought I'd bring it up. My idea is that Smartsheet make Contact List components accessible via logic and object calls. For instance if: Smartsheet.Objects.ContactList(Firstname, Lastname, Email) So if you have a columns containing…
-
Rogue Automation? How to Investigate...
Hi All, This morning a rogue automated email was sent from SmartSheet to myself, a few coworkers and an outside collaborator. I have checked the sheet where this automation lives and it is scheduled to trigger one week after a due date in the sheet. I say the email is rogue because there is no February due date in this…
-
Tips and Tricks for Sheets
This is a general message, I am using Smartsheet for all my work purposes, making calendars and setting notifications, are there any tip and tricks that people have some across that they found useful/quirky/productive? A bit about the calendars: there are 30 or so all individual, each member of the company has control of…
-
Automation is running correctly, except for one person
Hi there, I have an automation currently set up with some simple conditional logic. Basically, I have a field that has 5 drop-down options. If one of the first 3 options is chosen, a group of people get notified. If either of the other 2 options is chosen, then that group PLUS two other people get notified. The bizarre…
