How to convert Board tickbox to a flag in Excel

Yas Davoudzadeh

Does anyone know how we can convert the tickbox column from an xlsx file into a binary flag? 

When I make column b = a, I get the same whether the column is empty or not.

A user exported the file so I'm not sure if they can enter the layout to change the column appearance.

Thanks

Waleed Ullah

You could get them to export as a flat file using the board built in option