Trying to trigger an automation for when a date is months in the future it changes a cell value.

ksandoval

If the date is months in the future, it changes a cell value from blank to HOLD.

Andrée Starå

Hi @ksandoval

I hope you're well and safe!

You can use a Workflow combined with the Change a cell Action and have a Condition that checks if the date is in the future and not in the next (days).

Make sense?

Would that work/help?

I hope that helps!

Be safe, and have a fantastic week!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up, Awesome, or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

ksandoval

Thanks Andree!

Andrée Starå

Hi @ksandoval

I hope you're well and safe!

You can use a Workflow combined with the Change a cell Action and have a Condition that checks if the date is in the future and not in the next (days).

Make sense?

Would that work/help?

I hope that helps!

Be safe, and have a fantastic week!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up, Awesome, or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

Amber Eakin

Hi, @ksandoval - Are you looking for a column formula for that cell? You could use this:

=IF(Date@row > TODAY(+60), "HOLD")

You would need to change the +60 to however many days in the future you want, and it would be dynamic.

ksandoval

Thanks Andree!

Andrée Starå

@ksandoval

Happy to help!