-
Column Formula Alternative?
I have people entering information into a sample request sheet using form that allows the user to select multiple types of tests they would like to have run. The form populates "Sheet 1" and I'm using automations to create multiple lines on the destination "Sheet 2" using this solution: In the Source Sheet: Count of Rows:…
-
Teams Integration with Workflows
Hi, We have Smartsheet setup with MS Teams and Smartsheet sends alerts to a smartsheet specific channel. However, when I am building a workflow and add my organization there are no teams displaying in the drop down. We talked to MS and everything looks correct on the admin side. Does this feature actually work? If so, how…
-
Work around for Data Shuttle not recognizing identical data
Hello! This is pretty hard to explain but I am hoping someone can help me with this dilemma: I am using Smartsheet to build a tracking system that monitors where field project workers are showing up on a weekly basis. I get the job addresses as a spreadsheet from another department. Since I am working with hundreds of…
-
Update status in another smartsheet
I have an asset register, each with a unique asset number that also holds a status (In service, out for repair, decommissioned) I also have an asset damages log where an asset is reported as faulty or damaged and is sent for repair. If unrepairable it will then be decommissioned. My question is....... how to I update my…
-
Duration Column with Formula/Dependencies
Hello, Currently, I use a Text/Number column for task duration. I have a workflow set up to change the duration of each task depending on the urgency (either urgent or non-urgent), which is calculated using several weighted questions in the Sheet Summary that populate either a 0 (non-urgent) or 1 (urgent). This setup…
-
Can I establish a form workflow that builds on each other for the same request?
Hi all, I'm looking to establish a 3-part workflow that will have 3 forms that will build off the initial request. Here's my scenario/steps: Step #1: User A submits an intake form. Step #2: Once that intake form is submitted, it triggers an alert/workflow to Owner A (owner of this process) to complete another form that…
-
Alert Workflow removing external link
Hi there, This may be a silly question as im just wrapping my head around smartsheet capabilities, however i have an alert workflow which triggers and the main goal is to provide a link to the correct sales landing page in my external website. As seen in the screenshots below i have created a dynamic link within the sheet…
-
Assistance pulling information from one sheet to another automatically
Hello, SmartSheet Community! I could use your help. I have created an example of my problem below. The actual sheets have many more columns. Sheet A needs information sorted by Person Name; Sheet B has information sorted by Pet Type. Sheet A - This is where I would like information to be filled in automatically based on…
-
Personal Workflow Automation Library that sheets can reference as needed
I'd like to be able to build my own library of workflow automation and be able to "apply" selected workflow automation directly from the Project Plan Smartsheet. Also be able to share my library with others in my account that they may include into their own library so they do not have to reinvent the wheel. Advantages: 1)…
-
Automated Workflow Trigger
Is there a way to set an automated workflow trigger based on one specific task rather than any time ANY task changes? I'd like to have the completion of one task (when checked as Complete) trigger a start date being added to a new task. Then I can set a trigger for an email to be sent to that Assigned Person that the Start…