How do I get Working Days remaining to stop counting once a task is complete?

Paula D
Paula D ✭✭✭
edited 04/24/24 in Formulas and Functions

I'm using a SS template that has start/end date, working days remaining, duration, % complete and status. If I mark a task 100%, it automatically changes my status to "Complete". It's a nice little automation. What I'm noticing though is that the working days remaining field continues to count and I have a "-" (negative) number in that field. And the task was never overdue. I've taken a screen shot so you can see the formula SS has provided. I didn't modify it all. Can anyone assist me in correcting this? I mean I can delete the number from that field so it doesn't show a negative or anything but that's an extra step that I don't think I should have to do.

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!