I'm trying to find the percent of sites are dead.

Options

I have 3 sheet with a summary for each developer. Sheet 1 is current, sheet 2 is completed & sheet 3 is dead. Each has the same summary for developer to count how many row they are listed on. I'm trying to figure out a way to get a report or widget that will give me the percent of sites that die and percent are live. Below is screen shot of a report was was able to get but I'm stuck here. Any help our direction would be greatly appreciated.


Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!