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.
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...