Email Condition "LIST has elements of mismatched types"

AppSheet AppSheet Q&A
,
1

Hello,

I am trying to automate an email for Deposit Due Date reminders. In the google sheet, I have a column for the Deposit Date (DD/MM/YY) and then a Deposit Status Number column (0 if “Paid”, 1 if “Unpaid”). I want the condition to if it is todays date and the deposit is unpaid, sent the email. I am using this formula “AND({[Deposit Date]=Today()},{[Deposit Status Number]=1})” The parts work individually, but do not work when together. I get the error “LIST has elements of mismatched types”. I am a new user, so any help would be much appreciated. Thank you!

2

AND([Deposit Date]=Today(),[Deposit Status Number]=1)

I think you are using { } unnecessarily

1 Like
3

Thank you, that worked!

2 Likes