Formula Q

Kim Michael

Currently I have a cell with a formula to determine "Days Till Due" (=[Due Date]@row - TODAY()) based off a due date cell. I also have a status cell that has the drop down with: complete, in progress, not started, roadblock. I have conditional formatting that will strike through the row when the status is changed to "complete"

I would like to modify the formula to show only Days Till Due if the status is anything but complete. Thus if the it would look like this with the new formula.

Gil Nash

=IF(Status@row = "Complete", "", [Due Date]@row - TODAY())

Kim Michael

Thank you so much! It works perfectly!