% Rool-Upon another sheet
I have created a construction schedule where i have many lines of of tasks that apply in a mixed format to different subcontractors. Each task has it own % value. I have created another sheet where I have listed the Subcontractors and am trying to roll up the %of every line (associated with a specific subcontractor into a single % on this sheet. I have started off to with using the formula =SUM(COLLECT) and that seems to work, But i need the average not the sum. I have tried =AVG(COLLECT), but with no luck. Maybe I am not using the AVG correctly?
Any ideas?
Comments
-
What is the actual AVG(COLLECT()) formula you are trying to use?
Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!
-
=AVG({Sheet - CF ES Timeline Range 2}COLLECT({Sheet - CF ES Timeline Range 4}, {Sheet - CF ES Timeline Range 1}, Vendors1))
-
This is what my formula looks like and i have no idea if it is right. Diving into new territory here
=AVG({Sheet - CF ES Timeline Range 2}*countifs({Sheet - CF ES Timeline Range 2})COLLECT({Sheet - CF ES Timeline Range 4}, {Sheet - CF ES Timeline Range 1}, Vendors1))
-
Are you getting an error?
Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!
-
it returns #UNPARSEABLE.
It seems to work fine with SUM but not AVG
-
Try using =AVG(COLLECT({Range of numbers to be averaged}, {Criteria Range 1}, Criteria 1, {Criteria Range 2}, Criteria 2))
Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!
-
I tried that and got #INCORRECT ARGUMENT SET...
=AVG(COLLECT({Sheet - CF ES Timeline Range 2}, {Sheet - CF ES Timeline Range 3,Vendors1}))
-
Paul I re-did it and got it to work thanks for all your help!
-
Excellent. Happy to help.
Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63K Get Help
- 379 Global Discussions
- 212 Industry Talk
- 442 Announcements
- 4.6K Ideas & Feature Requests
- 140 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 302 Events
- 33 Webinars
- 7.3K Forum Archives