example you have one list as below:
Number in rom (for user to edit) | Number in English (this is calculated type column) |
1 | One |
2 | Two |
3 | Three |
what you need to do is just create the column at the list with name Number in english, type in the formula as below:
=IF([Number in rom]="1","One",IF([Number in rom]="2","Two"), IF([Number in rom]="3","Three"))
Done!!
so user every time edit the data at Number in rom , the second column will auto change.
No comments:
Post a Comment