Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
 
					
				
		
 datanibbler
		
			datanibbler
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		Hi,
I have a multi_box as a standard_element on all sheets in all my apps with selections on
- year (from a master_calendar)
- month ((from a master_calendar)
- week (from a master_calendar)
plus some others which are specific to that KPI.
I have already used the aggr() function, to show only the applicable weeks whenever any month is selected - but usually, the selection (the default one) is a year and a week, not a month. In some situations it can be helpful, though.
=> Now I wondered: Can I use a formula so that, when 2015 is selected, only the cw in the past or present (1 and 2) are shown (but when 2014 is selected, of course one would expect to have all weeks available)?
Thanks a lot!
Best regards,
DataNibbler
 
					
				
		
 marcus_sommer
		
			marcus_sommer
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		Maybe something like this in the condition:
if(YourWeekField <= week(today()) and Year = year(today()), YourWeekField)
- Marcus
 
					
				
		
You can hide the excluded values using the properties of the multibox object itself. See the attached snapshot.
Hope that helps
