Resetting values when hidden. Here's an exa...

[Nathan_McGregor]

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.