Dynamic cells?

kenzael

Hi everyone,

 

I have a grid where the user can tick to override an amount. If he ticks override, he can put the new amount below, else it is 0. The problem is that I want the user to be only able to change the amount in the line item "new average salary" if the box is ticked, and not to be able to change the amount if he doesn't tick the box (cell with black font).

Is it possible to have a formula that does like : IF Override ? THEN "the user changes manually the amount" ELSE 0 ?

 

Thank you!

 

kenzael

Thank you, very helpful!