Statistical functions with if testing

Rkumar

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

Hello,

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.