Duration Formula


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?


Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!