Forum Discussion

ksyrz's avatar
ksyrz
Copper Contributor
Feb 07, 2024

Assign a value based on another column

Hi!    I am looking to create a new column in a Microsoft List. I need the column to assign a value based on the team name.   For context: If Team is A then value is 100, If team is B then value ...
Lists
Microsoft Lists
  • ganeshsanap's avatar
    ganeshsanap
    Feb 07, 2024

    ksyrz If you are trying to create a calculated column, use formula like this: 

     

    =IF([Team]="A","100",IF([Team]="B","200",IF([Team]="C","300","")))

    Or (with numbers): 

    =IF([Team]="A",100,IF([Team]="B",200,IF([Team]="C",300,"")))

     

    Note:

    1. Sometimes comma( , ) does not work in formula (it is based on language or regional settings on your site). So in that case use semicolon( ; ) instead of comma( , ).
    2. Use correct display name of your SharePoint columns in above formula.
    3. Wrap column names inside [] if your column name has space in it. For example: [My Column Name].

    Please click Mark as Best Response & Like if my post helped you to solve your issue. This will help others to find the correct solution easily. It also closes the item. If the post was useful in other ways, please consider giving it Like.

ganeshsanap's avatar
ganeshsanap
MVP
Feb 07, 2024

ksyrz If you are trying to create a calculated column, use formula like this: 

 

=IF([Team]="A","100",IF([Team]="B","200",IF([Team]="C","300","")))

Or (with numbers): 

=IF([Team]="A",100,IF([Team]="B",200,IF([Team]="C",300,"")))

 

Note:

  1. Sometimes comma( , ) does not work in formula (it is based on language or regional settings on your site). So in that case use semicolon( ; ) instead of comma( , ).
  2. Use correct display name of your SharePoint columns in above formula.
  3. Wrap column names inside [] if your column name has space in it. For example: [My Column Name].

Please click Mark as Best Response & Like if my post helped you to solve your issue. This will help others to find the correct solution easily. It also closes the item. If the post was useful in other ways, please consider giving it Like.

  • Thommo67's avatar
    Thommo67
    Copper Contributor
    Jun 21, 2024

     

    Hi! 

     

    I am looking to create a new column in a Microsoft List. I need the column to assign a value based on the team name.

     

    For context: If T-Shirt Size is high then then value is 12-8 weeks, If T-Shirt Size is medium then value is 6-12 weeks, If T-Shirt Size is low then value is 3-6 weeks, If T-Shirt Size is Very low then value is 1-3 weeks

     

    I am having issues with the formula. I have tried an IF statement like above but not being successful.

     

    apologies I’m not sure if I am allowed to ask a question within a thread. I have just joined today.

     

    Thank you!

Resources