Avgw based on a criteria
I'd like to apply different weightings based on a staff members role on the staff sheet. I have a weightings sheet that defines the weighting for each task per role.
I can't work out how to write an if statement that says, if the staff role (staff sheet) matches the staff role (weightings sheet), then use this row of weightings.
Would love some assistance
Comments
-
Hi Sally
I believe a VLOOKUP function is required for this. If you type =VLOOKUP( then a Smartsheet helpful function builder will open, you will need to use the "reference another sheet" link to refer to a lookup table on the sheet with all the weightings on and use a column count to return the value that you require.
One thing to be mindful of when using a VLOOKUP function is that the table that you are using to match and return values from (i.e. the weighting sheet) the column to match against (i.e. staff role) will need to be next to the value you want returned. (ie weighting) You cannot link to non-contiguous columns in a lookup table.
Happy to help further if you need it.
Kind regards
Debbie Sawyer Consultant & Training Manager
Smarter Processes mean happy people in successful businesses
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.8K Get Help
- 410 Global Discussions
- 219 Industry Talk
- 457 Announcements
- 4.7K Ideas & Feature Requests
- 143 Brandfolder
- 136 Just for fun
- 57 Community Job Board
- 459 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 298 Events
- 37 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!