Move item to new group if value in mirrored column changes

[Bill.D (Bill Dezell)]

Hi all.

I’ve been trying to make this work for a while now, and I have it close, but not quite right. The situation is that we have multiple locations that can all have one of three statuses. Waiting, Active, and Done. These are tracked on their own board and broken down by state. I wanted to have the status of each location on the map, but since the map pulls the color of the pin from the group color, that won’t.

My solution was to make a board where the group names were Waiting, Active, and Done, then set up an automation to move an item to the proper group once it’s status changes. This doesn’t work because a mirrored status column cant be used to trigger an animation.

So, I used a formula column to hold the value of the mirrored status column, but I can’t seem to get it to trigger either.

Currently, I’m using three filtered views to show (for example) any items that are either Active or Done in the waiting group. I also have views for the Active and Done groups, and just cycle through them through the day to move anything that changed. Is there some automation I’m not seeing that will do this?

Thanks.

[BiancaT (Bianca Taylor)]

Hey Bill,

You can actually workaround this, simply by adding an additional status column to your board.

This automation (accessible via the automation templates centre) supports mirrored columns as a trigger:

This way, you can use this automation to trigger the change in that additional (native) status column:

To then trigger the item to move to the relevant group:

You can even hide that additional status column if it gets too cluttered!

Let me know what you think

[Bill.D (Bill Dezell)]

Thank you!
That worked, but I don’t see what the difference is since they both start “When Status.”

How does it know to allow the mirrored status the first time and not the second, and why can’t it just allow the mirrored one regardless, since the mechanic appears to be in place?