-
Create workflow off of date and time column?
Hello, I understand smartsheet cannot accomodate date and time in the same column. Is there a way to create alerts and workflow off of tasks with date and time in 2 different columns?
-
Copying Multipe Rows to a New Sheet based on the Number entered into one cell from the master sheet
Hi Everyone, I am trying to create a copy workflow where the value of 1 cell in a particular row will let the system know how many copies I need in my new sheet. For example, My master sheet will have columns for company, department, location, etc. and another column which says "How many employees". If I enter in 5 into…
-
Workflow to Sync Rows between sheets
I have 2 to-do lists with teams that I work with and I am trying to to simplify adding and updating my tasks to just one list. I've created a workflow to copy rows from one sheet to another but instead of creating a new row in the destination sheet as I update the information I would like for the row to be updated in the…
-
Workflow Attachments to a Non-Shared Recipient
I have a workflow that, when triggered, goes to a recipient not shared to the underlying sheet. Is there a way for that person to be able to see the comments and/or attachments via the email notice without me sharing the sheet with them?
-
Sending An Update Request after 30 Days
Hello! I'm trying to send an update request to be alerted during the following time periods: 30 days after the initial row was added 60 days after the initial row was added 90 days after the initial row was added I have an "entry date" field to build off of to serve as the date the row was added. Is there a way to do this…
-
Automated email subject line text
So, if you automate emails (workflows) and forgo customizing the message, the email title is autogenerated as follows-- For Alert Someone: Changes to [title of sheet]:[primary column text] For Update Request: Update request for [title of sheet]:[primary column text] However, when you customize the message, you can assign…
-
Workflow prevented from Running
Hi, I created a sheet which will receive various incoming rows from other sheets. And on this sheet I have a Column "Max" with a MIN formula which turns to "Yes" for the Oldest row. And I have created a workflow that moves the row to a different sheet for the row that has "Yes". Once moved the next row will turn to "Yes"…
-
How do I create a automation workflow in a report?
I managed to create a workflow in a report but I am now unable to get to the existing one to edit it OR create a new one. There was a pop up that got me to the automation workflow page to create the first one but I can't get the pop up to come back or to get into an edit view. I confirmed in the activity log of the report…
-
Multiple/Varying approvers for form
Hello, we're trying to automate the approvals process for one of our forms that's currently in word document form. Essentially the form would be signed by different supervisors, deans, and VPs. We are looking to get the form to smartsheets, have the form be able to determine which supervisor, dean, vp it would go to, and…
-
Salesforce-like Workflow/Templates
Hi All - I'm pretty well versed in SmartSeehts, but trying to help my company implement a Salesforce-like SmartSheets approach - to save cost. To be clear, I know there is a integration available with Salesforce, but we do not work with them as partner. I'm simply interested in creating a very scaled back, yet similar…