IF, THEN formula that references a checkbox field and a date field
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.
Help Article Resources
Check out the Formula Handbook template!