I have a SmartSheet where some rows have attachments and others do not. I would like to check a cell on specific rows and have SmartSheet automatically send an email to the contact for that row with a copy of the .pdf attachment for that row.
Specifically, I have a column entitled "send to contact" that can either be checked or unchecked. When the column is checked, I would like it to trigger sending the attachment for that row to the email address of the contact for that row.
Any suggestions?