Creating an At Risk Formula

Welcome to the New Smartsheet Online Community

You’ll notice that things have changed a bit. If you need help getting oriented, please take a look at the posts here in the Welcome to the Community category.

Creating an At Risk Formula

Hello Community,

I am trying to create a formula that will create a flag if the tasks are not marked as Completed in the check box column and the Due Date is within the next 3 days. I've made several attempts at using an IF/AND formula, but can't seem to get it to work properly. 

Any assistance you can provide would be greatly appreciated! 

Thank You! 

Screen Shot 2019-05-06 at 9.29.00 AM.png


Sign In or Register to comment.