% based on weight attributed to each column
Vinton Douglas
✭✭✭
I have 4 columns weighted as follows:
50% Academy
20% Together
20% self
10% Belieg
I would like a formula such that when the percentage is added to the respective column, it provides an average based on the weigh of whats attributed to each column.
Any help would be appreciated.
Best Answer
-
Hey @Vinton Douglas
Try this
=0.5*Academy@row+0.2*Together@row+0.2*self@row+0.1*Belieg@row
Will this work for you?
Kelly
Answers
-
Hey @Vinton Douglas
Try this
=0.5*Academy@row+0.2*Together@row+0.2*self@row+0.1*Belieg@row
Will this work for you?
Kelly
-
Works great. Thank you.
-
Thank you
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.8K Get Help
- 406 Global Discussions
- 218 Industry Talk
- 457 Announcements
- 4.7K Ideas & Feature Requests
- 141 Brandfolder
- 136 Just for fun
- 57 Community Job Board
- 459 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 297 Events
- 37 Webinars
- 7.3K Forum Archives