Formula Help
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.
SGF
Comments


Thanks for you help. The above formula, when copied, still left a red flag. If the cells in Date needed by were blank, it defaulted to a red flag.
Here's what I wound up using.
=IF(AND([Date Needed By]@row < TODAY(), ISDATE([Date Needed By]@row), [Cabinet Complete]@row = 0), 1)
do you think this will work?
SGF

When a date cell is left blank, it is automatically assumed to be less than TODAY. To account for this, try using this...
=IF(ISDATE([Date Needed By]1), IF(AND([Date Needed By]1 < TODAY(), [Cabinet Complete]1 = 0), 1, 0))
All this does is says to run your existing formula only if there is an actual date in there.

Gotcha. Makes sense. Ill try it. Thanks!

Help Article Resources
Categories
 All Categories
 14 Welcome to the Community
 10.5K Get Help
 62 Global Discussions
 46 Industry Talk
 386 Announcements
 3.5K Ideas & Feature Requests
 55 Brandfolder
 125 Just for fun
 50 Community Job Board
 466 Show & Tell
 40 Member Spotlight
 44 Power Your Process
 28 Sponsor X
 234 Events
 7.3K Forum Archives
Check out the Formula Handbook template!