Calculated field in spreadsheet from Forms

%3CLINGO-SUB%20id%3D%22lingo-sub-2268731%22%20slang%3D%22en-US%22%3ECalculated%20field%20in%20spreadsheet%20from%20Forms%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2268731%22%20slang%3D%22en-US%22%3E%3CP%3EHello%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20a%20microsoft%20form%20for%20capturing%20data.%20The%20data%20is%20automatically%20stored%20in%20a%20sharepoint%20spreadsheet%2C%20but%20I%20was%20wondering%20if%20there's%20a%20way%20to%20add%20a%20calculated%20field%20either%20within%20the%20form%20or%20in%20the%20spreadsheet.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20created%20a%20calculated%20column%20(AB)%20in%20the%20spreadsheet%2C%20but%20the%20formula%20doesn't%20seem%20to%20carry%20over%20to%20the%20rows%20that%20get%20added%20whenever%20the%20form%20is%20submitted%2C%20so%20I%20have%20to%20manually%20come%20in%20here%20and%20copy%2Fdrag%20the%20cell%20to%20the%20new%20row.%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22MorePowerBI_0-1618260850543.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F272213i7AE8663A60FDEBFC%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22MorePowerBI_0-1618260850543.png%22%20alt%3D%22MorePowerBI_0-1618260850543.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAny%20help%20is%20appreciated!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2268731%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ECalculated%20Field%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EForms%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Occasional Contributor

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.

MorePowerBI_0-1618260850543.png

 

Any help is appreciated!

0 Replies