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.
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.
This does not work in the Microsoft Lists Web App. There is no "More" option and therefore no "Calculated" option. Same error generates.
You have to click on "See all column types" at the bottom of the menu when you create a new column. It takes you to a whole new web page which is kind of annoying but once you fill out the column specifics and save it takes you back to your list...
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.
