I want to know when an approved campaign goes back in to revisions so that I can review it again. I have multiple other reasons to want to know when a campaign status changes and what the previous status was; e.g., trigger subtasks for team members, notify leadership etc.
I use the following statuses: planning, assigned, in progress, completed, approved, scheduled and launched.
and two nonsequential values (revisions, missing inputs) that can be used at any point in the process.
What I currently set up:
The status field is a single-select
An automation that captures every change in campaign status and populates another table
That status tracker table is linked to the campaigns table
The status tracker table has a 'status field' last modified date field
What I want is a way to compare the previous status field to the current status field so I can trigger actions based off of the new status. What I cannot figure out is how to connect the most previous status to the current status.
Any help would be appreciated!
