-
How can I notify staff when an assignment in a contact column changes?
I have a sheet set up with a contact column so I can assign staff to a request. This assignment is automatically triggered based on request type. When the staff are assigned to the new row, I set up an automation to notify them via email of the request. This is working well. However, sometimes the assignment is changed…
-
Is there a way to 'automate' the filling of a DATE column via a formula?
Hi Community, My scenario: I am using a MIN/COLLECT formula to pull the earliest date from a list after a set criterion is met. I now want to have the same field 'lock-in' the date when another criterion is met, column x = "Scheduled". I am unsure if this is possible without creating a circular dependency. I did think to…
-
Can I automate emailing attachments?
I have an approval automation set up but it does not send the actual attachments when "alerting someone." Is it possible to create an automation that emails the files that have been added to rows? If not, has anyone found a workaround? I've seen others post the same problem, but I haven't found a solution yet. Thanks!
-
How to use Smartsheet's legacy resource management function to highlight conflicts and auto change
Hello, apologies in advance if this appears to be a rather basic enquiry, however, I'm not familiar with Smartsheet's legacy resource mangagement tool. I've had an enquiry from a colleague who has a Gantt chart sheet showing his team's tasks (as below). He's wanting the sheet to be able to add holidays for people and for…
-
HELP: sending automated notifications to multiple contacts in a cell
Hi Folks Is there a way to send an automated email (via workflow) to multiple comma-separated emails in a cell ? I have tried, but so far have failed. Nothing seems to happen when I trigger the workflow. Any help would be appreciated.
-
Capture modified date and time stamp
Hello. I have an system column that records modified date and time I also have one that records when the entry was added to the Smartsheet. We have 4 hours to respond to a new entry. What I would to do is when the status of a row changes to reviewing it would record the date and time stamp then we would use a formula to…
-
Changing the name of Sender - Emails?
Good Afternoon Smartsheet Community, How can I change the Sender name of the emails? Currently its saying "my fullname" via smartsheet automation@app.smartsheet.com" I don't want my name displayed in all the emails it's sending as I currently create reports.. so every report automation it sends it out as if I am sending it…
-
What happens when a trigger is linked to two automations?
I have two automations. 1) One automation is triggered when "Dropdown" changes to any value. When the automation is triggered the effect is different depending on the conditions in the automation. If "Checkbox" is checked then certain cell changes happen, if it is NOT checked, different cell changes happen. 2) The second…
-
Increment Conditions date(s) along with Trigger date
The trigger date increments weekly. The conditions date should also. I enter notes daily throughout the week. The following Monday I want the previous weeks notes sent to X to review the previous week.
-
Autofill cells based on data in other cells
Is there a way to autofill a cell using data from other cells as a trigger? For example, our projects are assigned a number (MonthNumber) in one cell, and we have a another cell that says Month. This serves two purposes for us - the count the projects per month but also to indicate what data to pull for our reports. Is…