SharePoint Lists: Populating a picklist column based on the values from multiple columns

%3CLINGO-SUB%20id%3D%22lingo-sub-2761262%22%20slang%3D%22en-US%22%3ESharePoint%20Lists%3A%20Populating%20a%20picklist%20column%20based%20on%20the%20values%20from%20multiple%20columns%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2761262%22%20slang%3D%22en-US%22%3E%3CP%3EHello%2C%20so%20the%20issue%20I%20am%20trying%20to%20resolve%20for%20is%20this%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI'm%20currently%20building%20a%20resource%20allocation%20list%20in%20SharePoint%2C%20which%20has%20a%20split%20by%20percentage%2C%20by%20resource.%20I'd%20like%20to%20see%20if%20there%20is%20a%20way%20to%20have%20a%20fourth%20column%20Populate%20the%20%22Winner%22%20%25%20and%20based%20off%20the%20percentage%20calculation%20populate%20some%20pre-defined%20text%20based%20on%20those%20allocations.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20may%20not%20be%20explaining%20it%20well%2C%20so%20please%20see%20the%20below%20table%20for%20an%20example%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CTABLE%20width%3D%22277px%22%3E%3CTBODY%3E%3CTR%3E%3CTD%20width%3D%2293.0781px%22%3E%3CP%3EName%3C%2FP%3E%3C%2FTD%3E%3CTD%20width%3D%2274.4062px%22%3E%3CP%3E%22Winner%22%3C%2FP%3E%3C%2FTD%3E%3CTD%20width%3D%2249.9688px%22%3E%3CP%3ELOB%201%3C%2FP%3E%3C%2FTD%3E%3CTD%20width%3D%2241.3438px%22%3E%3CP%3ELOB%202%3C%2FP%3E%3C%2FTD%3E%3CTD%20width%3D%2241.3438px%22%3E%3CP%3ELOB%203%3C%2FP%3E%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20width%3D%2293.0781px%22%20height%3D%2230px%22%3E%3CP%3EJim%20Bob%3C%2FP%3E%3C%2FTD%3E%3CTD%20width%3D%2274.4062px%22%20height%3D%2230px%22%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FTD%3E%3CTD%20width%3D%2249.9688px%22%20height%3D%2230px%22%3E%3CP%3E50%25%3C%2FP%3E%3C%2FTD%3E%3CTD%20width%3D%2241.3438px%22%20height%3D%2230px%22%3E%3CP%3E50%25%3C%2FP%3E%3C%2FTD%3E%3CTD%20width%3D%2241.3438px%22%20height%3D%2230px%22%3E%3CP%3E0%25%3C%2FP%3E%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20width%3D%2293.0781px%22%20height%3D%2230px%22%3E%3CP%3ESpongeBob%3C%2FP%3E%3C%2FTD%3E%3CTD%20width%3D%2274.4062px%22%20height%3D%2230px%22%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FTD%3E%3CTD%20width%3D%2249.9688px%22%20height%3D%2230px%22%3E%3CP%3E100%25%3C%2FP%3E%3C%2FTD%3E%3CTD%20width%3D%2241.3438px%22%20height%3D%2230px%22%3E%3CP%3E0%25%3C%2FP%3E%3C%2FTD%3E%3CTD%20width%3D%2241.3438px%22%20height%3D%2230px%22%3E%3CP%3E0%25%3C%2FP%3E%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20width%3D%2293.0781px%22%20height%3D%2230px%22%3E%3CP%3EBobcat%3C%2FP%3E%3C%2FTD%3E%3CTD%20width%3D%2274.4062px%22%20height%3D%2230px%22%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FTD%3E%3CTD%20width%3D%2249.9688px%22%20height%3D%2230px%22%3E%3CP%3E60%25%3C%2FP%3E%3C%2FTD%3E%3CTD%20width%3D%2241.3438px%22%20height%3D%2230px%22%3E%3CP%3E40%25%3C%2FP%3E%3C%2FTD%3E%3CTD%20width%3D%2241.3438px%22%20height%3D%2230px%22%3E%3CP%3E0%25%3C%2FP%3E%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20width%3D%2293.0781px%22%20height%3D%2230px%22%3E%3CP%3ESideshow%20Bob%3C%2FP%3E%3C%2FTD%3E%3CTD%20width%3D%2274.4062px%22%20height%3D%2230px%22%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FTD%3E%3CTD%20width%3D%2249.9688px%22%20height%3D%2230px%22%3E%3CP%3E50%25%3C%2FP%3E%3C%2FTD%3E%3CTD%20width%3D%2241.3438px%22%20height%3D%2230px%22%3E%3CP%3E25%25%3C%2FP%3E%3C%2FTD%3E%3CTD%20width%3D%2241.3438px%22%20height%3D%2230px%22%3E%3CP%3E25%25%3C%2FP%3E%3C%2FTD%3E%3C%2FTR%3E%3C%2FTBODY%3E%3C%2FTABLE%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIs%20anyone%20aware%20of%20a%20way%20to%20do%20this%3F%26nbsp%3B%20It%20would%20be%20a%20massive%20time%20saver%20and%20would%20help%20with%20some%20management%20reporting%20I%20need%20to%20run%2C%20without%20having%20to%20extract%20it%20to%20excel%20and%20make%20the%20manual%20changes%20needed.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2761262%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ELists%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ESharePoint%20Online%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2773328%22%20slang%3D%22en-US%22%3ERe%3A%20SharePoint%20Lists%3A%20Populating%20a%20picklist%20column%20based%20on%20the%20values%20from%20multiple%20columns%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2773328%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1159266%22%20target%3D%22_blank%22%3E%40Tom_Fitzgerald%3C%2FA%3E%26nbsp%3Bbased%20on%20your%20table%20I%20don't%20uderstand%20what%20sort%20of%20result%20you%20are%20expecting%20to%20see%20in%20the%20%22Winner%22%20column.%20Is%20it%20the%20column%2C%20either%20LOB%201%2C2%20or%203%2C%20that%20has%20the%20maximum%20percentage%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ERob%3CBR%20%2F%3ELos%20Gallardos%3CBR%20%2F%3E%3CFONT%20size%3D%222%22%20color%3D%22%23006400%22%3EIntranet%2C%20SharePoint%20and%20Power%20Platform%20Manager%20(and%20classic%201967%20Morris%20Traveller%20driver)%3C%2FFONT%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

Hello, so the issue I am trying to resolve for is this:

 

I'm currently building a resource allocation list in SharePoint, which has a split by percentage, by resource. I'd like to see if there is a way to have a fourth column Populate the "Winner" % and based off the percentage calculation populate some pre-defined text based on those allocations.

 

I may not be explaining it well, so please see the below table for an example:

 

 

Name

"Winner"

LOB 1

LOB 2

LOB 3

Jim Bob

 

50%

50%

0%

SpongeBob

 

100%

0%

0%

Bobcat

 

60%

40%

0%

Sideshow Bob

 

50%

25%

25%

 

Is anyone aware of a way to do this?  It would be a massive time saver and would help with some management reporting I need to run, without having to extract it to excel and make the manual changes needed.

3 Replies

@Tom_Fitzgerald based on your table I don't uderstand what sort of result you are expecting to see in the "Winner" column. Is it the column, either LOB 1,2 or 3, that has the maximum percentage?

 

Rob
Los Gallardos
Intranet, SharePoint and Power Platform Manager (and classic 1967 Morris Traveller driver)

@RobElliott 

 

Hi Rob, thanks so much for responding!

 

So after some additional research, I've decided to get rid of the "winner" column, and instead opt for Conditional formatting by rows.  What I am trying to do is basically conditionally format the winning % in each row, to highlight which LOB is receiving the highest allocation.  Basically, the same way you can conditionally format columns to show a disparity, just this time horizontally.

 

I hope this makes sense

@Tom_Fitzgerald yes I thought it would be something like that. I'll give it some thought over the next hour.

 

Rob
Los Gallardos
Intranet, SharePoint and Power Platform Manager (and classic 1967 Morris Traveller driver)