Find cell value with 99%

Hi,

Is there a way to find and count every cell which equals 99%?

Best Answers

Answers

  • Andrée Starå
    Andrée Starå ✭✭✭✭✭✭
    Answer ✓

    Hi @David Clunie

    I hope you're well and safe!

    Yes.

    Try something like this. (replace with your column name)

    =COUNTIF([ColumnWith99%Value]:[ColumnWith99%Value], 0.99)
    

    Did that work/help?

    I hope that helps!

    Be safe and have a fantastic week!

    Best,

    Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

    Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

    SMARTSHEET EXPERT CONSULTANT & PARTNER

    Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

    W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35

    Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.

  • Hi Andree

    Thanks for the recommendation; however, this has not produced what I expected.

    I have a separate sheet that grabs the information from my master to populate a dashboard. It firstly looks a reference called level which gets the row that I require if data = 1(I basically have level identifiers to show hierarchy within a branch of a grandparent,parent-child projects)

    I am then looking for the Percentage column within that row, which is rolling up all subtasks to reach an overall % of the project completed.

    I have at least 33 projects in my master planner at 99%, but I cannot find them?

    It can find projects at 100% if I change the value to 1 or subsequently find 50 projects not started at 0% if I default the value to ,0).


    =COUNTIFS({ Levels}, =1, {Percentage}, 0.99) FInds 0 projects and there should be 33

    =COUNTIFS({Levels}, =1, {Percentage}, 1) Finds 1 project

    =COUNTIFS({Levels}, =1, {Percentage}, 0) Finds 50 projects



  • David Clunie
    David Clunie ✭✭
    Answer ✓

    Hi Andree


    I figured this out my % wasn't actually 99% . It was, in fact, 99.40% when increasing decimal places.

    =COUNTIFS({*Levels}, =1, {Percentage}, 0.994)

    Thanks

  • Andrée Starå
    Andrée Starå ✭✭✭✭✭✭

    @David Clunie

    Excellent!

    Easy to miss!

    You're more than welcome!

    SMARTSHEET EXPERT CONSULTANT & PARTNER

    Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

    W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35

    Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!