On some lists or libraries you might not see all the fields on that list or library as Columns that can be inserted into Calculated fields. Some field types like the ones highlighted below cannot be uses in Calculated Columns:
If I try to create a new calculated column on the All Field Types List, I only see the valid type fields listed where I can insert them into the Formula:
The field types that cannot be used in Calculated Columns are:
- Choice (Checkbox)
- Multiple Lines of text
- Person fields (including the Created By and Modified By fields)
- Managed Metadata
Work around for missing fields
You can use a workflow to take the value from one of the field types that aren’t allowed in Calculated Columns, and copy that value into a new single line of text field on the list/library.
You will then want to hide the field from the list/library since your workflow will be populating the value.