Forum Discussion

jamescosten's avatar
jamescosten
Brass Contributor
Jul 08, 2022

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")   ...
  • ganeshsanap's avatar
    Jul 08, 2022

    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:

    1. Go to list, click on Add column and then select More...
    2. 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.

Resources