Formula Choices

Copper Contributor

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

2 Replies
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.

@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.