Percentage Formula's
I have a beneficiary nomination form I am asking employees to complete, I am giving them the option of 4 beneficiaries, but would like to be able to tally the total percentage amounts they input per beneficiary as they complete the form to a total of 100%.
So would be 4 fields/columns allowing percentage inputs, if they put 100% in the first one, then they would not be able to add to the other 3 fields, or if they put 80% in the first one, they would only be allowed 20% in the next 3 and so on up to 100% cap.
Does anyone have a formula I could use for this. Any help would really be appreciated.
Answers

You will not be able to restrict this on the form itself. The best we can do is evaluate after submission and flag either for followup or an automated update request.
Help Article Resources
Categories
 All Categories
 14 Welcome to the Community
 10.7K Get Help
 63 Global Discussions
 69 Industry Talk
 385 Announcements
 3.5K Ideas & Feature Requests
 55 Brandfolder
 125 Just for fun
 50 Community Job Board
 464 Show & Tell
 40 Member Spotlight
 44 Power Your Process
 28 Sponsor X
 234 Events
 7.3K Forum Archives
Check out the Formula Handbook template!