formula error
2 Topics
Formula does not work for SharePoint/Lists
I recently started to work with list. My list contains product information such as Vitamins. I want to have one Column "Total Vitamins" in which the the vitamins are calculated together. (Vitamin C + Vitamin D) simple. Here did I find the formulas https://support.office.com/de-DE/client/results?Shownav=true&lcid=1031&ns=SPOStandard&version=16&omkt=de-DE&ver=16&HelpId=WSSEndUser_FormulaSyntaxError For sum it is =[Spalte1]+[Spalte2]+[Spalte3] (german formulas) But it does not work. It creates a fault. "The default value formula cannot refer to columns. To define a column that is based on other columns, use a calculated column." --> which is exactly what i was trying! Original german: "Die Standardwertformel kann sich nicht auf Spalten beziehen. Um eine Spalte zu definieren, die auf anderen Spalten basiert, verwenden sie eine berechnete Spalte." Optional it should work with =summe([Spalte1];[Spalte2]) This creates a Syntax fault. Anyone any idea how to make it work to summ up values from different columns in 1 coloum for every row! Thank you in advanceSolved22KViews0likes5Comments
Avoiding #NAME? Error/ Calculating date difference
I am creating a share point list that tracks our plan progress through the year. I have 2 date columns - [planned start date] and [actual start date]. I have the current formula in place: =IF(ISBLANK([Activity Start Date]),"0",DATEDIF([Planned Start Date],[Activity Start Date],"YM")) However, When the[actual start] is BEFORE the planned date, it gives me the #NUM? error rather than a negative value. I have found previously the suggestion to use a formula: =IF(ISERROR(DATEDIF(TODAY(),[Due date],"d")),"0",DATEDIF(TODAY(),[Due date],"d")) I adapted it to fit my list: =IF(ISBLANK([Activity Start Date]),"0",IF(ISERROR(DATEDIF([Planned Start Date],[Activity Start Date],"YM")),"0",DATEDIF(([Planned Start Date],[Activity Start Date],"YM")) However, received a syntax error.Solved2.1KViews0likes2Comments