Date formula question

Kelly Ospina
Kelly Ospina ✭✭✭✭✭
edited 12/09/19 in Formulas and Functions

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:

Thank you in advance for any feedback or suggestions.









Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!