Changing True/False to 1/0

[FILIPKACZMAR]

Hi,

my name is Filip and I want to change True/False to 1/0 in new column. 

But I cant find on the internet code which will work... 😞 

Can you help me? 

Thank you for help, have a nice day

[Anonymous · Accepted solution]

Hi @FILIPKACZMAR 
you can try 

new_column =
IF(column_name = TRUE(),1,IF(column_name = FALSE(),0))

Regards

[FILIPKACZMAR]

Thank you 🙂

[Anonymous]

You're welcome 😀