I currently have a reference table in one of our Insight pages that uses the following formula "IF(ISNOTNULL(project_completion_date),project_name+"°",project_name)" to add a degree symbol so I can conditionally format a column if the project has been completed.
The issue we are having is even with the column being configured to wrap text, once the degree symbol has been concatenated, text will stop wrapping. It works as intended if the if statement resolves to false. This behavior persists even when using the CONCATENATE function rather than the '+' operator.
**The highlighted row should say "Brookwood Way Bridge and Home Demolition°". The whole name appears when hovering over the cell or if you manually adjust either the width or height of the row. Also shown are the un-concatenated names which have proper wrapping**
Solved! Go to Solution.
@BlairMcclenathan This should be fixed in the upcoming release 2024.1.
@BlairMcclenathan Thanks for reporting this. We will take a look.
@BlairMcclenathan I looked into this and this is not specific to the calculated field the conditional formatting is causing the problem. You do not see the ° sign because the text is not wrapped. I have logged an issue for this.
@BlairMcclenathan This should be fixed in the upcoming release 2024.1.
@AkshayHarshe Great thank you for the updates!