Forms Enhancement Request

Elizabeth Aird
✭✭✭✭
Now that the forms have had a good update, I would love to be able to add a conditional format OR use the one I have entered in another column. SO THAT the entry would show an error, or out of spec condition.
For instance, operator enters the temperature at 115. I have a column in the worksheet that looks at the entry (with index/match) for the low spec and the high spec. it will return the word RED if out of spec (too low/too high). It would be great if when the data is entered this formula would pull through in the form.
Much like getting an error when I don't enter all the correct information on an order form.
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 66.1K Get Help
- 430 Global Discussions
- 149 Industry Talk
- 490 Announcements
- 5.2K Ideas & Feature Requests
- 85 Brandfolder
- 154 Just for fun
- 74 Community Job Board
- 499 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 305 Events
- 36 Webinars
- 7.3K Forum Archives