Validation of numbers in text grid


I am collecting percentages in a grid.


For the example suppose its about percentage of types of fruit collected by month where rows are apple, pears, oranges etc. and columns are months: June, July, August etc.


Is there a simple way to check that each column adds to 100%.

Ideal would be a total percent row which auto updates to reach 100%. Otherwise simple error message “Response do not add up to 100%”

Edward90 answered

     Thanks Dominic. 

    Edward90 answered

      There is not a simple/built-in way to do this. In order to have a Textbox Grid output this calculation, a custom scripted solution would be needed.

      SurveyGizmo has a Continuous Sum question that allows you to do this with a one-column layout – perhaps that might be a good workaround:

      Hope this helps!

      Dominic Sharpe answered


        Question stats

        • Active
        • Views1298 times
        • Answers2 answers
        • Followers1 follower