Automation ignores working days?

Matias Korsgaard

Hi all,

I have set up my sheet to send out a reminder to "assigned to" 3 and 7 days before a task is due respectively.

Today a co-worker received both of those reminders at the same time and day. Do you have any suggestions as to how I might fix this? (I have defined working days to be Monday to Friday)

Thank you in advance

Andrée Starå

Hi @Matias Korsgaard

I hope you're well and safe!

Can you maybe share some screenshots? (Delete/replace any confidential/sensitive information before sharing) That would make it easier to 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!

Matias Korsgaard

These are the automations I have active for reminders. For some reason Smartsheet sent out both of these on the same day. Which does not make any sense.

Andrée Starå

@Matias Korsgaard

Have you checked, so it triggered for the same row?

Are the dates driven by any formulas using the TODAY function?

✅Remember! 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!

Matias Korsgaard

@Andrée Starå

Yes it triggered for the same row, the dates are not driven by any formulas but manually entered by the project manager

Andrée Starå

@Matias Korsgaard

Have you checked the Cell History and Activity Log for clues about what could have happened?

Could the PM have changed the date and then changed it again?

Matias Korsgaard

@Andrée Starå

Thank you for all your inputs, I found out that someone had made a copy of the sheet and changed a date in there. I have fixed the problem now but thank you so much for helping

Andrée Starå

@Matias Korsgaard

Excellent!

You're more than welcome!

✅Remember! 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!