Tag Info

Hot answers tagged

5

If you only use this for display purposes, why not use a different approach which does not require you to do updates on the list item at all.... Create the site column in a sandboxed solution. Your column stores the Due date. Create a javascript file to deploy somewhere to your site, e.g. /Documents/duedate.js Configure the JSLink property in the site ...


3

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


3

You can create a view in the list which will show items based on the formula. For example, if you want to see items which have been created during Past 90 days, the formula will be Created is greater than or equal to [Today]-90.


2

I have changed the calculated column display format to "Date and time" "Date Only" Option. it will Right Align the values.


2

If both dates will always occur within the same year, then you only have to extract the year from one of the columns. The easiest way to do this should be to use a calculated column. Try this formula: =IF([StartDate]="","",""&YEAR([StartDate])) You'll need to choose "Date and Time" as your result type on the calculated column. This says that if the ...


2

Okay, I solved it. And you can't tell me it doesn't work, because I can see it with my own eyes :) So, that javascript you are running from that guy is unecessary, and it makes things more difficult that they should be. So you have three columns. One column has the status, one column determines the color, and the final column has the div tags. And it's ...


2

There is a calculated column 'trick' where you return a number type but use regular string concatenation and an html 'a' tag and the item will show up for you as a link Something like ="<a href='https://www.google.com?q='"&[searchColumn]&"'>click here</a>" You should be able to add your target _blank attribute using the above. EDIT: ...


2

It sounds like you shouldn't use a calculated column at all: It would probably be easiest to use the workflow to set the field value when that intermediate step is complete as is sort-of suggested in your link; to get it working in your situation you need to make the column you're using as a calculated one now a date or text type, then make a workflow or ...


2

It looks like you are using Spanish locale, you should separate with semicolons (apart from the fact that [Cumpleaños] will never be greater than itself): =IF([Cumpleaños]>[Cumpleaños]; [Cumpleaños]; [Cumpleaños])


2

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.


2

By far the easiest method to do this is to simply set the "data type returned from this formula" setting on your column to be "Number". Against all logic, this interprets your formula as HTML. I'm not sure if this works in 2007, but it certainly works in 2010 and 2013. Since there are 10,000 views on this topic and very few up votes, I'm guessing this is a ...


2

In english version of SharePoint it can be done with this: =MID("Hello(ABC)", 7, 3) There is a nice article: http://yalla.itgroove.net/2012/09/sharepoint-calculated-column-formulas/ A dynamic version would be =MID("Hello(ABC)", SEARCH("(","Hello(ABC)")+1, SEARCH(")","Hello(ABC)")-SEARCH("(","Hello(ABC)")-1)


2

You need to use HTML calculate column for this, please have a look at: HTML Calculated Column - Client Side Rendering For SharePoint 2013, simplest way is to use Client-Side Rendering (JSLink property).. Please have a look at following samples: Client-side rendering (JS Link) code samples


2

In my experience, this level of complexity is when it's time to try something other than a single calculated column. You can nest calculated columns to do some subtotaling, you can make custom columns that do complex calculations in server side code, or you could have a powershell script come through and calculate the column. Any function with 11 closing ...


2

It is easier if you build your Formula in partials/multiple Calculated Formulas, you can add a maximum of 48 Calculated Columns to a List and you don't have to use everyone in a View or Form. So create a separate Column "NumberStripping" with you Formula RIGHT(LEFT(SUID,FIND("=",SUID)-1),LEN(LEFT(SUID,FIND("=",SUID)-1))-1) That is the part you want to ...


2

Nicole, Danny's solution should also work. If you want to keep it in one formula, this should work. =IF(LEFT(SUID,1)=";",IF(ISERROR(RIGHT(LEFT(SUID,INT(FIND("=",SUID)-1)),LEN(LEFT(SUID,INT(FIND("=",SUID)-1)))-1)),"Enter the SUID on Package Pickup",RIGHT(LEFT(SUID,INT(FIND("=",SUID)-1)),LEN(LEFT(SUID,INT(FIND("=",SUID)-1)))-1)),"Enter the SUID on Package ...


1

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

Calculated columns in SharePoint does not allow updating a Date column when the day goes off. Which means that is static. So an option would be creating a timerjob which runs every midnight and update the list column. Else you can create a content query webpart which has an XSLT(type of XML) template. In that you can customize the template and make ...


1

I find that calculated columns are not suitable for complex html, especially links that involve javascript, which the modal dialog does. For these situations I create a DVWP in SharePoint Designer instead of a list view and build the call to the modal dialog in the DVWP.


1

Just add a conditional check for column A to be blank. =IF(A<>"",CONCATENATE(A,", ",B, " feet"),"") If A isn't blank, it'll return the concatenation, otherwise it returns an empty string.


1

=IF(AND([Task Name]="Task 2",Completed),1,0) Figured out with help from Tiac


1

Try this function, should work. =IF(AND([Task Name]="Task 2;[Status Field Name]="Completed");1;0)


1

It introduces other complications, but your best bet may be a lookup field. Create a secondary custom list called Countries. Then build a lookup column in the first list which references the Countries list values. Now your example will work the way you intend.


1

Okay, this is a very verbose answer, only because I cannot think of another way around this. I will try to answer this as easily as I possibly can (no offense to you, I don't mean to make it sound like I am trying to speak down to you, it just involves a lot of steps that involve arguments that will be different for me as they are for you. To answer your ...


1

Try following: =DATE(YEAR(Created)+3,MONTH(Created),DAY(Created))


1

You can do it using JQuery in new item form. Add a single line of text column to list, when new list item form opened, make calculations and set single line of text value.


1

I was able to find a solution by creating a single line of text column and in the "Calculated Value" section,I updated the below formula: =IF(DAY(Today)>15,TEXT(Today,"m"),TEXT(Today-16,"m")) With "number" column,the below formula worked: =IF(DAY(Today)>15,MONTH(Today),MONTH(Today-16))


1

You can't use the ID in a calculated column. You can try using a workflow to build a dynamic string and set a text field with the value you require.


1

Finally, I created a temporary column "Today" as suggested by Phil Greer, and ended up using the following formula: =IF(DATE(YEAR(Today);MONTH(Cumpleaños);DAY(Cumpleaños))>Today;DATE(YEAR(Today);MONTH(Cumpleaños);DAY(Cumpleaños));DATE(YEAR(Today)+1;MONTH(Cumpleaños);DAY(Cumpleaños))) Hope this helps!


1

First, you can't use "Today" in a calculated column in SharePoint, but there is a way around that: 1) Create a temporary column called "Today" 2) Setup your calculated column (with formula referencing the bogus "Today" column - see below) 3) When that's working, delete the temporary "Today" column (you have tricked SP into using Today's date) Test ...



Only top voted, non community-wiki answers of a minimum length are eligible