reminders sent more than 30 days but less than 60 days prior to an event

jherndon

I want to set up a reminder to occur 6 weeks prior to an event.  The pull down menu choices of timing give me a maximum of 4 weeks or 30 or 60 days?  How do I schedule it 6 weeks or 42 days prior to the event?

Thanks!

Andrée Starå

Hi,

You'd need a so-called helper column that for example, would have the formula to calculate the date or check a box if it's 6 weeks prior to the event date.

Would that work?

Have a fantastic day!

Best,

Andrée Starå

Workflow Consultant @ Get Done Consulting

Richard Rymill SBP

JH

Just base your alerts on a second date column that adds a number of days, eg 30/46/60 to the actual date. 

RichardR