Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I have a conditional color expression
if(GetActiveSheetId() = '$1',$(color.bg.active.nav),$(color.bg.inactive.nav))
I have tried then using the following variable where my sheet ID is called Dashboard
$(v.nav.bg(Dashboard))
Do I need to wrap this in another dollar sign expansion
Any Ideas
Call the variable function with Document\Dashboard, so
$(v.nav.bg(Document\Dashboard))
See example (different sheet name, but same princiapl)
Call the variable function with Document\Dashboard, so
$(v.nav.bg(Document\Dashboard))
See example (different sheet name, but same princiapl)
Change the variable definition of v.nav.bg as below
if(WildMatch(GetActiveSheetId(),'*$1'),$(color.bg.active.nav),$(color.bg.inactive.nav))
Thanks a lot, a schoolboy error on my part, I should have know that
but thanks
Hi Manish,
This also works thanks alot.
I will probably use your option as it's less maintenance that typing Document\ each time
Regards
Alan
You have selected your own answer as helpful !
Sorry Manish, I have fixed that now