Forum Discussion
SharePoint Lists - Display one Choice selection in a Second Column Also.
I have two columns in a SharePoint List. Let’s call the Column 1 and Column 2. They are both Choice Columns. They also both share two common choices, Completed and Cancelled. If someone selects one of those choices in either column, I would like it to be automatically displayed in the other column also. Meaning, both columns should match if Completed or Cancelled are selected in either column. If another choice is selected in either column, the other column should remain empty, for a manual selection of one of the other choices. What would the JSON code be to do something like this? I want to keep all my other formatting intact, just looking for the IF statement to sync the text between the two columns, no matter which is changed.
- michalkornetIron Contributor
Hi johncrouse62,
Wouldn't this code display the value correctly?
"txtContent": "=if([$Column2] != '', [$Column2], '')"And, of course, similar column formatting code should be added to Column2. This will be just a representation of the column value. The underlying value will still be empty in one of the columns. If you want to sync the values, you might consider using a Power Automate flow.