Duration Formula

Elena G.

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!

Gia Thinh

Hi Elena G.,

Just modify your formula as below

=IF(ISDATE([Adoption Date]@row), [Adoption Date]@row - [Transport Helper]@row, TODAY() - [Transport Helper]@row)

Hope it works

Gia Thinh

Hi Elena G.,

Just modify your formula as below

=IF(ISDATE([Adoption Date]@row), [Adoption Date]@row - [Transport Helper]@row, TODAY() - [Transport Helper]@row)

Hope it works

Elena G.

Excellent, thank you!