I'm trying to create an automation that tracks data from two columns. We have a "planned publish date" and an "actual publish date." I'd like to have a way to track how frequently records are published within a week or so of the planned publish date.
Is there a way to set up reporting in an interface for this? Or an automation that can compare the two dates and perform an action if they're within a certain timeframe to one another?
I haven't tried writing my own script, but I'm open to that, as well as other suggestions. Thanks so much!