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.



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!