How to show % complete compared days in a year

Hello, I'm new to Smartsheet and I've built a few widgets but I'm currently having trouble with one I'm trying to build.

I'm trying to create a widget to show the percent completed of a project compared to the year completed. I have several projects that are needing to be added up to show a % and want to compare that with the percent completed of the year.

EX: I've completed 30% of the 20 projects and we're only 22% completed with the year. Can we create a widget to show that comparison?


Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!