We use SS for task / acrion lists for various teams, projects etc. and reports to consolidate everything into a single action list for the individual. We use Alerts to remind people.
How could I stop the Alert sending if the item is marked as complete - we use a drop down list for the item status - In Pogress, On Hold, Complete etc. We cannot delete the date as we need this information.
Ideal would be configuring Alerts to (not) send if COLUMN = VALUE
Thanks