Calculated field in spreadsheet from Forms

Copper Contributor



I have a microsoft form for capturing data. The data is automatically stored in a sharepoint spreadsheet, but I was wondering if there's a way to add a calculated field either within the form or in the spreadsheet. 


I created a calculated column (AB) in the spreadsheet, but the formula doesn't seem to carry over to the rows that get added whenever the form is submitted, so I have to manually come in here and copy/drag the cell to the new row.



Any help is appreciated!

0 Replies