Progress Bar Automation between 2 Different Sheets

Hi to all you brilliant Smartsheet Wizards! 🧙‍♂️🧙‍♀️

I saw a question on here regarding how to "automate a progress bar" and I thought that is perfect for my tracking: Automate the Progress Bar — Smartsheet Community

My problem: I want the progress bar in Sheet A under "milestones". But I want it to source the data from Sheet B. But Sheet B has the checked tasks in a column rather than a single row because I have 100s of individual projects with their own milestones.

Sheet A: Each INC No. is a separate project that could have 3 milestones or 20 milestones.

Smartsheet 1 - Milestone Progress Bar.png

Sheet B: I thought making a specific task sheet would work and I could connect the information via the progress bar in sheet A.

I was thinking of doing a Gantt chart - but I don't think it's necessary. I just need a simple "was this task done or not"

Find more posts tagged with

Formulas

Support

Project Management

Accepted answers

All comments

SPIPMO

JI @crokicki

Does Sheet B has a % complete column for every task? Progress bar should have a reference value (%) in order to automate the milestone progress in Sheet A.

Thanks

che -spi.pmo

Paul Newcome

Are you looking for a progress bar (how you start) or just a yes/no for if it is done (your last comment)?

crokicki

@SPIPMO - It does not. Do you mean for instance if the first 2 tasks are complete I would put 20% as the reference?

@Paul Newcome - Either works for me, but if it's already a progress bar I assume it would probably be easiest to just leave the progress bar full rather than change it to "yes"

Paul Newcome

Try something like this:

=IF(COUNTIFS({Done}, @cell = 1) = COUNT({Task Name]@row), "Full", "Empty")

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.