How do I get the % to stay at 100% and not 150%?

Options
Ashley Pierce
Ashley Pierce ✭✭✭✭
in Formulas and Functions
Percentage.png

How can I get the Completion Rate to only show 100% rather than 150%?

Tags:
· Share on FacebookShare on Twitter

Answers

  • Purnima Gore
    Purnima Gore ✭✭✭✭✭✭
    Options

    Hi Ashley

    I just had a look and it appears that this issue has been on the list since February 2018.

    I agree that we absolutely need to be able to add he maximum and minimum values on the axis. I have the same issue. I have completed items as they are going to 120%.

    I think product enhancement requests have been added so if anyone can find the one that was raised so we can vote on it, that would be helpful.

    ATB

    Purnima

    Purnima Gore

    Cierr Limited

    Your Time is Important, you want to Stay on Track, We can help you use the Right Tools

    https://www.cierr.com

    · Share on FacebookShare on Twitter
  • Lisa-B
    Lisa-B ✭✭✭
    Options

    This is a flaw for sure - I have a number of graphs showing 120% as the maximum and my Executives what it to be 100% - when will this be resolved - ideas?

    · Share on FacebookShare on Twitter

Help Article Resources

Create and edit formulas in Smartsheet

Formula combinations for cross sheet references

Smartsheet functions list

Categories

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!