Automation Alert: Sends Duplicate over the Weekends

Options

Hello Smartsheet Peeps!

I have an automation set to alert specific people when a form is filled out. The automation is set for every day starting at 3 pm for forms that are dated for today's date.

This works fine except on the weekends, it sends out the forms that were filled out on Friday (sent first on Friday, then Saturday, and again on Sunday), so this is sent triplicate when obviously the date of the form is not = Today!

Can someone tell me how to fix this?

The column noted in the automation (see screen shot), ZZ Today's forms is suppose to flag the forms that are completed today.

=IF(Date@row=Today(),1,0) Puts a star in the col if date is today.

The Date column is populated in a form by the user.

Any help would be appreciated. Thank you in advance,


Lisa



Best Answers

Answers