Skip to main content

Hi All,

 

I have sheet 1 having all monthID like below

 

Reset the Sheet Value to default after releasing the actions

 

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

6 answers
  1. Jan 11, 2019, 4:40 AM

    HI Chris,

    Attached the workbook.

     

    regarding the release of action i am talking about below section in the filter action

     

    HI Chris,Attached the workbook.

     

    Regards,

    Naveen Bandla

0/9000