Hi, I’m very new to CODA.
My idea is whenever a new document coming, a user can select what is the revision of the document and subsequently enter the WF no in the next column.
I wanted that whenever user set Document A is Rev 00 and enter the WF No, WF00 wil be updated according to the WF No and will be impact to Rev01 and WF01 and so forth.
Anyone could help to figure what is the formula required, tried to use
SWITCHIF but it seems getting error circular reference.