Forum Discussion

pastaliefhebber's avatar
pastaliefhebber
Brass Contributor
Aug 20, 2023

MS Lists: Question about calculating fields

Hi,

 

I run into an issue with calculating fields in an MS List.

 

Please can anyone help me with solving it:

 

I have created a List in MS Teams.

This list has 3 columns:

k1: type number

k2: type number

som: type number

 

I created one 1 entry with following:

k1: value 1

k2: value 2

som: =[k1]+[k2]

 

expected value to be displayed: 3

however, its not. In enter mode, I get an error message displayed:  "input is of wrong type". What am I doing wrong?

 

If I change the type of som to Text no calculation if being performed...

 

Anyone with tips or ideas? Thanks

 

calculated fields
microsoft lists

2 Replies

  • SvenSieverding's avatar
    SvenSieverding
    Bronze Contributor
    Aug 21, 2023

    Hi pastaliefhebber ,

    you are trying to use SharePoint Lists like Excel. But Lists work differently.

    If you want a calculation in a column then you don't create a number column, but a "calculated column".

    Click "Add a column" and scroll down to "See all column types"


    Now give that column a name and select "Caclculated"


    Scroll down and enter the formula

     

    Leave the screen by using the "OK" Button below.

    Best Regards,
    Sven




Resources