Forum Discussion
jamescosten
Jul 08, 2022Brass Contributor
Sharepoint List Calculated Month Column
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.
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.
- jamescostenBrass ContributorThank you very much.
jamescosten You're welcome! glad it helped you.
Please consider giving a Like if my post helped you in any way.