Workflow based on date in a Sheet

Sherry Fox
Sherry Fox ✭✭✭✭✭✭

I am trying to set up a new workflow based on our company's quarterly calendar. I would like to have the workflow generated 30 days prior to the end of the quarter. I have created a sheet that lists all this information. I was thinking I could make it dynamic by using a formula in the Main sheet that is looking for the closest date AFTER today. This way the cell would always populate the new date as the quarter changes. But the trick is setting up the Workflow based on a cell in a sheet rather than something I type in. Is this even possible? Below is a screenshot of my Quarterly calendar that determines the date 30 days from the end of the quarter.

Sherry Fox

Business System Data Analyst

Del-Air Heating, Air Conditioning, Plumbing and Electrical

EAP | Mobilizer | Automagician | Superstar | Community Champion