How to add date condition to IF/AND equation

I have multiple IF/AND equations in a column formula. I want to add a condition to the IF/AND equations to apply before a certain date in a column(Date of Shoot). This is an example of one of the formulas:

IF(AND(Talent@row = "Agency", Time@row = "Half", [Date of Shoot]@row < DATE(2023, 9, 16), 250

But is shows as "incorrect argument"

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!