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


4

The problem is that calculated columns don't recalculate until an item is modified. So if nobody edits an item for 3 days after post-op, your calculated column will still show 0. You have 2 options within SharePoint: either show the op date and let your users calculate it in their heads, or create views that filter into 0-1 days post-op, 1-2 days post-op, ...


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

Since its SharePoint internal name, you should think of alternative name.. If its your development environment, I will suggest you add a column with different name let's say "CompanyYear", and than change the Display Name of the column back to "Year" In calculated columns you will refer it to as "CompanyYear"


2

=IF([Column A]="aaa",(IF([Column B]="bbb","12345","It's not good!")),"It's not good!") You can test SharePoint calculated columns in Excel by substituting the column names for cells. I tested this on a list and had successful results. Column A & B are both Single lines of text with C being the calculated column. Are you getting an error message or ...


2

As Aron mentioned if you wanted it to automatically update you'll need to configure something to periodically update the values. Some options: A SharePoint Timer Job that runs once a day to update the column. A PowerShell script to update the column that runs once a day via the Windows Scheduler.


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

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

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

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

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

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

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

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


1

I have used SharePoint Manager to check the resulting xml schema of a calculated field in one of my developing machine and compare it to yours. I can report that in my case the formula escapes the "<" and ">" characters as "&lt" and "&gt". Try something like this: <Field Type="Calculated" ID="{71D763F4-CD20-420D-9E0E-3B8D745B32B8}" ...



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