Welcome to the Smartsheet Forum Archives
The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.
Alert based on Harvy ball or "last changed date" system column?
I have a harvy ball that shows the progress to completion on a task.
Is there a way to send a conditional alert to someone on the task line when the harvy ball gets to a 1/4 or 1/2 full? or even when it changes value (other than any change)
Also is there a way to get a tickle when a sheet is not complete and has not been addressed (updated) for two weeks? I have a "last changed date" system column but can't access it in the alert choices.