6 Replies Latest reply on May 20, 2016 1:07 AM by Andrew Watson

    how to Use One Parameter in Different sheets and it work Differently in each of them

    Sandeep Tiwari

      Hi All,

       

       

      I have created two sample sheets And I have used the same parameter control and a calculated field based on this parameter.

       

      The challenge which I am facing here is .. When I change the parameter in one sheet that's been implemented in other sheet as well...

       

      When i select a value from parameter then for 1st sheet it should calculate using a field (i.e. UpdatedOn) and for second sheet it should calculate using other field (i.e. CreatedOn)

       

      I want that to work independently otherwise I may end up creating "N" number of parameters...

       

      Please advise.. Attached is the sample workbook.

       

      Thank you!!