I have a sharepoint list that I need to have a calculated column returning the month from a date. I have tried all the suggesitons on google, them being exactly the same:
=TEXT([Date],"mmmm")
This leads to an error:
What am i doing wrong?
@jamescosten You are trying to add calculated value for single line of text column which does not allow referencing other columns in list.
Instead, you need to create a calculated column in a list. Follow below steps:
- Go to list, click on Add column and then select More...
- Select Calculated as type of column, enter your formula in Additional Column Settings > Formula textbox and click OK button to save the column.
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.
Accepted Solutions
@jamescosten You are trying to add calculated value for single line of text column which does not allow referencing other columns in list.
Instead, you need to create a calculated column in a list. Follow below steps:
- Go to list, click on Add column and then select More...
- Select Calculated as type of column, enter your formula in Additional Column Settings > Formula textbox and click OK button to save the column.
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.