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


2

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


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

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

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

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


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


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


1

What you describe is a ceiling function. SharePoint does not have such a function, but you can roll your own with the Roundup function. Create a calculated column and use this (replace "TheNumber" with your number column). =ROUNDUP([TheNumber]*2,0)/2


1

Try this =IF(DATEDIF([Column1], [Column2],"d")>14,"No","Yes") source


1

Even though your calculated column has the correct type ("number") in SharePoint, you may need to explicitly cast the variable to type number. That's much easier than it sounds. Do the following in SPD: Setup your condition and style the way you want them Go into Code view and look for <xsl:attribute name="style"> Change your condition from ...


1

Try this: =REPLACE([YourColumnname],FIND(";",[YourColumnname]),1," AND ") This should get you going in the right direction. Calculated Field Formulas The column "NewColumn1" is using the exact formula as above, and was created from the SharePoint Designer. I Don't know why it did not work from the UI. I'm using the default language pack. REPLACE ...


1

If you want to have only one calculated column where all the conditions, you must put next condition in statement else previous conditions. For you conditions example: IF(Service="ACB",(IF([Fac/Fellow]="Faculty","002701284","")),(IF(Service="Surgery",(IF([Fac/Fellow]="Fellow","002701294","")),"")))


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



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