Formula Help

steve50951 ✭✭
edited 12/09/19 in Formulas and Functions

I have an at risk column with flags. I am need a formula that will turn the flag red when its past a due date, and not marked complete. 

I used this formula

=IF(AND([Date Needed By]1 < TODAY(), [Cabinet Complete]1 = 0), 1, 0)

this works for the current row, but when I drag down to copy to cells below, it automatically turns the flags red when there's no data in the cells. 

something in the formula isn't copying correctly. Or maybe its not written exactly correct. 

Thanks for you help.



Screen Shot 2019-02-14 at 11.02.19 AM.png

Screen Shot 2019-02-14 at 11.04.41 AM.png



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!