nlarsen’s Profile

Community member since June 2018

points
176

8

I'd like to write a formula based on Start Date and End Date Columns:

If Start Date is less than or equal to today and End Date is greater than today or blank, I want "In Progress"

If Start Date is less than or equal to today and the End Date is less than or equal to today, "Complete"

If Start Date

6

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