Forum Discussion

Dani_Solis's avatar
Dani_Solis
Copper Contributor
May 03, 2023

Formula Choices

Hello there,

 

I am working in SP List and I would like to add a column choice with default value "On" and with a formula change this value from "On" to "Off". But it's not working.

Example I have these columns:
"Score" column data type=number (Default value=0)
"On\Off" column data type=choice (Default value="On")

This is my formula but it doesn't working:

IF(Score<=1,"On","Off")

What am I doing wrong or what I'm trying can't be done with the Choice column type?

I hope you can help me.

Thanks

 

DS

SharePoint Online
  • RobElliott's avatar
    RobElliott
    Silver Contributor
    May 13, 2023
    Your OnOff column needs to be a calculated column, you can't do this with a choice column unless you build a simple flow in Power Automate.
  • ganeshsanap's avatar
    ganeshsanap
    MVP
    May 14, 2023

    Dani_Solis Where are you adding this formula? You cannot refer another column in default value formula for any column.

     

    Do you want this choice column to be editable by users from list forms? If yes, you may need to use Power automate flow or Power apps customized list form to automatically update choice column value based on another column.

     

    If you don't want choice column to be editable by user, you can use calculated column instead of choice column as suggested by RobElliott 

    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