Looking to add a percentage complete calculation

Options
azandy77
azandy77
edited 09/20/23 in Formulas and Functions

Hello,

I'm trying to have Smartsheet calculate the percentage of the project complete based on the number of checkboxes marked. I want to be able to take that figure and add it as a metric widget. I only have this created so far. =IF(Completed1 = 1, "Yes", "No"


Thanks

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!