Need help with a complex formula

Attempting to write a formula in a sheet summary field. Is it possible to write a formula that looks for particular rows based on the text value in one column, and then get the AVG of the numbers in a different column on those selected rows?

(ie. If the value in column Task is "Work Order Received", find the average of the Duration column on those rows across all projects on the sheet)

I've tried a bunch of different variations and keep getting different errors. Anyone ever written a successful formula like this?

@Paul Newcome , I will never not tag you in formula questions LOL

Kelly L. Gabel


Tech-Savvy Academy



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!