Dollar Sign Expansion Variable within a Variable

[rustyfishbones]

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

[stigchel · Accepted solution]

Call the variable function with Document\Dashboard, so

$(v.nav.bg(Document\Dashboard))

See example (different sheet name, but same princiapl)

[MK_QSL]

Change the variable definition of v.nav.bg as below

if(WildMatch(GetActiveSheetId(),'*$1'),$(color.bg.active.nav),$(color.bg.inactive.nav))

[rustyfishbones]

Thanks a lot, a schoolboy error on my part, I should have know that

but thanks

[rustyfishbones]

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

[MK_QSL]

You have selected your own answer as helpful !

[rustyfishbones]

Sorry Manish, I have fixed that now