Resetting values when hidden.
Here’s an example of my problem if [Sites worked on] = 1, 2 or 3:
User inputs the following:
[Sites worked on] = 2
[Hours worked on first site] = 5.5
[Hours worked on second site] = 3
[Hours worked on third site] = HIDDEN
User realises they only worked on one site and changes [Sites worked on] to 1
Now [Hours worked on second site] will be hidden but retain its 3 value.
How can I set up a column to reset if it goes back to being hidden? This is sporadically corrupting data when users make adjustments to their timesheets.
Thanks for your help.