What does "in the next 45 days" mean in an automated workflow condition?

Don12345
Don12345 โœญโœญโœญ

Hello,

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,

Don

Screenshot 2023-08-31 105923.jpg


Best Answer

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!