Sign in to join the conversation:
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!
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
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
I have tried to set them as Edit - can share, Edit - cannot share, and commenter and nothing works, they cannot add data to the sheet. Does anyone have a solution?
The Issue My project-specific metadata sheets use INDEX/MATCH formulas that reference the Intake sheet using a Project ID. When the automation archives rows from the Intake sheet, these formulas break because they can no longer locate the source data. Example formula: =INDEX({Project Intake Name}, MATCH([Project ID 1]@row,…
Two of my five automation workflows appear to have just randomly stopped performing on April 9, 2026. All others, which would/are performing as normal and would be functioning alongside the other workflows, are functional and appear to be untouched by this 'bug'. Help I've tried all that I can think of.
