automation for adding date?
So I'm fully aware of the automation to add a date when a cell is changed, but it doesn't seem to be working for me. Hoping someone might point out where I went wrong.
I have a grid of teams and members where I keep track of which members are complete, I'm trying to track when a 70% or more of the team is "done". I've made another grid which lists the teams, and have a formula to pull in what percentage of the team has finished. I've made a column of checkboxes that automatically check if 70% or more of the team members are done. I set an automation that inputs a date in another column if that checkbox changes to checked, but so far, I'm having no luck with it activating. If I force run the automation, the entire date column populates regardless of the checkbox column. Where am I going wrong?
Help Article Resources
Check out the Formula Handbook template!