Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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