I use Supermetrics to send monthly reports to my clients. I usually schedule them to email on the 1st of the month, but would like to avoid sending on weekends and instead send on the closest weekday.
For ex. if the 1st of the month is a Sunday, I'd like the report to send out on Monday the 2nd.
I played around with using conditional emailing that refers to a cell which will display text if it's a weekday. I think this method would prevent emails from going out on weekends but not sure if the email will just not send that month or seek the next possible date that fulfills the condition.
thanks for contacting us. You are actually the first one to request this kind of a feature but no matter, it's a good idea. We have set this request on to our tasklist and if it's possible to accomplish, you'll get a notification about it as a pop-up when using Supermetrics.
I'm unfortunately not quite sure if you could use conditional emailing for this.