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

    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

       Thanks Dominic. 

      Edward90 answered


        Question stats

        • Active
        • Views1297 times
        • Answers2 answers
        • Followers1 follower