Forms, excel, and pivot table

Frequent Visitor

Hello all, 

I work in quality and our auditors use tablets to fill out MS Forms as the y do their daily rounds. This makes it really convenient to collect and share data through our SharePoint site.

I am having trouble as I try to create a pivot table and create a chart to present numerical values. When the data comes in from my forms it's not formatting as a number and therefor my pivot isn't pulling it to calculate. Any ideas? I have formatted the columns as numbers and restricted responses to numbers on the form.

Thanks

0 Replies