-
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…
-
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…
-
Workflow triggering from a cross sheet index match formula?
I currently have a smartsheet referencing data from another sheet using the cross sheet Index-Match formula. When I try to trigger a workflow when this referenced column changes, the workflow is not being triggered. I have tried "Copy a Row" and "Change Cell Value", neither work. I understand cell linking does not trigger…
-
Merged: Approval Flow support more than two buttons
This discussion has been merged.
-
Can I create an automation on a template in a toolkit?
Hello Smartsheet Community! My question is: Can I create an automation (e.g. to notify someone with a specific message) on a template in a toolkit that will carry over when new projects are created?
-
Missing Jira field in SmartSheet Workflow
Hi team, I am unable to add some fields though those fields are available within Create and Edit Issue screens. Those missing fields as in the red box of a screenshot. Can you help to look into this issue, please? Thank you!
-
Copy updated cell values of one sheet to another
Hi, I have two sheets with exact same columns. When any cell(s) value of row in sheet 1 is updated, then I want to update same row with unique identifier ID if existing in sheet 2 to be updated with new cell values as well. Please help how it can be accomplished. Example: Let say Price Per unit of Row 3 is changed in first…
-
Data from submitted forms
We are starting to utilize forms but i have no idea on how to link those forms to a spreadsheet I'm pretty sure it can be done through workflow but I'm stumped. I either need to be shown or a dumbed down version of steps.
-
Is it possible to make a work flow app
Hello, I am wondering if it is possible to create a workflow app that takes data from my sheet, and based on the value of one cell in a column, makes that row visible to another user so they know they need to complete that rows "job", and then with a click of a button on their part, mark it as complete, and it then moves…