We have a sheet that has the insurance information for each of our franchises, including renewal date and email address of the Franchisee. We'd love for Smartsheet's alerts to send a reminder to the Franchisee 60 days before renewal, however, I don't want to share the sheet to every Franchisee.
Does anyone know of a work-around for getting Smartsheet to send a reminder to someone that isn't shared to the entire sheet?