-
Can you alert/send an email to contacts in a cell that have been entered via a form?
I have my alert settings to Unrestricted, but even so, it seems those who fill out our form cannot be notified since they are not users of SmartSheet. I am looking for a solution other than the "Send me a copy of my responses" option. TIA! 😁
-
Ability to create an automation where the trigger is a specific value in a specific cell changes
Automations are great and I think you can increase the functionality for this feature by allowing other triggers.
-
Customize the Approval Form
How can I customize which fields are shown on the form the approvers to see. For example, I have an automation set to seek approval from a leader. I only need the leader to see specific fields when they approve. Is there a way to select what is shown on the approval automation form?
-
"Alert Someone" Send to Contacts in a Cell NOT WORKING/Send to Specific People WORKING
I've ensured that all permissions everywhere are unrestricted. I've tried multiple emails in the contact cell, users with accounts, users without accounts internal to my organization, and users without accounts external to my organization. I have two actions, both "Alert Someone". Alert Someone "Send to contacts in a cell"…
-
When a row is "approved", change status cell to "ready to work"
Hi, This seems like a really basic question that I can't seem to solve: When a row is "approved" (the check box is checked) I'd like the status of only that row to auto update from "reported" to "ready for work". TIA for your help
-
Notifications not working
I created the sheet and set up the automation as below. however, it doenst trigger to send the notification for the current week unless I open the smartsheet. it still send out last time I open the smartsheet How do I make it send out every monday without touching the sheet??
-
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…
