Currently, in an automation we can set the value of a date column to today. We need to be able to set that column ONLY if it is blank, otherwise leave it alone.
Enhance automations that set values to support a new flag “Only If Blank”
When we move an item to the active sprint, we want to record the date it was moved there. If it gets bumped into the next sprint, our is set so when the status changes to “Next Sprint”, the item moves to the new top group [active sprint], and increases a “# of active Sprints” counter so we keep track of how many times it got bumped. That same automation fills in the “1st Active” date; obviously, we don’t want it reset each time an item is bumped since it’s the “1st active date”, and can be used to help determine how long the item has been worked on (in combination with the close-date when the item is marked “Done”).
Side-Note: I realize the “Timeline” column seems attractive for this, but there’s no way in automations to set the start, and end, dates in the timeline… the “date created” doesn’t apply here, since we have tasks on the Sprint board that are just cued for future work, and the create-date for those doesn’t accurately reflect when the work begins.