I have a report and I would like to add a new column; however the fields I would like to ask do not appear

Question

I have a report which includes different columns related to some fields.

I would like to add some new columns, however the columns I would like to ask (which are details of each of the tasks - concretely completed date) are not in the options available.

Basically if I click on adding a column:

The tasks I am looking for is not available to be chosen (I've checked all the possible options and it's not there):

However, if in the report I click in one of the projects:

I can find the data I am looking for:

How can I add the completed date of that task into the report for each of the relevant projects?

Please also find attached a picture of the relationship diagram:

I believe this is quite complex, so I hope the pictures make it much easier; please feel free to ask me any questions, I have spent days trying to sort it out with no result.

Any help would be massively appreciated.

Kindest regards,

Eduardo.

DavidBrogdon · Answer

From what I can tell, Projects is the parent and Tasks is the child? If that is right then you wil not be able to look at a specific task completion date as a column on the projects report. One option is to create a formula field that equals "ToText([Completion Date])" and then create a combined text summary field on the projects table that sums this field up from the tasks table. You can then display all child task completion dates as a combined text field.

Otherwise, You can use various summary field options to capture just one completion date from the tasks records. For example, You could get the last date by doing a "max." summary. Or the first date by doing a "min." summary. A note to make is that last I knew date fields were not summarizable, the workaround is the convert the date field to a date/time field, either directly or through a formula rich text field.

Hope this helps.

Sign up

Login to the community