Forum Discussion
ForrestParker
8 years agoQrew Cadet
What if you simply made Field B a formula text field instead of a text multiple choice field.
Sample formula:
if
(
[Field A]="Done"
,"Finished"
,"Pending"
)
Sample formula:
if
(
[Field A]="Done"
,"Finished"
,"Pending"
)