Forum Discussion
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 ha...
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.