Formula Question


In one column I have the assay type in one column (Assay X, y, X…) and in another column I have the time it took for this specific work. How can I write a formula that asks to do an average of the time it took for all of the occasion we performed assay "X". The different assays would be appearing on multiple occasion as different rows with each one of them having their distinct time.


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!