May 03 2023 12:00 PM
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
May 13 2023 09:24 AM
May 14 2023 04:45 AM
@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.