What does "in the next 45 days" mean in an automated workflow condition?
I am trying to figure out an automated workflow where the trigger is everyday at 8am and the condition is where a [Date Column] is in the next 45 days. I have many rows in the sheet that each have unique dates and emails to contact when 45 days prior to that date is reached.
My question is: does "in the next 45 days" mean that it will only send out one notification when 45 days hits? Or will it send out a notification each day at 8 am after the date is within the 45 day mark?
If it is the latter, will adding in an and condition stating "and where is not in the next 44 days" always solve this issue?
Thanks in advance,
Help Article Resources
Check out the Formula Handbook template!