-
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
-
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…
-
Message Only Notifications with Attachments
Hello, I am trying to send a notification with the Message Only setting while including an attachment that is linked to the row. The primary goal of this is sending the notification without sending a link to the full datasheet to an external contact. Any assistance would be appreciated. Thanks!
