IF Statements with two different Columns

Options

Hello,

I am trying to write a formula to state if this date is greater than XX, and a different Column = 2, then give me a 1, if not then 0 but I can not get it work.


=IF([Install Date]@row > DATE(2022, 9, 23), [Mashgin Qty]@row = 2, "1", "0"))


Breelyn Brown

Answers