Hi Smartsheet Community,
I'm working on an action management system where users create sub-actions through a Smartsheet Form.
The requirement is simple: a sub-action's due date must be earlier than or equal to its parent action's due date.
For example, if the parent action is due on June 30, 2027, users should not be able to select any date after June 30.
Ideally, I would like to disable (grey out) all invalid dates directly in the form's date picker, based on the parent action's due date.
Currently, we can detect invalid dates after submission, but we want to prevent users from selecting them in the first place.
Has anyone implemented something similar? Is this possible natively in Smartsheet, or is there a recommended workaround?
Any feedback or real-world examples would be greatly appreciated.
Thanks in advance!
Madjid
