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


5

By far the easiest method to do this is to simply set the "data type returned from this formula" setting on your column to be "Number". Against all logic, this interprets your formula as HTML. I'm not sure if this works in 2007, but it certainly works in 2010 and 2013. Since there are 10,000 views on this topic and very few up votes, I'm guessing this is a ...


3

You can create a view in the list which will show items based on the formula. For example, if you want to see items which have been created during Past 90 days, the formula will be Created is greater than or equal to [Today]-90.


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


3

You are asking for a No SharePoint Designer and SharePoint 2010 solution. It can be done in a Calculated Column without the use of any other Webparts like documented on the blogs the other answers refer to. The technique is documented at http://www.viewmaster365.com/#/How The cons of this approach are also documented. But it ain't easy; Calculated ...


3

Formula will be something like this: =IF(OR([Column3]="5", [Column3]="6"), [director approval date]-[finance approval date], "-") Here is the reference Example of common formulas


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 cannot use Calculated columns to update on the viewing time. It only gets updated when you are adding or editing the item. So stop any further reading related to calculated columns.


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

Nicole, Danny's solution should also work. If you want to keep it in one formula, this should work. =IF(LEFT(SUID,1)=";",IF(ISERROR(RIGHT(LEFT(SUID,INT(FIND("=",SUID)-1)),LEN(LEFT(SUID,INT(FIND("=",SUID)-1)))-1)),"Enter the SUID on Package Pickup",RIGHT(LEFT(SUID,INT(FIND("=",SUID)-1)),LEN(LEFT(SUID,INT(FIND("=",SUID)-1)))-1)),"Enter the SUID on Package ...


2

It is easier if you build your Formula in partials/multiple Calculated Formulas, you can add a maximum of 48 Calculated Columns to a List and you don't have to use everyone in a View or Form. So create a separate Column "NumberStripping" with you Formula RIGHT(LEFT(SUID,FIND("=",SUID)-1),LEN(LEFT(SUID,FIND("=",SUID)-1))-1) That is the part you want to ...


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


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

=[START DATE]+[ETC] + ROUNDDOWN([ETC]/5,0)*2 + IF(WEEKDAY([START DATE])+MOD([ETC],5)>=7,2,0) - ROUNDDOWN(WEEKDAY([START DATE])/7,0) + IF(AND(MOD([ETC],5)=0,WEEKDAY([START DATE])=1),-2,0) + IF(AND(MOD([ETC],5)=0,WEEKDAY([START DATE])=7),-2,0) Here's where I copied this from.


2

You cannot use it as a number. You have to "convert" your value to numeric in order to make the validation, otherwise it will be "false". You can use the VALUE function to convert a text representation of a number, or simply add a number to your value to get it interpreted as numeric. =IF([ChoiceField1]+0<=2, 0, {nested IF if false}) or ...


1

The next option with you is to create a Workflow using SharePoint Designer. Run the workflow on item create and item update. Change the field FinalDate to a DateTime Create a new workflow and attach it to the List in question In the workflow using DateFunction you can add the value into a variable Use Update Current Item activity and update field ...


1

You will need to have 1 column to store information then another for the calculated value. Using a workflow, you would log the modified date in your first column when the status is set to complete. Then your calculated column would be something like =[Column1] - [Created]


1

It'd be something like this: =IF(ISERROR(RIGHT(LEFT(SUID,INT(FIND("=",SUID)-1)),LEN(LEFT(SUID,INT(FIND("=",SUID)-1)))-1)),"Please Enter the SUID Only on Package Pickup",RIGHT(LEFT(SUID,INT(FIND("=",SUID)-1)),LEN(LEFT(SUID,INT(FIND("=",SUID)-1)))-1)) http://msdn.microsoft.com/en-us/library/office/bb862071(v=office.14).aspx


1

Two options Create a timer job which runs daily and updates the list items Create a workflow which fires daily and updates the list items Option 1 is straight forward and easy to implement. Option 2 don't require any deployment and you can use SharePoint Designer to achieve this, but building it is tricky.


1

A default value formula cannot reference another column because the list form does not support a dynamic recalculation of the default formula. If you need to set a default value based on another column, and still have that user editable, you can use InfoPath to customise the form, or if you don't have that, use Javascript / jQuery to set the field.


1

You need SharePoint Designer. If you have not used it before, it may be a bit daunting. Here are the general steps: Open the site with SharePoint Designer, then open the list. In the Settings page, find the panel for the Workflows and add a new workflow. Edit the workflow and add an action that sets a field's value. You may need a few steps to extract the ...


1

I don't have enough Rep to comment on the other answer but Calculated fields are updated at SAVE time. Your Javascript idea could work if users viewing the list have permissions to update the items, otherwise it might update, or might not update. Since you don't have SPD you don't have many other options but you can try designing a reusable workflow in ...


1

Caluclated Columns will be calculated each time they are displayed. You don't have to update items. :-) The problem is your formula. Why do you try to convert it to INT? SharePoint has very nice Calculated Field Formulas, see http://msdn.microsoft.com/en-us/library/office/bb862071%28v=office.14%29.aspx A working example would be: ...


1

You're using TEXT, which makes it un-sortable. You'd have to be using =DATE(MONTH(Modified),DAY(Modified),YEAR(Modified)) or similar. I doubt you can get the behavior you're looking for with the 'long month' without setting all your dates to this format (regional settings).


1

I think this is the answer ? =IF([Category]=”red”,IF([EmployeeName]=””,FALSE,TRUE),TRUE)


1

Regardless of which character is used when the field is created, the formula works on lists in SharePoint websites anywhere in the world. SharePoint automatically changes the delimiter character to the one that is appropriate for the language/culture of the current page. In some countries, the comma is reserved for use as the decimal mark. In such ...


1

Interesting friday evening challenge.. I took a completely weird approach process every row (when displayed) store the High, Low , Total and Average value on the body tag for every row done (they proces async) calculate the 3 segments (low,medium,high) between the Low Values calculate Average, match with low,medium,high color and color the Table (4 ...


1

A lot is wrong in your code. SUBSTITUTE does not exist for Calculated Columns Besides that, you are mixing separators, using ; in your if statement (international notation) and , in your substitute You CAN however have a Calculated Column outputted as HTML PROVIDED YOU SET THE DATATYPE TO NUMBER Then it is a matter of doing the replacement after the ...


1

In your code, there is a " missing before >Info. But anyway, calculated column don't allow HTML, because such thing would introduce security risk. So I would recommend trying CSR instead. In short, you'll have to create a small JavaScript file, upload it to portal, and attach it to your list via e.g. JSLink (Edit page -> Edit webpart -> Miscellaneous -> ...


1

Ok, I deleted the previous answer. Now I'm back in the office in a SP environment where I can test. This worked for me: =IF(OR([Project ID]="A1",[Project ID]="A1",[Project ID]="A1",[Project ID]="A1",[Project ID]="A2",[Project ID]="A2",[Project ID]="A2",[Project ID]="A2",[Project ID]="A3",[Project ID]="A3",[Project ID]="A3",[Project ID]="A3",[Project ...



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