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

[Landlord_Buddy]

Getting the above error in the formula below

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

[Marc_Dillon]

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.

[Steve]

For reference:

help.appsheet.com

List from Table-Column Reference

Create a list from the values in a column of a table.