-
Save As New Workspace / Copy Row Automation
It would make the world of difference if when you deploy a new workspace any copy or move row automations would update to the new workspace not point to the template.
-
Pulling data dynamically from standard project folders
We found a template for multiple projects that uses a standard folder setup to keep Reports, Project Plan and Dashboards for each project within its own project folder... allowing us to have the separate lists of tasks and RFI's, rollups organized for each project rather than a forever-growing list of entries from old…
-
Edit Saved Workflow not working
I am trying to edit an existing workflow, but when I go into Manage Workflows, and try to edit or duplicate a saved workflow nothing happens. I do not get any kind of error message, it just literally does nothing when I select either Edit or Dulplicate the workflow.…
-
Dashboard not updating after Sheet changes
For a number of years, our team has been reliant on a PDF Dashboard to issue to our clients. Recently, we have noticed that after new data is input into a Sheet, the Dashboard no longer reflects these changes automatically. Our system is programmed to work in the following manner. (A three-step process -…
-
Automation triggered copy one cell to another on same sheet
Hi , I would like to be able to "check" a box in col A which will trigger a copy of the content in col B to Col C (but not change value as long as the checkbox is checked) I want to use this to flag a specific line/task as one which is due data is important for me so I want to copy it to a column "important dates" but the…
-
Managing Multiple Weekly Update Requests
Hi - Wondering if anyone here can help. Our IT organization has a master source sheet tracking all the project requests for the team. Requests are made through a Smartsheet form which inserts a row on the master source sheet. As part of the development request, the PMO send out weekly automated update request to each of…
-
Create Automation Rules with API
It would be convenient if we were able to actually create automation rules via the api rather than just modify. It would also be nice if the API automation functionality was improved, it's pretty limited.
-
Automation Workflows to add multiple Multi-Select field values
Is it possible to have multiple automation workflows that will simultaneously or sequentially process to add multiple values into a single cell? Here's my scenario. I've got data that gets entered into a sheet that has the potential to be missing elements. The hope is that my users will correct those gaps, but once…
-
'Change Cell Value' Automation Has Stopped Working
Hi all, I have the below automation in place on one of my sheets. It was working for a short time, but within the last week it has completely stopped. For context, the 'Shot By CQ' column is formula based and automatically stars itself when conditions are met in one of my other sheets. This seems simple in theory, but I'm…
-
Random assignation
Hi, I'm trying to assign a task to one of my team members (there are four). Every time a new project is added to the queue, instead to manually add one of them, i would like one randomly chosen person among them four. Can you please help me to get this? Thanks in advance! Alberto