IF, THEN formula that references a checkbox field and a date field

Margaret Griffin

I'm trying to write an IF, THEN formula that references a checkbox field and a date field, but I keep getting errors. Here's the logic: If the 'EMDS' column is checked, then calculate the 'Date Needed' column minus five days. If seems simple, but it may actually be too complicated for the system since it essentially involves nesting formulas. Here's what I have so far, which is returning an #INVALID COLUMN error: =IF(EMDS@row = 1, [Date Needed]@row - 5,). Any advice is appreciated.

Bob May

 =IF([EMDS]@row, [Date Needed]@row - 5)

The column that contains the formula must be a "Date" column.

Bob May

 =IF([EMDS]@row, [Date Needed]@row - 5)

The column that contains the formula must be a "Date" column.

Margaret Griffin

Fantastic. It originally was a Date column, but I kept getting the 'Date Expected' error message so I changed it to a Text column. I changed it back to a Date column and now it works exactly as intended. Thanks!