Need help writing an expression for a Yes/No Condition

[Greg_Stevenson]

I have implemented an Automation Bot that is on a schedule to fire off an email @ 8PM daily consisting of a template I made for our Carryover loads. I want the condition to only fire off the email if there is an order that has a [Pickup} = TODAY(), and the [Status] = "CARRYOVER". But unfortunately, when I attempt to write the expression for this, the Expression Assistant is telling me that column values are not available. Both [Pickup] & [Status] are columns on my spreadsheet that I need to filter in order to acheive this. Can anyone point me in the right direction?