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

A calculated column only updates when the item is edited, not displayed.


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


2

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


2

I think your problem is with using a calculated field to check against [Today]. The calculation is only run when the item is edited - not when the item is viewed. See http://blog.pentalogic.net/2008/11/truth-about-using-today-in-calculated-columns/ What I would recommend is creating a calendar view for this list and changing your calculated column to ...


2

Following is an example of Calculated field schema: "<Field Type=\"Calculated\" " + "DisplayName=\"New_Field_Display_Name\" ResultType=\"Currency\" " + "ReadOnly=\"TRUE\" Name=\"New_Field_Internal_Name\">" + "<Formula>=Currency_Field_Name*100</Formula>" + "<FieldRefs><FieldRef Name=\"Currency_Field_Name\" />" + ...


2

My understanding is that you have three columns, one for the quantity ordered, another for the quantity delivered, and a third for the status. Each row in the list represents a single order, so may have 3 ordered, 2 delivered and a status of Partly Delivered. In your Status column, instead of using a calculated default column, make the column type ...


2

You can use some JavaScript to display an "expired" visual cue, but it will not map to any flag or value in your list metadata (so it's purely for show). In SP2013, use the JSLink parameter to hook a template override. See for example: http://code.msdn.microsoft.com/office/Client-side-rendering-JS-2ed3538a ...


2

I was able to recreate this issue. The fix is to have an empty space in the formula between the double quotes i.e. the formula should look like this: IF(Availability="Out of stock"," ",Item)


2

The easiest solution is to add a fourth column 'Nonstandard E-mail' in which people can enter an e-mail to be used in stead of the calculated. In your formula you have to check if that's empty and if not then use that value otherwise calculate like before: First Name | Last Name | Nonstandard E-mail | E-mail John Smith ...


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

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

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

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


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


1

How about this: replace [Rate1]="Low" with OR(ISBLANK([Rate1]),[Rate1]="Low") Same for Rate2, Rate3, etc.


1

You can create a new SharePoint list called "EExperience" with two fields: Title and Experience. Fill this list with the values for each title and the appropriate value in the experience field. Then go back to the employee information list and add a column called "Manager" that has the data type "Lookup". Follow the dialog and select the list "EExperience" ...


1

It shouldn't be too hard. Let's assume you have list A with a lookup to list B: create a workflow on list A create an update listitem step, say you want to update the current listitem, select the hidden field. For the value, select the Fx button and it will open up a dialog for you to go find the value. in this dialogue, in the first dropdown, select your ...


1

You can put a formula in the default value for a column. Don't set the field to be a calculated value. For example. I have a date on a Change Request form for the next CCB meeting date. It is always on a Monday. The field is a Date type, and I select the Default Value radio button and put in the following formula: =Today+(7-WEEKDAY(Today,2)+1) That ...


1

The answer is also simple.. you cannot :-) you need to put some javascript into business.. See this blog for inspiration.. http://1001sp.blogspot.dk/2014/02/fun-with-sharepoint-lists-and-forms.html I use jquery to hook onto a leave event, and then fill the next field with the information. I don't know if you are using SP2010 or 2013 but I'll soon ...


1

When you first create an item the ID is not allocated until it is written back to the list. The calculated column is calculated before the item is written back to the list and so the ID does not exist at that time. If you later edit the item then the formula will calculate the column correctly. An alternative I have used in the past is to use a workflow. ...


1

No a calculated column can only look at the data in the current row, it can not retrieve information from other rows to produce the result you are mentioning. You will need to achieve this result through custom code. This can be either server side or client side code with javascript to set the values of a text field based on this calculation.


1

The version of sharepoint is important here. If you are using 2010 or 2013 you should set your project ID field in list 2 as a lookup to project ID of list 1. When doing This You can select what additional fields you would like to display. Choose project name here. This will not copy the data from one list to another but when viewing items you will see the ...



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