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

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

Calculated columns cannot refer to people fields so not sure they are going to help you. A workflow could split off the domain from the Created By user and add it to a Single Line of Text column? Alternatively, could you just get whoever is uploading the document to set which company they are from using a choice field?


2

It can be done in InfoPath or via SPServices. You are looking for cascading dropdown functionality. You can do the SPServcies route by embedding a web part onto the page (the old ?pageView=Shared&ToolpaneView=2 query string parameter trick) and reference jQuery and SPServices from a local document library.


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

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

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.


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

A similar question was asked on StackOverflow: Any solution to the Today Calculated Column problem is SharePoint? There simply isn't a work around for this. As the values for the list are stored in the database and returned "as is" to other featurs such as the search crawler, a dynamic field cannot be created. It is possible to create a custom ...


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


1

Calculated columns only work with data in the same item. You cannot do SUMs or other calculations that require data from other items in the list. You could, however, accomplish what you are looking for by using the Grouping options in your view of the list. You can group by the date and then you will get a count of the items in that group.


1

Try Console.WriteLine("{0} -- {1}",item[SPBuiltInFieldId.Department] == null ? "N/A" : item[SPBuiltInFieldId.Department].ToString(), item[SPBuiltInFieldId.Office] == null ? "N/A" : item[SPBuiltInFieldId.Office].ToString()); In the event receivers you can set those two columns. With calculated columns would be great but as far as I know that's not ...


1

Found the answer. By using =ISBLANK([ColumnName]) and =NOT(ISBLANK([ColumnName])) and setting Calculated Column to return Yes/No values I was able to achieve what I wanted. Update Be aware that when you try to get the values from the column using the above setup the code will return Yes/No values. So to check if the column contains "true" or "false", var ...


1

I can't test this, but this and you didn't include your errored statement so I can only give you the tools to solve your problem. For reference, here is the documentation on the IF Function in SharePoint: http://office.microsoft.com/en-au/windows-sharepoint-services-help/if-function-HA001161010.aspx In case that link ever dies in the future, here's the ...


1

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


1

I am seeing the same issue after we just upgraded a customer to 2013. Pretty much the same issue. We have a calculation using the LEFT function to get the first letter of a title so that we can group from A-Z. By opening the calculated column settings and just clicking OK it fixes it. But the problem keeps coming back after anything is edited. Would ...


1

Calculated columns don't work "vertically" in the library, only "horizontally" that is they cannot be used to determine something about any other items, only the current item. You could set a process number via workflow, event receiver, or possibly use the document id feature which gives each document a unique id apart from the list item id.


1

Keep the lookup column for the end user to make a choice. Create a new single line of text column and use an SP Designer workflow to format it as Last Name, First Name. This new text column will be available to use as a filter in a view. You can also use Designer to remove the column from the form so that its only used in the background and cannot be ...


1

I had to create a retrieve data connection, FetchID, to fetch the ID column. Then in submit data connection, I used this formula: xdMath:Eval(xdMath:Max(xdXDocument:GetDOM("FetchID")/dfs:myFields/dfs:dataField‌​s/d:SharePointListItem_RW/d:ID), 'concat("Car Insurance Request [ID: ", (d:ID or 0) + 1, "]")'). Hopefully it will help someone.


1

In your InfoPath form create a data connection with type: Submit Data, while creating it, system will ask for the Document Library and select the doucment library and next to that you will get a field called "File Name" with expression button, Click on the Expression button and there you can specify the formula/Expression to specify how the file names should ...


1

If the column name is "NoSpace", the validation formula is: =ISERROR(FIND(" ",NoSpace)) This is the NewItem form:


1

This doesn't seem strictly doable with out of the box SharePoint features. As per my comment, I don't get what is the final effect that you want to accomplish you need to insert the invoiced amount on the PO Master and DISPLAY it on the Invoice Master, insert on Invoice master and display on PO master or do you need to support insert/edit of the value ...


1

Maybe you should not look at it as a "Computed column" to avoid further confusion, but rather as a Read-Only column (use ShowInNewForm, ShowInEditForm with FALSE in your list schema) and complement this with an OnItemUpdated list item event handler to update the value programatically - examples - programatically - ...



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