-
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…
-
Merged: Increase Expiry Limit for Attachment Links Sent from Workflow Automations
This discussion has been merged.
-
Upcoming Tableau WDC 3.0: Timeline for Smartsheet Connector Update?
Hello Smartsheet Community, I am currently facing a challenge with the upcoming deprecation of Web Data Connector (WDC) 2.0, which impacts our integration of Smartsheet with Tableau. We have been using the Smartsheet-provided WDC available here: https://tableau.smartsheet.com/tableau. As I'm looking for guidance on how…
-
Parent Child Relation in Dynamic View
I was wondering if there was a way to display the parent child hierarchy the same way it is shown on the main sheet with just the data on the dynamic view of the sheet? I have a dynamic view where all completed and cancelled status projects show up, and would like them parent/child to be displayed as it is on the main…