Forum Discussion
Formula does not work for SharePoint/Lists
Evilgid Are these ([Spalte1], [Spalte2], [Spalte3]) all "Number" columns? You should use Number columns here.
Follow these steps:
- Go to SharePoint list
- Click on "Add column" and select "More..."
- On "Create Column" page, select "Calculated" as data type:
- Enter you formula here, select "Number" as return type and click "OK" at the bottom of page:
Please click Mark as Best Response & Like if my post helped you to solve your issue. This will help others to find the correct solution easily. It also closes the item. If the post was useful in other ways, please consider giving it Like.
ganeshsanap thank you for your answer. It works this way.
To answer your questions. All fields were numbers. I try to use Formulars in existing colums but that does not work and still does not.
But it works when creating a new one.
Thank you very much.
Evilgid You cannot use "calculated value" option of existing columns as this option cannot reference other columns in list in formula.
So, you have to create a column with "calculated" data type for referencing other columns in list in calculated formula.
Please click Mark as Best Response & Like if my post helped you to solve your issue. This will help others to find the correct solution easily. It also closes the item. If the post was useful in other ways, please consider giving it Like.