joe taylor
edited 12/09/19 in Smartsheet Basics

can i set a notification that is driven by a date and a name. ie i have a date column with a date range for my local school term, showing weekdays only. my next column is a recurring set of names, and finally my third column is a column titled 'tasks'.

what i want SS to do is to send the person in column 2 a notification every time their name appears in column 2, say 1 day before the date their name is against that date, to remind them their task is due in 24 hours time.