Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello everyone! I have a slight problem, any help would be much appreciated.
I have 2 sheets (sheet1 and sheet2) and 2 data columns (Day and Group).
My goal is:
1) We start at sheet1 and select values on Day and Group
2) Going to sheet2 the selection on Group clears. The selection Day stays the same. We might change the selection on Day here.
3) Going back to sheet1 we have the same selection on Day as we had chosen on sheet2 and the same selection on Group as we had before on step 1
Basically, we need to clear selection on Group going to sheet2 and save it somewhere to activate it on returning to sheet1.
To achieve this, i created a variable vGroup and made triggers on activating and deactivating sheets:
Sheet1:
on activating:
1) select in field: Group ='$(=vGroup)'
on deactivating:
1) set variable: vGroup =GetFieldSelections(Group )
Sheet2:
on activating:
1) Clear field: Group
So, it does work just fine when we select only one value in field Group. However, it does not work if we select more than one value in field Group (we lose all selections in Group on going back to sheet1).
Thanks for help in advance! A fix to this or an alternative solution would help!
Of course, example in the attachment.