AVG(COLLECT

Options

Hi @Paul Newcome

Seeking your assistance please with the below which results in #unparseable. I'm looking for the average number of days on all rows between a Created Date column (Date submitted) and a date column (date you need result back?) and the assigned person.

I've tried and failed with a number of other formulas but of all I think this is on the right track but I'm not getting it. ie

=NETWORKDAYS(DATEONLY(AVG(collect(([Date Submitted]@row,-[Date you need result back?]@row, [Assigned To]:[Assigned To],"Travis")))

Regards

Cheers.

Forever forwards Backwards never.

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!