Calculate Average if another Range meets criteria

Katye Reed

Hello,

Any suggestions on the best way to calculate the average days if the item type is equal to quarterly? I have a drop-down menu that categorizes the activities based on frequency, and another column that calculates the days past based on end and start dates.

How could I find the average if the Item type is Quarterly?

Average by type.PNG

L_123

https://help.smartsheet.com/function/averageif

The above reference should help you out.

Katye Reed

Thanks, but I keep getting an error when I use this - invalid data type.

L_123

Lovely, they still haven't changed that. I thought they had. Oh well, there is a fairly standard workaround. Apologies for misleading you.

=AVG(COLLECT(Start:Start, [Activity Frequency]:[Activity Frequency], "Quarterly"))

Katye Reed

Sadly, I am still receiving an error - Invalid Column Name.

L_123

The column that the formula is in needs to be a date column. You have it as text/number or some other type.