Workflow automation for email sending

hello all, I need to create a workflow for the below scenario. I will have many rows of data around 500 sometimes. there is about 30 columns also. I have a date column for which I want the workflow to work based off of. if the 10 days before that term date is reached, I want Smartsheet to send an email to a contact but not email per cell. I want it to include all the rows whose date is met. then another day another group of rows would match the 10 day criteria and I want Smartsheet to send a new email with all the details for those rows (by details I mean the column data of those rows). Can someone please help me. I know it is a bit complicated but really cannot have it send 1 email per row.

Can you also guide how it would work if we could have one email sent per row?

Thanks

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!