Locking in age at death

I use one field for year of birth which then automatically calculates age (another field) as the years go by which is a wonderful feature to keep the data current. However, some of the entries in the data base are deceased so they should not “continue to age”. Is there a way that I can make Ragic stop the addition of years once the field “deceased” is filled?

Please contact me if I was not clear on this message.

Gratefully, Pat

Hi Pat,

How about using an UPDATEIF formula for the age calculation field? The UPDATEIF formula allows the field to retain its previous value when the specified condition is not met.

You can refer to this user guide for more details.