How do I set up reoccurring Update Requests based on a date in a cell

I am new at being an admin for my company's Smartsheet. I have set up a number of automations, but I would like to set up an automation for a reoccurring Update Request to be sent out starting 60 days prior to a date in a cell.

I have a Start Date column, which have different start dates.

I set up a Date Formula column to set the date 60 days prior to the date in the Start Date column. Now I would like to send an update request (every Friday) beginning the week the date that is in the Date Formula column.

I seem to be hitting a snag. I can set up an automation Update Request only once based on the Date Formula column. Or starting on a specific date for the entire sheet. But I am unable to set up an automation for the reoccurring Update Request to start on the date that is in the Date Formula column. I don't know what else I can try. Can anyone please help me?


Best Answer

Answers