Cannot compare List with Number in (Tenant[Tenancy_End] >= DAY(TODAY()))

Getting the above error in the formula below

And ([Rent Due Date] >= Day (Today()), Tenant[Tenancy_End] >= Day (Today()))

Expressions of the form table[column] return a List of all values in that column from all records in the table.

You’ll need a way to determine which record in the table you want to pull that column’s value from.

1 Like

For reference: