Is it possible to change Filter options in a datagrid

Hi,

I have a datagrid that shows a boolean column. I have changed the text to show as Open (false) or Closed (true).

I would like to find out if it possible to change the filter options from true/false to Open/Closed.

I have tried adding a formula

if("True","Closed","Open")

to the filter but that doesn’t work.

Any assistance appreciated.

Steve

Hey @SynopsisLabs :waving_hand:

I think you’re talking to @DanielL in the support chat as well. I’ll let you guys update us on here once you’ve found the solution so everyone can benefit from the answer.

Thanks