Working Days Counter Based on State, Lock # when completed

Daniela Makowski

I am trying to create a counter that counts the number of days in work of a task, the counter only counts the days in work when the Scrum state of the task changes to sprint . I want the counter to stop counting when the state changes to done and lock that number of days in work (days in work from sprint to done) and still be able to display the number so that i can do averages for reporting out. 

This is what I have so far, it counts when the scrum state is 'Sprint-Fleet' or 'Sprint-Mfg' only; however when the state changes it doesn't count and goes to blank... any tips?

=IF(OR([SCRUM State]472 = "Sprint-Fleet", [SCRUM State]472 = "Sprint-Mfg"), TODAY() - [Sprint Initiation Date]472, "")

Andrée Starå

Hi Daniela,

Unfortunately, it's not possible at the moment, but it's a great idea!

Please submit an Enhancement Request when you have a moment.

The TODAY function will always update to the current day.

A possible workaround would be to use a third-party tool like Zapier or similar.

Would that work?

Have a fantastic weekend!

Best,

Andrée Starå

Workflow Consultant @ Get Done Consulting

Paul Newcome

Unless you were to manually input a date that it was changed to "Done". Then you could just add that in to your current formula.

 

=IF(OR([SCRUM State]472 = "Sprint-Fleet", [SCRUM State]472 = "Sprint-Mfg"), TODAY() - [Sprint Initiation Date]472, IF([SCRUM State]472 = "Done", [Completion Date Column Name]472 - [Sprint Initiation Date]472, ""))

Andrée Starå

Paul,

Yes, of course! There is a manual way! I always try to automate 



Daniela Makowski

awesome thank you so much!!!! that certainly helps

Andrée Starå

Happy to help!

Best,

Andrée

Paul Newcome

Happy to help! 

 

I always try to automate too, but I am limited to working within the confines of SS.