How to display calculated column in SharePoint List Form?

Question

Hi there,

we are creating an order form with SharePoint List.

and we would like the use see the total when they put order, which need an calculated field displayed on the form, amount * price.

after I set the calculated column in SharePoint List, it does not display at the form.

Note: Est. Total is not calculated column.

Could you please help?

List:

Form:

Thank you,

Eric

Answer 1

Hi Zhang, Eric

Thanks for reaching out to Microsoft Q&A forum support 

Based on your description, I understand you're investigating why a calculated column in a SharePoint List doesn't appear in the form view, even after you've configured it correctly. I've conducted some research and testing in my own environment, and here are a few insights that may be relevant to your situation: 

Initially, as far as I know, by default, calculated columns in SharePoint Lists are not displayed in the default modern list forms (e.g., New, Edit, or Display forms) due to their dynamic nature and how SharePoint handles them in the user interface. As calculated columns are read-only and auto-update based on their formula, unlike editable fields. When you create a calculated column (=[Amount]*[Price]), it exists in the list’s schema and can be used in views or reports, but SharePoint does not automatically include it in the form layout unless explicitly configured. This design choice ensures forms remain focused on user-input fields and avoids clutter from non-editable data.  

Additionally, the reason it’s not displayed after creation is that the modern form only shows columns selected in the "Show or hide fields" pane or those added during form customization.  

From my research, if you want to make it visible, you need to customize the form using Power Apps by following the instruction in the links below:  

Link instruction: 

Automate calculations by defining calculated columns - Power Apps | Microsoft Learn 

Customize a form for a SharePoint list | Microsoft Learn 

Hope you will solve your problem soon, if the issue still persist, kindly let us know in the comment 

---

If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".    

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread. 

Answer 2

Hi Steven,

Thank you for the explanation.

we will try and let you know.

Thanks again,

Eric