Update Request and include date validation

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?

Answers

  • Mike TV
    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.

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!