Skip to main content

Hi All,

 

I have sheet 1 having all monthID like below

 

Release the actions reset the view to default Filte

 

Another Sheet same as Sheet1

pastedImage_1.png

 

I have another field called "Version ID" which shows the month of the revision and it is constant and changes whenever revision cycle changes.

 

pastedImage_2.png

 

So whenever User Opens the Dashboard sheet 2 should show 201807 value , but when user clicks on the sheet 1 Month ID  , my Sheet 2 value should show respective value like

 

Users lands on Dashboards he wants to see 201807

When User Click on 201809 in sheet 1 Then --> Sheet 2 should show 201809

When user release the action --> Sheet 2 should show 201807 ( Which is value equal version ID )

 

Thanks in Advance.

 

Regards,

Naveen Bandla

3 answers
0/9000