New answers tagged

3

Let's say, six columns are C1, C2, C3, C4, C5, C6. So now you can just check the value before adding and dividing. I mean following =( IF(C1="NA",0,C1) + IF(C2="NA",0,C2) + IF(C3="NA",0,C3) + IF(C4="NA",0,C4) + IF(C5="NA",0,C5) + IF(C6="NA",0,C6) )/ ( IF(C1="NA",0,1) + IF(C2="NA",0,1) + IF(C3="NA",0,1) + IF(C4="NA",0,1) + ...


0

Calculated column can look values from only the current item. It doesn't have the capability to look across the list items and take a decision. Your best option is to create an item event receiver or use a SharePoint Designer workflow that get fired on new item add.


0

The error appears to relate to the problem that I posted here Unable to get property 'PageManager' of undefined or null reference SP2013 I have now fixed that error, so I'm assuming that this problem will be fixed as well. It makes sense to move the code out of the Calculated column into the JS, so this is what I am going with, and the solution ...


0

The formula should be like this =IF([Meeting Frequency]="6 Monthly",[Last Meeting Date]+182,IF([Meeting Frequency]="Monthly",[Last Meeting Date]+30)) You will need to use nested if in calculated column, your first if statement's closing bracket need to be at end.


0

I tested this formular: =IF([Meeting Frequency]="6 Monthly" ,DATE(YEAR([Last Meeting Date]) ,MONTH([Last Meeting Date])+6 ,DAY([Last Meeting Date]) ) ,IF([Meeting Frequency]="Monthly" ,DATE(YEAR([Last Meeting Date]) ,MONTH([Last Meeting Date])+1 ...


0

You can use any text editor to format your code with line-breaks and indents, then paste it into a Formula. SharePoint will strip them on saving I did not change anything in your Formula, only added line-breaks and spaces As Teylyn said.. some syntax errors.. =IF(OR(Entity="Entity1" <-- one parameter, not an error, but OR is not needed ) ...


0

I guess the calculated column has some limit for If statements and as per my knowledge its 7 if statements. As you said you have manage to includes 20 IF statements and then an & IF statement to add another 20 countries. And I am assuming that because of this you are getting result as PeruFALSE, because first set of 20 statements returning Country name ...


0

The formula you posted above is riddled with wrongly placed braces and quotes. No wonder it does not work. =IF(OR(Entity="Entity1"),"Peru"[...] Why use OR() with only one condition? [...]IF(OR(Entity="Entity2)",Entity="Entity3",Entity="Entity4",Entity="Entity5",), There is a closing bracket after the first condition, but it is INSIDE the quotes ... ...


0

It turns out pulling the calculated column in using a content query web part works. I added the field ref name in the description box of a cqwp and - bingo.


0

I would say it's not possible. You can include multiple files within JSLInk by using | between the JSLink property in Web Part settings, e.g., ~site/myscript.js|~site/myotherscript.js, and myscript.js would be usable in myotherscript.js. It doesn't, however support any variables, so it will not work in you case. Could you make AJAX call to that Google API ...


0

Formulas will only update when the List Item is modified/updated. That means Today() is the same as [Modified] (last date the item was modified) For long explanation and possible workarounds read: How to use Today and Me in Calculated column


2

I tried it as the following example in my SharePoint 2013 on-prem. If you want to use the today() date, the formular looks like this: =IF(AND([Due Date]>Today(), [Due Date]<Today()+7), "Requires Action", "")&IF(Today()+7<[Due Date],"In Progress", "")&IF([Due Date]<=Today(),"Close Out", "") And my list looks e.G. like this: Keep in ...


0

This article is probably what you're looking for. It suggests to create 2 ‘single line of text’ columns with JavaScript and 1 calculated column to put everything together. Using JavaScript URL in Calculated Columns


0

Go to list setting --> Under general setting go to Validation setting and use below formula. This will make date field mandatory if status is Approved =IF([Status]="Approved",IF([Date]="",FALSE,TRUE),TRUE) Formula says if Status is Approved and Date is empty validation is false else true. Hope this helps !


1

Clicking (4) might be possible with javascript and hooking into events (closing the modal window of the new item form, for example), but clicking (5) is not. You can't control the click action in Outlook using javascript executing in a browser.



Top 50 recent answers are included