-
Merged: Adobe Integration
This discussion has been merged.
-
Merged: Outlook Add-In
This discussion has been merged.
-
What’s the best method to add new automated workflows to existing projects?
Is there a way to use Global Updates to add automation rules to active projects? We are under an enterprise plan with control center I want to add several new automation rules to all active projects (200+) I do not want to do this manually for every active project. Any recommended options would be appreciated. Example Use…
-
Issue moving rows to another sheet
Automation to move rows with 'approved' status and 'move to archive' selected. This time, put a filter (Status=Approved) on and checked the 'move to archive' box. Status for ALL rows was changed to approved and all rows were moved to the inactive sheet. Reviewed this with Smartsheet - found nothing wrong. Had to pull a…
-
Send individual tasks to assignees.
I am able to make a report with a list of tasks that are filtered as I need. I have an upcoming tasks report, and I have an ending and overdue tasks report. I can send this report out daily or weekly. But this isn't really want I want. I want my guys to get an email tat only consists of tasks that they have not already…
-
2 tracker sheets, merged into one resource sheet?
Hello, I have two sheets, one is a fabrication tracker that tracks different jobs in our machine shop, and we have a design tracker that tracks current designs being worked on. I would like to combine both trackers into one resource tracking sheet that shows [Name] [Job #/ Design #"] [Role] [% Occupied]. Image below is…
-
How to have multiple sheets show active items from a master sheet containing statuses?
I have a master sheet and want to feed multiple other sheets information from it. Master spreadsheet: is an employee roster, listing all employees and their status (active, inactive) Sheet 1: has a list of required training and training expiration dates Sheet 2: has a list of company assets assigned to each employee I want…
-
How do I automate the creation of a project schedule from a form submission?
Hoping someone might be able to help me figure out this workflow: Form is submitted requesting a new project with the following information: name of project, requested go live date, assigned project manager This form submission triggers a workflow that will automatically pull a project template, inserts "name of project"…
-
Automatic project creation and reporting
Dear community, I have a scenario which gives me quite a headache. I would like to create a form which will be populated by the project requesters for creating projects in Smartsheet based on a set template. The form will have multiple fields. Once the form is submitted it will have to trigger an alert/reminder for…
-
Send automated email days before a date
Hello - I figured out how to send an email before a specific date but now I can't get it to only provide the information on the row with the current date. For example - I would like a reminder sent out 3 days before, then 2 days before, then 1 day before a date on the sheet. In the email I'd like the topic for that week to…