Prevent Form Submission If Date is Greater Than 90 Days In Future
Our IT department uses a form in Smartsheet for users to request access to to our systems for external users. One of the columns in the sheet/form is the Account Expiration Date, which can't be more than 90 days in the future.
Is there any way to prevent a user from submitting the form if they've selected any such date? My thought was to use the form logic for when the date "is after 90 days from now", but I can only use this to display other fields. Now if I could use the logic to display a required empty read-only text box , than that would be a nice work around to prevent the user from submitting, but I don't see any way to do this.
Any thoughts or suggestions are greatly appreciated!