Update Request and include date validation

JSpears

I have the following sheet:

User 1 will enter the Client Name and Historical Data Load Date via a form.

This triggers an update request to User 2 to provide the FHIR Ball Catchup Set Date.

This date must be BEFORE the Historical Data Load Date.

I have the sheet set to flag the row if the FHIR date is AFTER the Data Load Date.

BUT I would like for USER 2 to not be able to even enter a date that is after the FHIR date. User 2 uses an update request form to add the date. How can I build in the logic so that USER 2 doesn't enter a good date?

Mike TV

@JSpears

Form logic doesn't currently allow for one cell to reference another cell and restrict values being entered. However, you can setup an Automation that notifies User 2 that the date they entered isn't valid and it can be a request an update type Automation so they can correct what they entered that wasn't valid.