Counting how many times a milestone slips
I would like to add a column that would count the number of times a milestone has slipped. My thoughts were to add a column in front of comments (see attached) and count the number of instances that the finish date has been edited. I thought of using the COUNTIF function, but unsure how to get the cell to count on a different cell.
Comments
-
Hi,
I would add a dropdown or a few columns with checkboxes and then sum them together. It's, unfortunately, a manual process to register when a milestone has slipped multiple times.
Would that work for you?
I hope this helps you!
Best,
Andrée Starå - Workflow Consultant @ Get Done
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
-
I will try to make that work and get back with you. Thanks for the prompt response.
-
Happy to help!
Good luck!
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
-
I have used Zapier for such counts. If I had to do it on more than a few Sheets, I would use the API.
Craig