Modern Project List Export to Excel Boolean Field Shows As True/False

Products

• Clarity PPM SaaS
• Clarity PPM On Premise

Issue/Introduction

Boolean field showing True or False when exported to CSV in the Modern. 

In the classic it shows as Yes/No

Classic: The Boolean field in Classic show the 'value' - 'Yes'

Example: The 'Active' or 'Open for Time Entry' field).  When Exported to CSV from Classic, gives 'Yes' or 'No' in the output. 

Modern: Displays checkbox on the generic grid.  When Exported to CSV from Modern, gives 'True' or 'False' in the output. 

Resolution

This is working as per design.

You will need to use a Macro to have the spreadsheet display the desired values.