Due in Days and conditional formatting question

Options

I have this formula (below) to calculate my "Due in Days" column, and a conditional formatting rule that states "If due in days is less than 0" then apply a red font. but I'm wondering if I'm able to have it display no number once the task has been completed, or at least remove the red font once the "Status" column dropdown menu selection is "Completed".


=IFERROR(NETWORKDAYS(TODAY(), [Actual End Date \[Launch Date\]]@row), "")


I would really appreciate some help with this, Thank you!!

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!