Populate "Urgent" when {Due Date} is within 7 days of TODAY and {Date Filed} is EMPTY
Hi, I am trying to populate in a cell, "Urgent" when a project is coming up on its {Due Date} within 7 days of today AND the cell that has my completed date, {Date Filed} is Empty. If {Date Filed} is Not Empty, i'd like it to populate "Completed". If...
- 32 Views
- 1 replies
- 0 kudos