-
Rules and Alerts emails not sending
Has anyone else experienced issues with Alert emails not sending. We have an alert set up and it has been working but all of a sudden stopped sending on the 21st?
-
Populate Field Based on Checkbox Date
Is there a formula out there that would allow me to 'autopopulate' a field based on the date a 'checkbox' was checked. IE --> I have a Check Box to determine if a Project has been completed or not(if checked, it is completed), is there a way to autopopulate the date that checkbox was 'checked'? Thanks!
-
Cell linking effecting Last Modified date for whole sheet
I have a Main sheet with a cell that is linked to a log sheet to count total rows. whenever a form user adds a row to my log sheet it is updating the last modified date for all the rows on my main sheet. any idea how I can have this stop happening so I can send out a notification for any row that has not been updated in…
-
Cancel reoccurring update requests when complete (or 100%)
Hi All, I might be missing something, but I want my reoccurring update requests to automatically stop sending when the activity they relate too reaches completion. Anybody know how to do this? Appreciate any guidance you can give me. Mike
-
Email content
Hey guys, Hoping someone can help me out. Im trying to see if there is a template or a way to create a tab that lets you upload email content i.e. a content image plus word doc/text to a certain newsletter and the person who is looking after that newsletter gets a notification when content has been uploaded. Also the…
-
Manually send an attached file to a contact
Situation: * Each row of my sheet represents a different client's order and has that client's email listed in a contact-type column called, "Main Contact" * At some point in the process, I need to manually email just one of the many attached files in the row to the Main Contact. I do NOT want to send all the files.…
-
Custom email notifications
We use smartsheet to track enhancement tickets that is logged with us, I would like to setup a "custom" email that is triggered for every phase a ticket might go to, example move from phase 1 to 2 then a custom email gets trigered with our companys custom info and details around the ticket. ? We have an outside logging…
-
How to Format Alert/Actions Subject Line in Templates
Hi, I've created a project schedule template that I will use for multiple projects throughout the year (avg. 100). This template has a total of 4 different alerts/actions. The template will default to a subject line like this one for a notification: - "Changes to Schedule #1: Project w/Professional Print2: Notification"…
-
Alerts for deadlines- Need help
Hi! I am trying to set up an alert for deadlines, but only if a box is checked- not for the whole sheet. So people can basically choose- yes, I want alerts for my deadlines, or - no, I don't want alerts for my deadlines. Right now I have a check box column set up- yes and no. So, I want it so that If the person checks the…
-
Notification without changes in row or column
We have a sheet that track onboarding activity for new clients. Two date columns in the sheet are Follow-up Due and Follow-up Actual. I would like to send a notification or reminder to the assigned employee on the Follow-up due date if the Follow-up Actual is blank so they are only receiving notifications about open items.…