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.
Is the sha256 fingerprint you entered in your web/.well-known/assetlinks.json
is the same as the one entered in google play console? 
(On "Release Management" / "App signing" "App signing certificate")

```
    [{
    "relation": ["delegate_permission/common.handle_all_urls"],
    "target" : { "namespace": "android_app", "package_name": "package.name",
                 "sha256_cert_fingerprints": ["**this:one**"] }
  }]

```

[![google play console screenshot](https://i.stack.imgur.com/3q1ep.png)](https://i.stack.imgur.com/3q1ep.png)