Forum Discussion

Tom_Fitzgerald's avatar
Tom_Fitzgerald
Copper Contributor
Sep 17, 2021

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

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 ...
Lists
SharePoint Online
RobElliott's avatar
RobElliott
Silver Contributor
Sep 22, 2021

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)

Tom_Fitzgerald's avatar
Tom_Fitzgerald
Copper Contributor
Sep 22, 2021

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

  • RobElliott's avatar
    RobElliott
    Silver Contributor
    Sep 22, 2021

    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)

Resources