Is there a way to send a daily notification when a task is not complete? The way my sheet is set up is the RYG dots are automated depending on the due date, and based on those dots, notifications get sent (Yellow is the due date, Red is overdue).
Now that smartsheet permits emails to outside users my ability to use the sheets has greatly increased! Unfortunately I am running into an issue when trying to send emails to company generated distribution lists. I am not sure if it a security feature my company has or an issue with smartsheet.
As is possible with notifications, is there not a way to set which columns are included in a reminder? As you can see from my screen shot using a sheet I've created with many columns, I have no use for the reminder because I can't read it.
I have a sheet where the RYGG is automated based on the due date (overdue=red, due date +2=yellow, the rest=green). I then set up the alerts ("Send a notification") so when the status turns yellow one email goes out, and when it turns red, another one gets sent out. I've played around with this