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
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