Hello! I’m running into an issue where the formula in my original Status column is returning values it shouldn’t. The formula determines layaway statuses.
To verify the logic, I split the formula into smaller parts and everything checks out. I also pasted the exact same formula into a new column and even duplicated the original column—both of those versions return the correct results. Only the original Status column shows incorrect outputs.
I can’t simply replace that column because many other parts of the doc reference Status. I’ve recorded a short video showing the issue and I’m including the full formula below.
I had to change the formula to a SwitchIf, which solved the problem, but this is not the first time this has happened to me, it occurs with If formulas.
Video:
Formula:
If(
thisRow.[Pagado♾️].ToText()=0 and thisRow.[Notas de Devolución].IsBlank(),
[En Espera➡️],
if(
thisRow.[Productos Devueltos].IsNotBlank() and thisRow.Productos.IsBlank(),
[Devolución 
],
If(
thisRow.Tipo = “Apartado📦” and
thisRow.[Pagado♾️] = thisRow.[Total♾️],
[Liquidado💴],
If(
thisRow.[Pagado♾️] >= thisRow.[Total♾️],
List([Pagado💵]),
If(
thisRow.[Productos Exhibidos].IsNotBlank() AND thisRow.Productos.IsBlank(),
[Exhibido 
],
If(
thisRow.Tipo = “Apartado📦” and
thisRow.[Pagado♾️] < thisRow.[Total♾️] and
thisRow.[Días Restantes 
]< 1 and
thisRow.[Restante♾️] != 0,
[Vencido❌],
If(
thisRow.Tipo = “Apartado📦” and
thisRow.[Pagado♾️] < thisRow.[Total♾️],
List([Activo⌚]),
“a”
)
)
)
)
)
)
)