6 Replies Latest reply on Aug 14, 2018 4:48 AM by Jim Dehner

    Logic to show data depending on scenario

    Jenna Dulchinos

      Hello,

       

      In the attached 10.5 workbook I am working in the Next to Deploy dashboard. What I have here is a column called "Execution End Date". I also have a column in my excel data sheet called "Changed End Date". What I am trying to do is create something that says if there is a date present in the data source in the Changed End Date cell for a specific row, then I want to display that date over the currently shown Execution End Date. I was trying to create a calculated field using if statements but did not seem to have any luck. Any ideas on how to accomplish this?

       

      Thank you in advance!

      Jenna