Formula for relevance section

[Justice]

Total farm size examples 9 Acres is entered first
Next question is select multiple crops on the farm indicating various Acres of the crop selected.( I need a formula that will limit the collector from entering more than the total farm size enter first)
The crop selected and their corresponding Acres should be equal to the total farm size enter first.

[Kal_Lam]

Hi @Justice,

Welcome to the community! Looking at your requirement i hope the post discussed previously should solve your issue:

Issues related to the summation of previous answers and limitation

Hi, Welcome to the community forum. I suggest that you add a constraint script for each question using a logic that allows you to check for every step. Q2 should have constraint as .<= ${Q1} Q3 should have constraint as .<= (${Q1}-${Q2}) Q4 should have constraint as .<= (${Q1}-${Q2}-${Q3}) If you are editing in XLS form, then approach below will help you sort this out. [image] The excel is attached here Test_06182020_2118hrs.xlsx (11.7 KB) The behavior you will get is this: [image] …

Kindly please let us know if you are looking for something different then as outlined.

Have a great day!

[Justice]

Thank you very much