How to have Percent Complete for two columns?



I'm using the “New Hire Onboarding Template” that my team has expanded on. We added another checkbox column, and I'm hoping to have it be included in the % Complete section as well.

Below you'll see the current formula that “came with” the template. How could I add the “Delivered” column to be included in this? I tried replacing the second “Ordered” in each section with “Delivered” but that gave me an error.

Any help is appreciated, thank you!



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!