-
Workflow Automation - Activate or Deactivate
Is there any way to achieve Activate/Deactivate the workflow automation via programmatically using python or any Smartsheet API available to do. Have gone through the API documentation and couldn't got anything helpful related to my requirements. Should not open sheet and manually click the activate/deactivate the workflow.
-
How to send alerts with link to the sheet WITHOUT sharing changes?
I have a smartsheet that includes automation to alert users when the sheet is updated. We want for emails this triggers to include a link to the sheet, as most users won't work primarily from smartsheet, but we cannot allow users to see the email address of the user who made the change for security reasons, and therefor…
-
Update requests - Send 1 update request for multiple rows to the contact that is listed in sheet
Hi everyone, Here is my issue. I have a sheet of sales people that are from multiple different companies that tracks their YTD sales numbers. I want to build an automation/workflow that sends one update request with a form to update ALL of that contact's producer with one click. So if one of my partners has 10 sales people…
-
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…
