I need help with the "IF" formula

Hi. Sorry, I’m new to baserow. how to do this in baserow? I want to move to baserow because I prefer open source.

Captura de tela de 2022-08-18 09-42-57

In airtable it is right. In baserow I can’t do it.

I’ve tried this formula:

IF(field(‘RESPOSTA’)=field(‘GABARITO’),1,0)

Thank you

Hello @roowba! First of all, welcome to the Baserow community :wave:

That’s great you prefer open source software, you’ll find a lot of like-minded people here :raised_hands:

The formula doesn’t work in your case, as the IF function works only with text field types in Baserow for now. But there is a super easy workaround: all you need is to add conversion of your single select fields into text (by using the TOTEXT function) to the formula:

if(totext(field('RESPOSTA')) = totext(field('GABARITO')), '1', '0')

I recreated your table, so you can see that this solution works :ok_hand:

1 Like

Awesome. Thank you so much.