Custom field not showing in list of custom fields to display in custom report
Created a custom report in table layout based on tasks and subtasks and filtered to a specific custom item type. The report shows all of the correct records but I'm trying to add a few custom fields that exist on those custom item type records. Two of the custom fields I use on these records appear in the Custom Fields section when I click the gear to choose which fields to show as columns in the report. But the other fields don't appear.
If it matters:
- Of the two fields that I CAN pick, one is text-based and one is single-select list-based
- Of the fields that don't appear as choices, all are text-based
- As far as I can tell, all properties of all of these custom fields (other than field type) are identical. Applied to = all, Author = me, Belongs to = same space, Can see = everyone, Can edit = everyone
This is the column chooser panel where I'm expecting to see but not seeing these fields appear. Interestingly, there are other custom fields I can choose that aren't even used in the custom item type I'm trying to report on.
I should have also mentioned that the custom fields I'm trying to pull into this report are populated for at least some of the records that appear in the report.
Semi-answered my own question but this seems like a bug. I found that if I navigate to the parent folder of the projects where these task records live, create a new table-based view of that folder, and force-search for the missing custom fields, I'm able to add them to that table-based view of the parent project. After doing that, magically I can now choose these same fields in the custom report.
Hey Chris (AIS-BI) Martin, let me ask our Support team to look into this. I'm creating a ticket for you.
Thanks a lot for bringing this up!
Lisa Community Team at Wrike Wrike Product Manager Become a Wrike expert with Wrike Discover
Lisa Wrike Team member Become a Wrike expert with Wrike Discover
I can confirm the same issue in our Wrike account. Thank you, Chris Martin, for the workaround - it worked for us as well.
Rohan V Community Team at Wrike Wrike Product Manager Infórmate sobre las funciones y prácticas recomendadas de Wrike
Rohan V Wrike Team member Infórmate sobre las funciones y prácticas recomendadas de Wrike