Creating Report Workflow Automation that goes out on the 3rd Friday following a Monday


Basically, I can only use weeks where there is a Monday in that month before the 3rd Friday. So the native function of picking 3rd Friday will not work for this scenario. I have seen lots of help for Monday's but am not sure how to program this one.

I need to send out a report reminder to owners the 3rd Friday following a Monday every month. And then trigger to send that report to the manager the following Friday.

Thanks for your help here!



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!