Tag Info

Hot answers tagged

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

You can use IF statements to convert the text to integer values: IF( [Frequency]="1 Month", DATE(YEAR([Calibration]), MONTH([Calibration]) + 1, DAY([Calibration])), IF( [Frequency]="3 Months", DATE(YEAR([Calibration]), MONTH([Calibration]) + 3, DAY([Calibration])), IF( [Frequency]="6 Months", ...


2

Alexandar, To answer all your questions/doubts.. ID Column in Calculated Column Excerpt from Microsoft documentation You cannot reference the ID of a row for a newly inserted row. The ID does not yet exist when the calculation is performed. Using SharePoint Designer Workflow There are many posts which show solution to this problem using SharePoint ...


2

Unfortunately not all column types can be used in a calculated column. As you suspected Person or Group columns, the column type of Created By, are not allowed to be used in calculated columns. I suggest that you use the solution that I gave for your previous question. The best that you can do is save the value into another column using a workflow though ...


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

Please try it like this: =IF([CompletedTask]=1, "Yes", "No") below is the reference for other formulas: Link


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.


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


1

According to this link it should be easy. Try this: =([COLUMN2] - [COLUMN1])*1440 This will return the total number of minutes between the two dates UPDATE


1

Do you want the 'Resources' to be clickable, or do you just want to show that there are resources attached to that item? To get the 'HasResources' column to work the way you want, I would actually display this list as a Data View Web Part, and use conditional formatting to display an image depending on the 'Resources' data. You wouldn't need to create ...


1

Nice example by our Marc D Anderson that covers both aspects of your question: Displaying Managed Metadata Column Values in an Email Sent from a SharePoint Designer Workflow If you have MM column called ColumnA you can use text portion of it in calculated field with formula: =LEFT([ColumnA],FIND(“|”,[ColumnA])-1)


1

SharePoint updates the value of a calculated field when you save an item OR when you change the calculation in the field setting. A workflow instance can not prevent a calculated field from being updated AFAIK, I've had plenty of instances with workflows running and the calculated fields worked just fine. I guess it might depend on what the workflow is ...



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