-
Add Increment/Decrement to Automation Change Cell Value
Sometimes, it would be helpful to have a means of keeping track of a count related to automation. For example, if I keep sending a reminder email on a regular basis, I would like to have a cell that counts how many times it gets sent. It would be easy to do if Change Cell Value had this an option.
-
COUNTIFS- CONTAINS/FIND/HAS
Set-up: I have a data prep sheet that references a master sheet and some other sheets so it is easier to set up a dashboard. I have a list of departments in one column (Column5), and the count formula in the next column. The formula works when there is one department listed in the reference but not if there are multiple…
-
Help Needed: Workflow not triggering
Hello! I am new to Smartsheet as of last month. I found a website showing me how to send a notification when a predecessor's status is setup to "Complete": https://www.ignatiuz.com/blog/smartsheet/notifying-a-task-owner-when-predecessor-gets-completed-in-smartsheet/ Here is my setup: Row ID Column: Predecessor Copy Column:…
-
Automation 'Send to....'
Hello, I know I can send to a specific cell reference and I also know I can send to a specific user. But can I send to a specific cell reference on a different sheet? The reason is I have a sheet that has a number of team members that are required to accomplish tasks, but the PM lives on a "Teams" sheet and I would like to…
-
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…
