Hello,
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!