Date formula question
Good morning, we have a sheet we are using to track leads. I've been asked to set up an automated update request to send leads that have a certain status out on the first business day of each month.
In the automated actions, there is no way to set a recurring update request like there is on the row-level update request. So I need to find a way to create a formula that will fill-in an update date in a date column that can be used to trigger the update.
Here is a published link to the sheet: https://app.smartsheet.com/b/publish?EQBCT=872f03d505b44ad58688db39b0ce0950
Thank you in advance for any feedback or suggestions.
Help Article Resources
Check out the Formula Handbook template!