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.
Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am  12:45pm!

Gotcha. Makes sense. Ill try it. Thanks!

Happy to help.
Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am  12:45pm!
Help Article Resources
Categories
 All Categories
 14 Welcome to the Community
 Smartsheet Customer Resources
 62.8K Get Help
 376 Global Discussions
 207 Industry Talk
 440 Announcements
 4.5K Ideas & Feature Requests
 139 Brandfolder
 129 Just for fun
 130 Community Job Board
 449 Show & Tell
 30 Member Spotlight
 1 SmartStories
 284 Events
 33 Webinars
 7.3K Forum Archives
Check out the Formula Handbook template!