I’m trying to improve my current formula for calculating task in flight.
NetWorkingDays(thisRow.[Created on],Today() )
The issue i now have is when the task is changing Status to “Done” this formula is still applying therefore I can’t look at how long the task was in flight as it still applies the today() function
So I would like something like:
NetWorkingDays(ThiRow/[Created on], if thisRow.State is "done" then Date it was modified to "done" or Today()
But I’m struggling to have a valid formula. If anyone could help that would be much appreciated.
All the best