Rows Not Copying with Checkbox

RyKlo

Hello all,

I am currently building a dispatch calendar/tracker app for my company. The idea is simple, if any task requires the assignee to be at the location, check the box labeled "Onsite" and the task is copied to the calendar sheet. The issue is, checking the box does not copy the row.

If I run the automation manually, it works. If I change the trigger to "When Any Field Changes" and IF "Onsite is Checked", it will also work. But this method will flood the Calendar sheet with tasks any time any change is made.

Any suggestions?

Kerry St. Thomas

At first glance, this seems like the automation would be set up correctly. There could be other things that interrupt that automation from running - consider evaluating how many additional automations exist with "run on trigger", and also look at the other things that could happen to possibly interrupt the automation.

Since a workaround exists, consider how you might be able to use that workaround. You say that you can run with the "If 'Onsite' is checked" - is there a way you can check the destination sheet to see if the move has already occurred? If you use anything like a RowID number, or a ticket number, or some other unique identifier… can you add a helper column to reference that other sheet to see if that unique identifier exists (and if it does, to check a second box) so that you can update the condition for your workaround "If 'Onsite' is checked AND OnTheCalendarAlready is unchecked" or something along those lines.

Whatever you decide to do, good luck and happy Smartsheeting!