Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi....
I have Hierarchy like --Hardware
Servers
Storage
Desktops
Firewall
All are the indiviual sheets i want a linking between all the sheets like if we click Servers that sheet should appear,and if we click Storage that sheet should appear....etc,, how can we implement this req,, i have attached sample sheet
Hi,
You need to put the same code
=YourField = 'Types'
Like for ever sheet that you have
like
for
Hardware
=[ShairA&I]='Hardware'
Desktop
=[ShairA&I]='Hardware/Desktops'
=[ShairA&I]='Hardware/Firewall'
=[ShairA&I]='Hardware/Servers'
=[ShairA&I]='Hardware/Storage'
like ways for others sheet, you need to put this codes individually for the shhets in
Sheet properties -> Conditional -> and paste this code for sheets over there.
And let me know if you got it.
Regards
Anand
View solution in original post
use condition like below for each sheet in layout Condition
filedName='Hardware' in hardware sheet
filedName='Desktop' in 'Desktop'sheet
so on
when you click on hardware it wwill show u hardware sheet and desktop then desktop ssheet and so on
Hi Sunil,
Layout Condition means from sheet properties under show sheet-- have to select Conditional option am i right???
Am writing like filedName='Desktop' in 'Desktop'sheet under conditional option from sheet properties but its not working............
can you elaborate you answer.............
sorry
go to sheets one by one
sheet properties-> geneeral-> conditional -> type your expression
Sunil still not working with the above exp can you please send me a sample file.......
Yes anand its working perfectly..................thanks alot....
