Question: This spreadsheet I am working on tracks trainings. I'm having issues with this because one training counts for itself and fills the requirement for the other. I am trying to apply conditional formatting on column G that turns the cell red if the dates in;

* Column F and G are not within 3 years
* Column G are blank
* Column F = 0 and Column G are not within 3 years

Here is my best effort at the formula

```
=OR(AND(TODAY()-$F1>1095,TODAY()-$G1>1095),$G1=0,AND($F1=0,TODAY()-$G1>1095))

```

Answer: 
The domain `toastmasterstimer.tk` seems to be missing the Digital Asset Links file, necessary to validate ownership and enable fullscreen.

The file needs to be available at `https://toastmasterstimer.tk/.well-known/assetlinks.json`. 

You can use the [Statement List Generator and Tester](https://developers.google.com/digital-asset-links/tools/generator) to generate the `assetlinks.json` file.

This [section](https://developers.google.com/web/updates/2019/02/using-twa#link-site-to-app) of the documentation provides more information, including how to extract the SHA-256 fingerprint from your signing key.
When you build your APK, you will sign the app with a key-store.

Once you create a key-store, you will need to get a `sha256 fingerprint`.

To get the sha256 you will need to run:

`keytool -list -v -keystore /keystore-location/pwa-keystore.ks`

Then, make sure the following route available on your web app, containing your sha256 fingerprint generated above.

www.example.com/.well-known/assetlinks.json

```
    {
      "relation": ["delegate_permission/common.handle_all_urls"],
      "target": {
        "namespace": "scapeq",
        "package_name": "org.electrobooth.twa.scapeq",
        "sha256_cert_fingerprints": ["sha256_FINGER_PRINT_GOES_HERE"]
      }
    }
  ]

```