-
Date & Timestamp a specific cell change
Hello, I am very new to Smartsheet and I am working on a project tracking sheet. We have the following statuses in a cell: Unassigned; In Progress; Completed; Cancelled; On Hold When a request is submitted this automatically triggers a 'Created Date' column that logs the date/time of creation. I would like this to be…
-
Does changing the prefix of an auto numbering column stop a row from transferring to another sheet?
I have two sheets; one is an originating sheet that has an auto number column. For this sheet, I designated the prefix of 'WO26' for the numbering convention. The 2nd sheet is a 'dumping' sheet that started off blank; due to the addition of the rows transferred from the originating sheet, corresponding columns have been…
-
Group Notifications
I would love to see the ability to group/sort my notifications and automations on sheets for ease of duplication.
-
Development Environment for Production Change Development
Hi all, I have a solution that I've pushed out to production but now there are changes being asked for. I've duplicated my workspace as a way to build out and test changes safely. As I'm beginning to work thru solving the changes in this duplicate/dev environment I'm seeing the amount of time and potential for error it…
-
Merged: Track what was changed in the workflow automation configuration.
This discussion has been merged.
-
I want to send automated email to "assigned to", from a sheet, but only one reminder email vs mutlip
I have title, "assigned to" column, status(task 1), due date (task 1) columns, status(task 2), due date(task 2)…it goes for at least 10 tasks. The conditions to trigger the emails are, trigger 2 days before due date(when status is not equal to completed) and leave weekends trigger on due date(when status is not equal to…
-
Using forms to update current information in Sheets? Or another way to automate this process?
I have a form that we use to onboard new users. In the form, we would fill out information such as: contact name, position, department, manager, etc. Now, I want to use this same form and create a logic that would go something like this: Is the user "Current" or "New"?. So then the form displays certain fields depending on…
-
Smartsheet Automated Emails changing custom subject line
Good Morning, I've have several workflows setup to send out emails that are triggered by dates. I'm using the Alert someone and I have setup specific subject lines in each out these, based on the time frame of a requested completed date. This morning, I received a "Reminder: Smartsheet Name" email that was sent to all who…
-
Decreasing a set number when a name appears
Hello! I am trying to create a formula for assignments where I can set a number (3), and when a name appears in a sheet, that number decreases for each time the name appears. I also currently have a formula where I have the number of times a name appears / 5 (we have 5 days of the week displayed each week so while the…
-
Automations Inactive - Still Sending Alerts
We have a sandbox sheet duplicated from a live sheet for 6 months now. The automations on the sandbox sheet are 'inactive' as we don't want any alerts being sent out while we run testing. However, just recently, email alerts have been sent from the sandbox sheet to the contacts and we know this for sure because the link in…