Forum Discussion

kareemshamel's avatar
kareemshamel
Copper Contributor
Jun 28, 2021

Cannot change column type

Greetings,

 

I am receiving this error when trying to change a column type number to single line text:

 

"the type of this column cannot be changed because it is currently being indexed"

 

Any idea?

  • Betabit7's avatar
    Betabit7
    Copper Contributor

    kareemshamel 

    I encountered the same issue and fixed it by following these steps:

    1. Disable the "Enforce Unique Values" option on the column.
    2. Remove the column index.
    3. Change the column type to the desired type.
    4. Re-enable the ‘Enforce Unique Values’ option.
  • kareemshamel Is this the custom column you created in list? 

     

    You can find the indexed columns on list settings page under Columns section with heading: Indexed columns.

     

    Remove indexing on the number column & then try changing the column type.


    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.

    • kareemshamel's avatar
      kareemshamel
      Copper Contributor
      It keeps on saying: Wait It should not take a long time forever.
      • ganeshsanap's avatar
        ganeshsanap
        MVP

        kareemshamel When are you getting this error? While deleting indexed column or changing the column type?

        Did you try my suggestion above to delete indexed column before changing column type?


        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.

  • jamaalmch's avatar
    jamaalmch
    Copper Contributor

    kareemshamel Any updates on the following. I am receiving the same error. The index never deletes it just keeps spinning, as if its in progress.

Resources