- Options for creating a look up tool...
Hello! I am trying to think of all of the ways to create a look up tool in Smartsheet that can be accessed by non-Smartsheet users, without the non-Smartsheet users being able to see the back end. We will only be collecting the email addresses of the non-Smartsheet users and then returning the name and email address of…
- 复制表之间的工作流
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…
- Report Creation tool within a sheet
One of my most frequent uses of Smartsheet is as an editorial calendar for a weekly newsletter. I create a new sheet for every month of the year. Exiting a sheet and creating a report is not too much of a hassle but, it would be nice if I could click a button within a sheet that automatically opens a new page that is a…
- 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.
- Workflow enhancement - copy a column/cell to another column/cell
A workflow enhancement that is similar to the Change Cell Value. However, instead of changing a cell, copy it to another cell. Use case: I have a formula that calculates a date. However, I want to keep the initial value of the date and therefore, don't want to reference the date formula because it will change. A workflow…
- Automation Notifications if 10+ rows change
Hi All! Need some help with a specific Automation notification when a specific criteria is met. The automation I would be after would look something like this: Everyday 100+ lines of data are added to the sheet, this tracks a specific item. I am wanting an automation that triggers an email when 10+ of the same item for the…
- Bridge: Add Row module with empty cells
Hello - I am working a Bridge workflow to Get Row from a source sheet, and Copy Row with select columns to a target sheet. The workflow between the sheets is working great, but my question is that some row cell information will be blank from the source sheet going to the target sheet and thus my Get Row Cells Values come…
- 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,…
- Allow Missing Attachment to be a trigger or condition for Automations
Currently, automations can be triggered by an attachment being added or changed, I would like the ability to use a missing attachment as the trigger or condition for an automation. This would allow a form to have attachments as optional while allowing for immediate follow-up. It would also allow for follow-up when update…
- Workflow Administration in Control Center Global Updates
I would love to see the ability to create, update, and administer workflows in Control Center provisioned projects. A few use cases: We recently completed our implementation of Control Center and migrated our live projects into the new framework. Some of the blueprint templates have alerts configured and it would have been…
