At Risk Flag

edited 12/09/19 in Formulas and Functions

Hi there! I am trying to have it so that the flag shows if the End Date is 3 days away AND the Status is "Not Started" (ideally, I would like it to show if the status is anything but Completed, but that may be too difficult). I know to use a nested IF/AND function, but I keep getting errors when I write it out. I started with: =IF(AND([End Date]@row < TODAY() - 3, Status@row = "Not Started", 1, 0)) and have been messing with that a little and still no luck. This is only a sample sheet I am presenting on Monday, that's why there aren't many dates in there. Thanks in advance!

Screen Shot 2019-11-08 at 3.40.08 PM.png


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!