Constrained Input

3.48K viewsQuantrix Feedback

Hi Mike:

I was wondering if I am maximizing the capability of the Constrained Input feature.

I want the user to input a value between two numbers that are calculated in the model. Is there a way to enter expressions in the Constrained Input like Conditional Format? Right now, if a user enter a invalid value, I have the cell turn red based on the conditional format. But, if I can do this using Constrained Input or some other way, it would be great. Thanks!

Best regards,



Hello – thank you for your post. It would be a good feature to be able to use formula expressions in constrained input functionality. I have logged this in our database for future release consideration.

I don’t have any immediate workarounds to your issue. If someone else has run into this before and has a suitable workaround – please feel free to post.