3 Replies Latest reply on Oct 11, 2016 7:27 AM by Shinichiro Murakami

    Help with calculated field...two data sources


      So I have two data sources. The first has the high level information such as the master project, sub project, and overall start and end dates. The second data source has the tasks with task date and the master project but it does not have the sub project associated with it. So I need to figure out how to associate each task with the appropriate sub-project so I can further run calculations (i.e. # of tasks per sub project.). For the purpose of the test, I put both datasources into the same Excel workbook.