Hi all, I am attempting to populate a due date for when corrections on a document are needed to be done by.A regulatory team reviews a submitted file. When it's determined that corrections are needed that team updates a single select field named "Fil...

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...