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) 857-1221
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
- Customer Resources
- 64.9K Get Help
- 441 Global Discussions
- 139 Industry Talk
- 471 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 68 Community Job Board
- 496 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!