Hello,
I work for an animal rescue and would like to track how many days a dog has been in rescue, and have the counting stop once they get adopted.
The formula I'm using now is =IF(ISDATE([Adoption Date]@row), "", TODAY() - [Transport Helper]@row).
The formula works when then dog has yet to be adopted, but once the adoption date is entered, there is no result. For example, there should be a "3" for Finn in the Days in Rescue cell.
The adoption date is part of an automation when Contract Received and Payment Received have been checked.
What do I need to add to my formula in order for both scenarios to work?
Thanks!
