Formula DCA to lock cell

ilincach

Hello,

I need some help with a DCA.

So I have 3 line items weekly dimension : X (number), Y (number manually input) and Z Yes or No.

So :

• If I select No on line Z, then line Y should be 0 (blank)
• If I select on line Z Yes and if line Y is not 0, then the line Y for that week (cell) should be locked
• If I select on line Z YES and if the value from line Z is 0, than I should take value from line X

There should be some DCA that will alow to lock the cells as stated above

Thanks

Dikshant

@ilincach - Few questions on requirement,

1. What should be the formula conditions for X?
2. If I select on line Z, yes, and if the value from line Z is 0, then I should take the value from line X. Question: Column Z is a dropdown of Yes or No or is it a text line item where we can input Yes, No or any number?
3. If I select No on line Z, then line Y should be 0 (blank). Question: It's an input line item, so when you say make it zero, do you mean to lock the values by making the cell as Read-only since we cannot apply formula here as it's manual input line item as you mentioned?