I have issues with NaN type return; it occurs in several databases: SmartSheet, Google, etc.

[Walterks1989]

I have a formula in the 'Ref Ruta' column where the formula to obtain 'valid if' values is set to 'Calendario_Entrega[Ruta],' but the issue is that cells containing text types return NaN, while cells containing numbers are returned correctly. Please note that this problem has extended to all apps. This did not happen before

[scott192]

Rather than setting your [Ref Ruta] column to be of type Enum, try to change it to be of type Text.

You can leave your Valid_If statement as it is.