Counting how many times a milestone slips

07/31/18 Edited 12/09/19

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.  

Project_snapshot.png

Comments

  • Andrée StaråAndrée Starå ✭✭✭✭✭
    edited 07/31/18

    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 PARTNER & CONSULTANT / EXPERT

    Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

    W: www.workbold.com | E: [email protected] | P: +46 (0) - 72 - 510 99 35

    Feel free to contact me about help with Smartsheet, integrations, general workflow advice, or something else entirely.

  • I will try to make that work and get back with you.  Thanks for the prompt response.

  • Andrée StaråAndrée Starå ✭✭✭✭✭

    Happy to help!

    Good luck!

    SMARTSHEET PARTNER & CONSULTANT / EXPERT

    Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

    W: www.workbold.com | E: [email protected] | P: +46 (0) - 72 - 510 99 35

    Feel free to contact me about help with Smartsheet, integrations, general workflow advice, or something else entirely.

  • J. Craig WilliamsJ. Craig Williams Top Contributor

    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

Sign In or Register to comment.