Tag Info

New answers tagged

1

Regardless of which character is used when the field is created, the formula works on lists in SharePoint websites anywhere in the world. SharePoint automatically changes the delimiter character to the one that is appropriate for the language/culture of the current page. In some countries, the comma is reserved for use as the decimal mark. In such ...


0

The overlays are defined in SPView.CalendarSettings property, it is an XML file that generate the overlay information like this: <AggregationCalendars> <AggregationCalendar Id="{26ddb82c-9e2b-4c5d-9b7e-4ee25cf5c357}" Type="SharePoint" Name="My Overlay Calendar" ...


0

You can actually use Christophe's HTML Calculated Column, please have a look at following question: how to show HTML code in column? So based on average of a column, you build up your HTML in calculated column to show the image and you put the JavaScript that does the magic to convert that String representation of HTML to actual HTML.


0

It is possible with an Item Added Event Receiver which would update all the other Items with the same Date. I don't see any other option if the list is still changing. Reference on how to add an Event Receiver http://msdn.microsoft.com/en-us/library/ee231563.aspx Pseudo Code: if list contains other Item with same Date write this to this and the other item ...


1

A lot is wrong in your code. SUBSTITUTE does not exist for Calculated Columns Besides that, you are mixing separators, using ; in your if statement (international notation) and , in your substitute You CAN however have a Calculated Column outputted as HTML PROVIDED YOU SET THE DATATYPE TO NUMBER Then it is a matter of doing the replacement after the ...


0

Ok, I deleted the previous answer. Now I'm back in the office in a SP environment where I can test. This worked for me: =IF(OR([Project ID]="A1",[Project ID]="A1",[Project ID]="A1",[Project ID]="A1",[Project ID]="A2",[Project ID]="A2",[Project ID]="A2",[Project ID]="A2",[Project ID]="A3",[Project ID]="A3",[Project ID]="A3",[Project ID]="A3",[Project ...


1

In your code, there is a " missing before >Info. But anyway, calculated column don't allow HTML, because such thing would introduce security risk. So I would recommend trying CSR instead. In short, you'll have to create a small JavaScript file, upload it to portal, and attach it to your list via e.g. JSLink (Edit page -> Edit webpart -> Miscellaneous -> ...


0

there is a limitation for no of if statements for SharePoint calculated field. refer this article : http://office.microsoft.com/en-us/windows-sharepoint-services-help/introduction-to-data-calculations-HA010121588.aspx and best alternative to overcome your issue will be use choose statements or to use multiple calculated columns.and keep in mind that there ...


0

Instead of validating the result, you could validate each character being pressed : http://stackoverflow.com/questions/2812585/jquery-validate-characters-on-keypress


2

Probably one of the best ways to apply client-side validation in SharePoint 2010 would be to override PreSaveAction handler. PreSaveAction function is a user defined function that allows to override standard behavior for a Save button handler in List Forms on the client-side. Regarding validation expression, we could utilize /^[a-zA-Z]+$/ regular ...


0

Your comment says your date column is called [Shift Start Date / Time], so this calculated column formula outputs AM or PM: =TEXT([Shift Start Date / Time],"AM/PM") I tested this on a custom list and it works for me. SOURCE: http://office.microsoft.com/en-us/excel-help/text-function-HP010062580.aspx


0

"You cannot use Calculated columns to update on the viewing time. It only gets updated when you are adding or editing the item. So stop any further reading related to calculated columns." I disagree here. try pasting the exact line ="<button onclick=""alert('Hello World!')"">Click Me</button>" In one Calculated Column. SET THE DATATYPE TO ...


0

Malin is partly correct.... you cant just use [today] as sharepoint cant update on the current date of today as it needs another column that is updated on a daily basis.... you can try: 1) create a column and call it 'today', set it to date only, set it to todays date and save that column. 2) create another column called 'leaving date', this is for the ...


2

You could do this as a view. Just set the view to be filtered on Leaving Date < [Today], which will only show those who have left. I'm assuming you have a flag saying "Returned" or similar, which can be checked and then filtered out as well. It would be highly visible, as only the non-returned equipment/leavers will be displayed.


1

You cannot use Calculated columns to update on the viewing time. It only gets updated when you are adding or editing the item. So stop any further reading related to calculated columns.


0

tryout this. =[Start Date]+(8/24)



Top 50 recent answers are included