Forum Discussion

BobbieWinter's avatar
BobbieWinter
Copper Contributor
Apr 01, 2022

Format a number column based on values in a different column

this is likley simple, and I could do it easily in infopath, but since it is no longer supported, i need a different solution. Open to calculated column or power all (I guess--have not found them easy to use).

Here is the scenario:

i am building a leader board based on reported activities.

Column A is a single choice has the activity (G, H, I, J, or K)

Column B is a choice trigger (ie "completed")

when the item is marked as completed, I want the following to happen in column C (which is my numeric column)

If column A = G, insert 1

if column A = H, insert 2

if Column A = I, insert 3

etc.

 

What is the easiest way to do this please/

 

  • RobElliott's avatar
    RobElliott
    Silver Contributor

    BobbieWinter all you need is a calculated column with the following formula with the data type returned as a number with no decimal places:

    =IF(Status="Completed",
    IF(Activity="G",1,
    IF(Activity="H",2,
    IF(Activity="I",3,
    IF(Activity="J",4,
    IF(Activity="K",5)))))
    ,0)

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

Resources