Welcome to the Smartsheet Forum Archives


The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.

Help with Sumif not recognizing criteria as a percentage

09/29/17 Edited 12/09/19

Hi all,

Trying to create a field that will tell me what percent of a list of values have exceeded 80%.  

=SUMIF([Goal Progress 2017-2018]3:[Goal Progress 2017-2018]7, ">80%", [80% Value Forumula Use]3:[80% Value Forumula Use]7)

Goal progress is a percent value i.e. 100% or 45%

80% Value is the number 1

Smartsheet is not recogonizing the criteria "80%" nor does it recognize ".8"; it will work with a whole number. 

Am I stuck?  Any way around this?

thanks - Frank

Comments

  • Not 100% sure if this is what will work for you.  Format the column as %.

    =(COUNTIF([Goal Progress 2017-2018]3:[Goal Progress 2017-2018]16, >=0.8)) / (COUNTIF([Goal Progress 2017-2018]1:[Goal Progress 2017-2018]16, ISNUMBER(@cell)))

    Good Luck

    Shawn

     

  • J. Craig WilliamsJ. Craig Williams Top Contributor

    Don't use quotes when your criterion is a number.

    Craig

This discussion has been closed.