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: https://app.smartsheet.com/b/publish?EQBCT=872f03d505b44ad58688db39b0ce0950

Thank you in advance for any feedback or suggestions.

 

 

 

 

 

 

Tags:

Comments

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!