Multiple IF/AND/OR with Dates and Checkbox

Courtney Caswell

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?

Mark Cronk

Hi @Courtney Caswell ,

Try:

=IF(AND(Event@row = "Event A", [2nd_Event]@row = 1), Date@row-25, IF(AND(Event@row = "Event B", [2nd_Event]@row = 1), date@row-30,""))

This will return days 25 or 30 prior to your date column at the row. Is that what you're looking for?

Mark

Mark Cronk

Hi @Courtney Caswell ,

Try:

=IF(AND(Event@row = "Event A", [2nd_Event]@row = 1), Date@row-25, IF(AND(Event@row = "Event B", [2nd_Event]@row = 1), date@row-30,""))

This will return days 25 or 30 prior to your date column at the row. Is that what you're looking for?

Mark