-
Emails are not reliably going to my users
I have a sheet that connects to several dynamic views. One one of the dynamic views, the (unlicensed) user enters their network ID. The sheet then grabs information from another sheet to pull in email addresses for the user and their manager. There is automation that is then supposed to send email summaries of the…
-
Where is the best place to find help with Power Automate Integration
I happen to be the power automate guru for my team, which isn't saying much. Problem I'm trying to solve: when a cell updates (based on certain target columns), extract that info to a SharePoint list (or some other repository). Why? We have several different project tracking systems and want to consolidate info into one…
-
Formula: CountIf
Here's the situation: I have seperate source sheets for each function (Human Resources, IT, Finance, etc.) that syncs with data mesh (copy data) to a master sheet. However, sometimes rows get deleted from the source function sheets and then our master sheet still has the deleted row on it. I'm trying to have a checkbox…
-
Copy a range of cells under a parent or ID number to another sheet
We have a wide range of purchase orders which can be created for any job from 1-50. There are about 6 different PO groups I would like to pull data from and assign them to their individual projects in their corresponding rows. Is there a function where I can call the parent and it will copy the parent and children…
-
Form: Change "From" on Automated Form Submission
Hello! My team at work recently created a form with an automated email response to confirm to the recipient that their submission was received. When this email is sent, however, it reflects the name of the owner of the sheet. I am wondering if it is possible for us to change the name to something generic for our team,…
-
Linking contacts from sheet A to sheet B
I am trying to connect contacts from Sheet A to a workflow automated message from a form in Sheet B. Is something like this possible? Sheet A is a database of people listing names, skills, locations, emails, etc. Sheet B is fed by a form, I would like new rows to trigger a workflow to send an automatic message to a subset…
-
Automated Workflow - Alert only specific email addresses
We want to reduce the amount of notifications that consultants receive. However, the clients would still like to get notifications. Is there any conceivable way in a multi-select contact column to restrict notifications to only specific email addresses? To clarify, is there a way to restrict notifications (alert…
-
Automation help: how to email alerts to a list of contacts in a separate Smartsheet
Hello, I'm trying to set up an automation to send an alert to email addresses that are in a separate Smartsheet. My first Smartsheet is set up to collect the results of server upgrades. I then need to email these results out to a sizable number of contacts that are in a second Smartsheet. This list of contacts can change…
-
How to automatically move Parent & Child tasks to new sheet
I love the automation to move rows to an archive sheet once completed. Is there a way to move the parent and child projects together? This would only occur once all child project have been completed.
-
Attachments not attaching through automation email
I am trying to set up an automation so that when a row reaches a certain stage, an email alert goes out. In that email, I wanted to include any attachments from that row. I have done multiple tests, and sometimes the attachments are there and sometimes they are not. I have ensured that the attachments are uploaded prior to…