-
Time zone discrepancy in Automations
Hello! Something strange has happened - my Smartsheet profile is set up for AZ time zone, and my workflows have followed that. However my Automation workflows switched to Eastern time today, so due to the time difference they all went out incorrectly. How could my Automation workflows run off a different time zone than my…
-
Workflows - Streamlining Multiple Change Paths
I recently learned that I could have multiple change paths, and I was thrilled, no longer duplicating and changing for each criteria! But I am stuck on this one. Below is one of many workflows. The user will enter the Workstream (Train and Resources), and then the PM field will assign a person. I want multiple conditions…
-
Is it possible to add the current date for an email alert?
I am trying to add the current date when sending out a weekly notification. As part of the customized message I would like to add the current date in the subject field/line. Is that possible?
-
Recurring workflows based on date field in sheet
Hi, currently my options are - run once from a date field and run recurring based on a specific date but it would be really helpful to be able to initiate a recurring workflow from the date populated on a row. I have investigated some of the community suggestions for helper columns but I have up to 6 actions on a row that…
-
Cross Referencing Data Across Sheets
I've read several threads on this and tried to figure out solutions but am still stumped. I am creating a workspace for managing events. I have vendor lists with their rates and a planning sheet with the number of staff we need and which activities will be booked, etc. I'm trying to create an expense sheet where I can have…
-
Adding rows in existing sheet if multiple selections in a column exist
Hi Smartsheet-Community, I previously have been searching for a workflow which does the following: I'd like to achieve within one sheet that as soon as multiple assignees are selected from the respective dropdown list, one or more rows are automatically created below, which copies the content of the above row and splits…
-
Allow display of destination sheet full name in the Edit Automation dialog when moving copying rows
This is a simple request to allow visibility to see or display the full name of the destination sheet in an existing automation. Here is the use case: 1) I have created an automation whose action is to move or copy a row. 2) The name of a destination sheet that is selected is longer than what displays in the Edit…
-
How to get result from a child workflow back to the parent workflow?
Hi all, I have a parent workflow which calls child workflow with state name "get_workspace_id". Inside the child workflow I do some data processing and eventually I want to pass the result of Javascript back into the parent workflow. The data reference of the result is:…
-
Trigger and execute on different sheets
Hi, how do I tie a workflow from one sheet to trigger an action on another sheet? Example, Sheet 1 has the trigger (Checkbox) that initiates a form on Sheet 2 to be sent out. Hope I can and thanks in advance! dw
-
Editing the Auto-Message Form (Approval Workflow)
Is there a way to remove fields from the email request when setting up an approval workflow? Right now the approval request displays all the fields from the sheet and I would like to only display the fields the approver would need to see.
