Form response adding up to exactly 100%
Hi there,
I am creating a form to track employee time against projects. I have created individual drop down lists (10%, 20%, 30%, up to 100%) for each project. I want an error code to pop up if employees responses add up to more or less than 100%. Is this possible?
I believe Rick had a similar question here- https://community.smartsheet.com/discussion/67806/form-error-checking-adding-up-to-100
Thanks!
Answers
-
Are you able to provide screenshots for reference?
Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!
-
Hi @kailinj
If I'm understanding you correctly, you want an error code to pop-up in the actual Form itself as they're filling that out, is that right? Currently Forms are unable to do calculations like this, the calculation would need to be done in the underlying sheet after the form has been submitted. Does that make sense?
Please let our Product team know about your suggestion for Forms here!
Thanks,
Genevieve
Join us at Smartsheet ENGAGE 2024 🎉
October 8 - 10, Seattle, WA | Register now
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.6K Get Help
- 371 Global Discussions
- 203 Industry Talk
- 436 Announcements
- 4.5K Ideas & Feature Requests
- 137 Brandfolder
- 129 Just for fun
- 129 Community Job Board
- 447 Show & Tell
- 29 Member Spotlight
- 1 SmartStories
- 282 Events
- 32 Webinars
- 7.3K Forum Archives