Calculated field in spreadsheet from Forms

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.