Assigning a value to a field

Edward Nadareski

Hello.

Could use some help / suggestions on the following formula.

=IF(AND([Date Completed]@row = " ", [Due Date]@row >= TODAY()), [Past Due (Y/N)]@row = "True", [Past Due (Y/N)]@row = "False")

I have a Due Date field, a Past Due flag field, and a Date Completed field. I would like this process to set the Past Due (Y/N) field to "true" if Date Completed is BLANK .and. the Due Date is TODAY or greater, of course , until the work task is completed. I'd be happy to use the PAST DUE (Y/N) as a Symbol field, but that doesn't seem to work for me at this time. I continue to get the error message of # INVALID COLUMN VALUE.

Any help would be greatly appreciated! Thank you!

Kelly Moore

Hey @Edward Nadareski

This formula should be inserted in the [Past Due] flag column. I will assume that the formula, as you have it written, is 'True' for the Past Due column. Flag columns can be designated with a 1 as True and 0 as false. Since the false is also a 'do nothing or leave the flag blank', it can be implied.

=IF(AND([Date Completed]@row = "", [Due Date]@row >= TODAY()), 1)

Kelly Moore

Hey @Edward Nadareski

This formula should be inserted in the [Past Due] flag column. I will assume that the formula, as you have it written, is 'True' for the Past Due column. Flag columns can be designated with a 1 as True and 0 as false. Since the false is also a 'do nothing or leave the flag blank', it can be implied.

=IF(AND([Date Completed]@row = "", [Due Date]@row >= TODAY()), 1)