Forum Discussion
Solved
SharePoint Calculated List Column
Under a standard custom list, can I use the calculated field to assign values to a choice field that has words not numbers? We want to determine cost for printing in black and white vs color. I have a...
- You can use this query written for you.
=IF([Pagetype]="Black & White",([page no]*11),IF([Pagetype]]="Color",[page no]*19))
Yes, but bear in mind there is a limit to the number of if statements you can use (i think it is 7) in a single calculated field. So if you have more than 7 colors, you would have to combine multiple calculated fields to achieve what you want.
You might be better off to use a lookup field, where the lookup value is the "color" field, and then the lookup list also has a field for the value. Then maybe your calculation is a SPD workflow, instead of an actual calculated field.
You might be better off to use a lookup field, where the lookup value is the "color" field, and then the lookup list also has a field for the value. Then maybe your calculation is a SPD workflow, instead of an actual calculated field.