At Risk formula

Hello Community,

I'm new to Smartsheet and was trying to use the below 'At Risk' formula given from the "Project Rollup & Tracking" Smartsheet template (image #2). I put the formula in my own created project plan, but when I went to my dashboard, the At Risk Tasks ONLY showed itemed that had no date associated with the task (image #1). And didn't show the 'Late' item or 'In Progress' and 'Not Started' task items. I would like the logic to indicate any tasks that show any task at risk. Per the below image #3 from the Project Rollup & tracking template, it should capture all of it.



#3 above


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!