New String Value Column

New String Value Column

Hello,

I am trying to create a custom formula in Zoho Reports. I have a column with multiple string values with true and false.
Column: Isclosed
String Value is: "true" "false"

I want 2 new columns to display: Open "true" & closed "false". what would the custom formula look like? I have tried many different formula but with no success.

Thank You,

Arron Robles

Blue Pumpkin Hosting | Solutions Made Simple