Unable to get an avg percentage for some depends for a report

Options

I created a summary report that shows percentages for each task under high-level management. The issue that I am having is when I summarize the percentage column using average. The high-level manager does have a percentage, instead has a NaN.

The percentage column is an IF OR statement using quotes to hold the percentage.

I removed the quotes and percentages to see if I could use the number result and the percent format. But my 100s turned into 10,000% and my 50s turned into 500%. Now I am stuck and trying to figure out what to do to get my summary report to show percentage instead of NaN. Thank you for your response!

Answers

  • Nick Korna
    Nick Korna ✭✭✭✭✭✭
    Options

    Hi @JerryLouis,

    If you're wanting to use percentages instead of text, they operate on a 0-1 scale. For example, if you wanted 50% to be the result in a % enable column, then you would use 0.5. For 100%, 1. For 0%, 0.

    Replace the values in your nested IF statement and then you should be able to have your column set to %.

    Hope this helps, but if you have any problems/questions then just ask! 🙂

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!