Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi
I have a field called "Year" and I need it to always have a value selected (It has the year.. 2014,2015,201...). I also have another field called YearVolume, that also has years, but from data that is apart from the main model.
So I use "Year" in Sheet 1-4 and Year2 in Sheet 5.
When I change the Active Sheet, YearVolume takes the value of Year and vice versa.
The trouble is that I can't use the option "Always one Value Selected" because it doesn't unselects the field when I leave the Sheets that use it, so I end it up with Year and YearVolume selected with the same year. But as they are two field, they exclude everything.
I'm trying to emulate the "Always one Value Selected" with a trigger for the field. I set the trigger to "On any select" with the following value, without luck:
=if(GetSelectedCount(Periodo)=1,Periodo,'2016')
Any idea how to solve this?
can you post a sample app?
When I change the Active Sheet, YearVolume takes the value of Year and vice versa.
How are are you doing this??
With triggers in Sheet 5!
Trigger:
Field: Year
Expression: =if(GetSelectedCount(Year2)>0,'("' & Concat(DISTINCT Replace(Year2,' ','?'), '"|"') & '")','')