3 Replies Latest reply on Apr 2, 2018 7:27 PM by Ashok Ramineni

    Hide Sheet for multiple selection on Action Filters

    Ashok Ramineni

      Hello,

       

      I have a sheet 1 with Sub-Category & Profit. Sheet 2 has Region and Discount fields.

       

      I have created an action between Sheet 1 & 2, however data will display for the selected Sub-Category values, which is default behavior of Actions.

       

      My requirement is, when user selects

      1. Single value from Sub-Category, then Sheet 2 should be visible or pop-up

      2. Multiple values from Sub-Category, then Sheet 2 should be invisible or hide or show blank screen.

       

      which means that when selected single value from sheet 1, then Sheet 2 should display else should be blank.

       

      Please let me know for any work around.

       

      Thanks,

      Ashok.