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.

Statistical functions with if testing

edited 12/09/19 in Archived 2017 Posts

it will be helpful to have statistical functions like Max, Min, Average etc combined with IF functionality like Sumif, Countif. Currently I have to create one column for first doing the if function in one column and then use statistical functions on the result column. When there are multiple fields it necessitates lot of unnecessary columns         I feel functions like MAXIF will be helpful. Is there any workaround possible?


  • Shaine Greenwood


    There isn't another workaround aside from creating additional columns with IF formulas then calculating MAX from the IF column return. When you have a moment, please use the Product Enhancement Request form in the Quick links section to submit your use case for MAXIF, MINIF, AVGIF, and any other formulas you'd like to see in Smartsheet directly to our Product team.

This discussion has been closed.