Can I Use a Formula in an Automation Date Field
I have sheets that have several automations that key on a particular due date. The due dates change based on the first Monday of each month so they are never the same. I have a sheet for each month of the year. Each year I have to go through each sheet and change all the due dates to match a new due date for that year. I would love to be able to add a "Due Date" field to the Sheet Summary and use a formula in each automation to pull from this "Due Date" summary field. This way I only have to save it in one place on each sheet. Is this possible? I've not found a way to do it yet. Thank you.
Help Article Resources
Check out the Formula Handbook template!