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.
Answers
-
How exactly are you inputting the time?
-
its a value calculated from two dates (Finish - Start) and divided by 7, to have number of weeks. Example the cell would indicate 0.51 (being approximately took half a week. The column is showing the result of that formulation calculation.
-
You could use an AVG/COLLECT combo such as
=AVG(COLLECT(Duration:Duration, Assay:Assay, @cell= "X"))
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.4K Get Help
- 394 Global Discussions
- 213 Industry Talk
- 449 Announcements
- 4.6K Ideas & Feature Requests
- 141 Brandfolder
- 132 Just for fun
- 131 Community Job Board
- 453 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 293 Events
- 35 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!