-
Automation: "Copy Rows to Another Sheet" Isn't Working
Hi, I am the owner of a project that has several Smartsheets. When someone (owner/admin) changes the "Status" column to "Req. Not Met," I want the row to copy to another Smartsheet. I set up this automation. Then, I updated the "Status Column" (in five rows) to be"Req. Not Met" and saved it to trigger the automation. Next,…
-
Conditional formatting for dates that are X amount of time in the past
I have a sheet where I would like one column of dates to be conditionally formatted to show if the date is greater than 5 years in the past. For example, once a record is greater than 5 years old then it must be archived. We would like to easily see when this occurs or be able to create a workflow to move them to another…
-
Data Shuttle Workflow Triggered by a Workflow
With the various amounts of ideas in the community and potential implementations already in progress, who knows if this idea might become redundant at some point. But from what I've seen so far this doesn't seem to exist just yet. I think being able to trigger a Workflow in Data Shuttle based on the execution of another…
-
Why does the entire sheet copy instead of just row?
I have set up an aumoted work flow- so that only rows check for at risk will get copied into another sheet. Instead the entire sheet is getting copied there. How do i restrict to rows only?
-
Translation Services
Seaking the ability for smartsheet to operate like many of the technology platforms, and have advancements, by allowing Forms and cell data to have translation possibilities . This could be on a form, that has a non english speaker the abilities to have automated translations of the text to their native language. Other…
-
Prevent users unsubscribing from automation workflows
It should be possible to prevent users unsubscribing from workflows as these can form part of a process notifying users or work/tasks etc. These users have been setup, they have not subscribed so they should not be able to unsubscribe.
-
Update Sheet/Cell via e-mail
Is there a way that a cell/sheet can be updated from an email? In my search, some seemed to think that a sheet is related to a specific email address, that when emailed with the correct format to declare column/row/cell, the chosen contents would end up on the sheet itself. Is this possible?
-
Copying Workflows between Sheets
In my operational work I use Sheets as Action Trackers for all the countries we are implementing my project. When I was tracking about 5 countries I got the idea to create workflow that if any task is assigned to me the line is automatically copied to another sheet that is actually my Kanban Board so in one place I can see…
-
The ability to omit blank fields in email notifications
When sending alerts and requests through automation, we currently have the option to send a message including either all fields, specific fields or the message only. For my particular organisation(and i would imagine many others), none of these options work. We have dynamic forms that build themselves based on answers and…
-
Automatically Sort Rows in Sheets
As rows get added & cell values change, it would great if we could automatically sort them in the sheets themselves instead of having to set up reports. Adding the ability to do this in a workflow would be a fantastic addition. Right now we have to do it manually.