I'm not sure if this is the right forum, but here goes: I would like to keep the cell value (E8), if the adjacent cell (D8) is false (checkbox is not checked), else insert zero or null. I just keep getting an error, because of self-reference (E8).
I also thought about changing the textcolor using conditional formatting, but it seems that it's not possible to do that using other cells as the conditional factor by itself. It is however possible, if the cell value is compared to another cell,
but i wouldn't know how to use that to achieve my goal.
Does anyone knows how to achieve this, without using AppleAcript? I need the spreadsheet to be compatible with iOS as well, which is why AppleScript is not an option.
EDIT: I figured out a way around it by using conditional formatting. I made the text change to white (same as background), if the value is greater than G8. G8 already has a function that changes the value to 0, if the checkbox is checked.