-
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!
-
Combining SUM and RIGHT
Hello, How may I find the SUM of multiple columns by using the SUM function and RIGHT function? I am collecting the data via a Smartsheet form and will need to email out the call center representative's score to their managers. I am getting #UNPARSEABLE as the result. Can someone help correct me? A1, Customer…
-
What is the order of operations for workflows? If multiple run at the same time which is run first?
What is the order of operations for automation? If multiple workflows are scheduled to run at the same time which is run first?
-
Form wit multiple entries in different rows keeping first fields information on the following rows
Hi there, I'm creating a form that can have multiple entries, but each entry goes in a different row. I created the Host Application form with the following: Facility Name Assessor Name Candidate Name On the settings, I chose 'Send user to the link' > Then, I created the 'Candidates' List form', where only the Candidate…
-
Day & Week before reminder
Hello, I would like to set a day before and a week before reminder that references a Due Date column I have in my sheet and only triggers on weekdays. Is there a way to do this? Thank you for your help!
-
Copy to a different sheet when all complete
What automation is best in this scenrio: I have a lesson learned log on individual projects. I want entries to copy to a central version for review by management. The copy/move to a different sheet seems to be limited to a change to a single cell whereas I want it to copy when all cells (the complete row) are complete. Is…
-
Calendar/Form Integration and Automatic Emails
Hello! I work at a university. My team and I help coordinator several Dean's schedules and student meetings. The current process is extremely manual. Ex: Staff member is informed a meeting needs to be scheduled, staff member looks for openings, schedules meeting, sends confirmation email to the student and partner site…