I'm wondering if its possible to do a formula that has X task averaging A hours.

ZMinior

Is there a formula that would be able to pull from a Smartsheet that it smart enough to be able to pull from multiple columns. Ex below.

Say I wanted to pull the average amount of time (duration) for the "eat" task in year "2023", how would I go about this?

Nic Larsen

Try:

=AVG(COLLECT([Duration]:[Duration], [Task Type]:[Task Type], "eat", Year:Year, 2023))