Assigning a value to a field
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!
________________________________________
Edward Nadareski
(e): ejnadareski@mmhayes.com
(p): (518) 8571221
Best Answer

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)
Answers

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)
Help Article Resources
Categories
 All Categories
 14 Welcome to the Community
 10.6K Get Help
 63 Global Discussions
 68 Industry Talk
 385 Announcements
 3.5K Ideas & Feature Requests
 55 Brandfolder
 125 Just for fun
 50 Community Job Board
 465 Show & Tell
 40 Member Spotlight
 44 Power Your Process
 28 Sponsor X
 234 Events
 7.3K Forum Archives
Check out the Formula Handbook template!