Format rule not working

[Nicolas_Feldman]

Hi everyone,

Im trying to apply the next format rule:
AND([Recámara]=SI, [Baño]=SI, [Sala]=SI, [Puertas y ventanas]=SI, [Cocina]=SI, [Herramientas]=SI)
Where if all columns checked “SI”, it should apply a green checkmark to the row.

The test for this expression brings back the correct results,

but in the UX, the green checkmark is being applied to all rows even if they don´t match the “SI” condition.

I´ve even set the Initial Value to be “NO”, but not working either.

Any ideas? I have the exact same expression working on another app, I don´t know why its not working here. The only difference is that the other app has Yes/No Column Types, this app has Text Colum type with “Si” and “No” Options.

Thanks!

[Nicolas_Feldman]

UPDATE! Possible bug.
In the table view when I choose a Row, it takes me to a different Row Detail View, not the one I select.
i.e.: I Select Room 21, it takes me to room 32 detail or form view.

[Nicolas_Feldman · Accepted solution]

Solved. I was having duplicate values in the Key Column.