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

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

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


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

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

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


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

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


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

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

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

try this: <Where> <Contains> <FieldRef Name="Mitarbeiter" /> <Value Type="lookup">ID of person</Value> </Contains> </Where> or <Where> <Contains> <FieldRef Name="Mitarbeiter" /> <Value Type="lookupId">ID of person</Value> ...


1

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


1

Did you put the "=" in front of the formula in the calculated field? See pictures below, it worked for me


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

You need to tell the column how to display the information. "MM/dd/yyyy" This is what I put on mine: ="Created on: "&TEXT(Created,"MM/dd/yyyy")


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



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