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.

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"


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!