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

(Nathan McGregor) #1

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.

(Aleksi Alkio) #2

You need to add a Show_If rule so it won’t hide that field if it has value.

(Segolene Sansom) #3

maybe an action+workflow that changes the [hours worked on second site] to 0. the trigger being if [sites worked on]=1 for 3 sites then have another action+workflow with trigger being or(if [sites worked on]=1,if [sites worked on]=2)

(Suvrutt Gurjar) #4

Hi @Nathan_McGregor, You may wish to explore following

This is a bit of elaboration of guidance given by @Aleksi_Alkio Please create 3 VCs , one each corresponding to [Hours worked on first site], [Hours worked on Second site] and [Hours worked on third site] , Say

  1. [Final Hours

first site V] with app


IF([Sites Worked on]>=1,[Hours worked on first site],0)

[Final Hours Second site V] with app formula

=IF([Sites Worked on]>=2,[Hours worked on Second site],0)

[Final Hours Third site V] with app formula

=IF([Sites Worked on]=3,[Hours worked on third site],0)

In total hours calculations , please use these virtual columns rather than actual data entry columns by user which are

[Hours worked on first site], [Hours worked on Second site] and [Hours worked on third site]

Hope this helps in some way. This approach will not reset the data entry, if it has already been made in 2nd and 3rd site hours columns, but the total hours will not count their hours in total calculation if user reduces

sites worked from 3 to 2 or 1 or 2 to 1.