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.
You need to add a Show_If rule so it won’t hide that field if it has value.
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)
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
first site V] with app
formula
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.
User | Count |
---|---|
39 | |
28 | |
23 | |
23 | |
13 |