Hi, im trying to automate flagged risks within projects I am managing however am struggling

chrisfinlay ✭✭
edited 04/11/23 in Formulas and Functions

I have made many attempts however it confuses me. I originally wanted to have the formula to flag any tasks that were due within the week

or to flag tasks that will not be accomplished by their due date (this would be ideal however I am not sure my sheet would be equipped for this as my duration is for each task is automatically calculated.

So far I have created this =IF([End Date]1 < TODAY(+7), 1). This was to test and try a basic formula however this flags the task however even if it is okay. Any help would be greatly appreciated. I've attached a screenshot.


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!