I created a smart sheet that notifies the appropriate lead when someone is requesting access to a project. All the formulas, filters, and alerts are correct.  The issue I'm having is when a form is filled out a new row is created the formulas aren’t being placed in the appropriate cells so the


I'm really struggling to get the syntax right on this.  I have a column called "% Complete" and a due date column called "Finish."  If the % Complete < 100 and the due date is today or already passed, I want to turn on a flag in the "At Risk" column.  Ideally I'd actually like to flag it if the due