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

edited 12/09/19 in Archived 2017 Posts

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


This discussion has been closed.