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

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


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

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

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


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

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

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


1

Interesting friday evening challenge.. I took a completely weird approach process every row (when displayed) store the High, Low , Total and Average value on the body tag for every row done (they proces async) calculate the 3 segments (low,medium,high) between the Low Values calculate Average, match with low,medium,high color and color the Table (4 ...


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


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


1

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

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

You need to tell the column how to display the information. "MM/dd/yyyy" This is what I put on mine: ="Created on: "&TEXT(Created,"MM/dd/yyyy")


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

I tackled this problem from the other direction. I created a plain text field in my List called "UserName". I then created a Name (With presence) field, called "NameUser". Next I created a Workflow on the list to copy the plain text from "UserName" into the "NameUser" field. When I generated a WorkFlow email from the list, the bit that says "Dear ...


1

Did you put the "=" in front of the formula in the calculated field? See pictures below, it worked for me


1

Similarly, I was asked to set a field as the "Second Thursday of Next Month." Using this post as well as some other tricks I already know, I was able to come up with a formula (shared if other users get the similar request): =DATE(YEAR(Today),MONTH(Today)+1,(5-MOD(WEEKDAY(DATE(YEAR(Today),MONTH(Today)+1,1)),7)+8)) Because you aren't adding the values to ...



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