-
Is there a way to duplicate a line with slight modifications to one cell?
I'm trying to find a way to duplicate a line based on data from another cell. For example, if I have a line that includes A, B, C, and/or D in a list in one cell, I'd like to make duplicate lines where the Primary column name is changed to {Primary column} - A/B/C/D, while all other data from other columns is preserved.…
-
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 -…
-
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…
-
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…
-
Automate SharePoint Permissions to Dashboard Access / Sharing
This might be far reaching, but I was wondering if anyone has ever attempted or if there is even functionality to create a flow in Power Automate that shares a dashboard/workspace based on an an employee's email that was added to a permission group in an internal SharePoint site?
-
How can a free user view a document via an automation?
We have documents attached to a sheet and have created automations to alert internal and external members when they are available to view and download. However, they are unable to see the documents attached to the sheet. They currently have Viewer access to that sheet--does that need to change? And is there a way to attach…
-
Can I set up an automation to archive a project from within a sheet inside the folder project?
We're looking for a more efficient way to archive our projects. I was wondering if is it possible to set up an automation inside a sheet (Let's say inside the Project Charter template) triggered once a box is checked by the PM to archive the whole folder and disabled the automations from other sheet. Any one has done…