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!!