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))
Hello,
Calculated columns in a basic list will provide a result of some sort that is displayed in your view based on the calculations you do with existing data. So if you want to do math then it would be best to capture numbers in your other columns first.
- Example:
- Black (Number Column)
- Color (Number Column)
- Calc (Calculated Column)
- Formula: =[Black]*[Color]
so in your view using your example numbers you would see something like this:
| Black | Color | Calc |
| 11 | 19 | 209 |
Also remember you can add counters to the view (See modify view > totals section) give you that information if need be.
Otherwise you cant use a calculated field to change your Choice Field options. Conditional logic can be developed in InfoPath.