Forum Discussion
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 is 200
I am having trouble with the formula. I have tried an IF statement that looks something like this =IF[Team]="A","100"
Thank you!
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:
- 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( , ).
- Use correct display name of your SharePoint columns in above formula.
- 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.
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:
- 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( , ).
- Use correct display name of your SharePoint columns in above formula.
- 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.
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!
