-
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
-
how can i sync dates in a column with formula?
Hello, below, I will explain to you the calculation of the termination notice period before the expiry of a contract and the sending of the reminder e-mail to the responsible person according to this notice period; 1- In the first step, I enter the end date of the contract and the notice period on a daily basis. 2- The…
-
Auto-populating sub-tasks from Form.
Hello. I have a list of tasks, assigned to different people, that have to happen each time a new topic comes up. Ideally, when a user submits those topics via a Form, I would like that list of tasks/assignees to auto-populate as sub-tasks below row of information that was submitted from the form. Is that a thing that can…
-
Can an email template be built in Smart Sheets that is sent out to a DL?
Can an email template be built in Smartsheet that can accept free form text in certain fields and also be able to be emailed out in the G-Suite to a DL. The other condition would be to be able to reuse the sent email message and be able to send subsequent email updates using the same email thread in the G-suite. Not sure…
-
Send email reminders when lack of update
How do I create a workflow to send reminders to the row owners if no changes happened to the row in the past week?
-
How do I set up a workflow to notify someone if a predecessor task has been completed?
I am currently trying to develop a project plan sheet, and I am wanting to be able to notify someone when the predecessor task was completed so they know they can start working. For example if John has to do a Data Source Identification and validation but he can't do it till Mark has converted and cleaned up the data I…
