-
How to auto send an Excel spreadsheet only when sheet changes are made?
We have set up automated workflows for a Smartsheet and its associated sign-up form that we've created. Current state: We have a team who receives an hourly notification from the sign-up form if there are any changes to the form. The email contains a link. What we want: The team prefers to receive an exported Excel…
-
Do managed resources get email alerts?
I think the answer is no - but would a managed resource receive any email alerts when given assignments in Resource Management?
-
Smartsheet automated alert using Outlook Mail Group email ID: HELP needed
We are setting up alerts via automation and using an Outlook Mail Group email ID (CSIHOpExTeam@iqvia.com). This is NOT sending emails to outlook like usual. Has anyone been able to get this to work? Do we need to have our Smartsheet Admin do anything on the backend? We are doing this in case the person in charge of acting…
-
Use Smartsheet instead of email correspondence
We've been using email to submit and correspond RFI's to our Architects. This has proven to be a nightmare. Is there any way that I could use Smartsheet for this back and forth correspondence capture? I've created a RFI form that can be submitted to the Architect for approval or additional comments, however, when they…
-
Conversation notifications
When I @mention myself from a second account I get a notification in Smartsheet and by email. If I post a subsequent conversation message without an @mention then I don't get any notification. How do people keep up with conversation threads with no notifications without explicit @mentions? I am used to threads in Slack…
-
Return value if a cell in the same row has highest value in the column
I'm working on an email campaign and want to see which issue has the highest open rate. If a value in Column C has the highest value in the column, return the value of Column A in the same row. I'm stumped. Can anyone provide this formula? VLOOKUP seems like the obvious choice, but I don't know how to reference a MAX…
-
Notification when a specific task changes
Hi. I would like to configure workflows or notifications so that if something changes (say a conversation) in a particular task, then the people who are listed in the notification column will get an email notification. We are going to assign tasks to team members, so not everyone will want a notification when every task…
-
How would you set up a notification when a call has a certain amount or above ?
I'd like to receive a notification when a cell has reached any amount above 50 000$. I can set a notification when a cell has reached a specific amount, but I need any amount above 50 000$.
-
Datamesh Immediate Timing/Contact Email Address
Hi, Any suggestions to increase speed of "Immediate" in Datamesh? Today, immediate seems to be at least 4 minutes. What can I do to speed this up? Datamesh source and target are the same sheet. (Pick 1st Match, Copy Data Over, Update Immediate) Data is being entered through Dynamic View. Datamesh is copying a contact field…
-
Unsubscribed by mistake
Hi One of the users in my team has Unsubscribed the automation message by mistake. How do I turn this on again for her? Also, how do I know how many of my users have unsubscribed themselves in the same manner? Thanks