<aside> đź“– Required properties

  1. Text property called “Name”
  2. Formula property called “Year Born” Year Born/Died
  3. Formula property called “Year Died” Year Born/Died
  4. Date property called “Date of Birth”
  5. Date property called “Date of Death” </aside>

Screen Shot 2022-01-17 at 9.40.09 AM.png

What’s happening

The formula is determining the approximate age of death given two different scenarios.

  1. If you only have the year born and the year died inside the title of the page, it will calculate the difference between these years.
  2. If you have a narrower date of birth/death, it will adjust the formula to a more precise age.

Age Died

if(not empty(prop("Date of Birth")) and not empty(prop("Date of Death")), dateBetween(prop("Date of Death"), prop("Date of Birth"), "years"), if(not empty(prop("Year Died")) and not empty(prop("Year Born")), prop("Year Died") - prop("Year Born"), toNumber("")))

Breakdown