-
How to integrate/sync several sheets into one?
I have a team that is working on several projects. Each team member has a sheet that lists their tasks. How can I link/sync each member's in-progress tasks to show up in a separate sheet? I'd also like to be able to modify and add tasks in the master sheet so that the changes and additions can appear in the assignee's…
-
No editable fields in Automated Workflow email
Hi, i have two workflows created (update requests) and only one of them is showing the fields as editable when the email link is opened.. but both are exactly the same, only asking for different fields to update. One column is a dropdown, the other free text... The selected fields are not locked or containing formulas or…
-
Add 'subscribers' to automations to receive "A workflow has become invalid" emails
Hello! We've been trying to dig around to see how to do this but the results seem to reference a menu we don't see. Is there a way to add emails (we are hoping to add a distro) to the automations alerts that get sent when something is unable to work? We tried duplicating the workflow to see if we could then add the email,…
-
Automation for entire workspace?
Is there a way to setup one automation that is used on all sheets within a workspace? I would like to be able to edit one automation instead of editing the same automation on 30 separate sheets that are in the same workspace. The sheets have the same columns. When the completed checkbox is checked, the approval automation…
-
Using automation to update a date field
I know you can use the record a date automation to record the current date in a field, but is there any way to update a date field to a chosen value? We have a date field for the finishing of a task - date finished. If the user selects a Release value from an other drop down column, we want the date finished field to…
-
Adding Names from Sheet 1 to Sheet 2 with Counter update and handling duplicates
Good afternoon, I'm trying to achieve the following without success: I have Sheet 1 that as forms are submitted a Names column is filled. I have Sheet 2 with a Names and Counter columns When a new submission occurs, I would like to get that name from Sheet 1 and add it to the Name column in Sheet 2 if it doesn't exist…
-
Move Row/Copy Row Automation flowchart
Hi Smartsheet, I'd like to have a high-level Smartsheet view that shows, in a visual, the "Move Row" and "Copy Row" automations from one sheet to another. This would be extremely handy when communicating to management or onboarding new employees to existing Smartsheet processes. Additionally links directly to the sheet on…
-
Automation alert- Receive a notification about MaxVal six months before its renewal date.
Hi there, I wanted to confirm if my automation is correct. Alert Goal: Receive a notification about MaxVal six months before its renewal date.
-
Automated Backups - SharePoint
Hello team, I have scheduled weekly backup in Smartsheet and I was wondering if it is possible to have the backup file automatically moved to a SharePoint folder. At the moment I need to download the file every week and and upload it to SharePoint. I am hopping that there is a way to automate this process. Thank You.
-
Auto set Baselines
Is there a way to configure smartsheet to automatically set baselines at certain milestones in a project? My thought with this is my project plan would automatically set a new baseline at 3 different milestones, I would end up with 3 sets of baseline date columns. This would easily allow me to go back on projects and see…