Multiple IF/AND/OR with Dates and Checkbox
I am trying to have a date populated by a formula below is what I have tried and I know individually they work.
=IF(AND(Event@row = "Event A", [2nd_Event]@row = 1), Date:Date-25, IF(AND(Event@row = "Event B", [2nd_Event]@row = 1), Date:Date-30))
In both cases 2nd_Event needs to be 1 (Check box)
If it was Event A, I need the date to be 25 days in the past.
If it was Event B, I need the date to be 28 days in the past.
Total columns in use 3 (Event@row, 2nd_Event@row, Date:Date)
Can anyone help?
Help Article Resources
Check out the Formula Handbook template!