Tag Info

Hot answers tagged

9

Just to be clear: title is only "mandatory" if you create lists using the GUI. When you provision your own list using code or CAML you can create lists without Title. If you insert the formula =Me&" - "&TEXT(Today,"dd-mm-yyyy") into your calculated value, you should get something close to what you want. Be aware though that at any time the user ...


7

SharePoint does not support using today's date in a calculated column and the fields are not recalculated unless a value in the item changes. Here is a solution you could try using SharePoint Designer and conditional formatting: Create another calculated column to hold [Due Date]-3 (e.g. Warning Date) Create your [Almost Due] column and put your message ...


6

Create Calculated column called "UserName" and type in this formula =LEFT([Email Address],INT(FIND("@",[Email Address])-1)) Create Calculated column called "Domain" and type in this formula =RIGHT([Email Address],LEN([Email Address])-INT(FIND("@",[Email Address]))) It should work.


6

Unfortunately if you are trying to have this always show the current date and time, this won't work since Calculated Columns are not recalculated on viewing, but only on creation and modification. See this article: http://blog.pentalogic.net/2008/11/truth-about-using-today-in-calculated-columns/ However, if you are just trying to extract the time when ...


5

Partly inspired by this question, and partly because we developed a product that has this functionality, I've written a blog post (linked at the bottom) on how to achieve this. The summary is: JavaScript: Use a Content Editor Web Part. Designer: Create a custom view in SharePoint Designer (as already proposed by @Laurie). Code: Make your own custom field ...


5

You can add a calculated column to your list for [Effort] * [Percent Complete]. Unfortunately, you cannot create a view and select that calculated column for a Sum under Total. You can, however, create a Data View Web Part using SharePoint Designer and add the sum that way. Here is a post on how to Get the sum of a calculated column.


5

elcapitano, my tutorial should work: http://blog.pathtosharepoint.com/2008/09/01/using-calculated-columns-to-write-html/ A couple notes: in the above post, you'll find a link to a troubleshooting page there are several versions of the Text to HTML script, I recommend that you pick the latest one (v 2.1.1) here: ...


5

You can't use "volatile" functions like [Today] in calculated fields. The reason is that the values of calculated fields are only computed when the list item is created or updated, so unfortunately it is not possible to do what you require using a calculated field. You can "trick" SharePoint into allowing a [Today] expression in a calculated field by ...


5

Rewrite your formula with if-statements and nest them, something like this: =if(AND([Region1]="A",[Region2]="B"),"NO",if(AND([Region1]="C",[Region2]="D"),"YES","N/A")) The first if does the first test, if that statement doesn't hold: use the second if (nested in the first if).


5

Unfortunately, calculated column approach will not work as expected :( Calculated fields are updated only if the column itself is being updated, or the item is updated. You can fiddle with setting date to future in Windows to prove it. So I would recommend you to use XSL transformations for XsltListViewWebPart in conjunction with dateUtils.xsl from Marc D ...


5

In the Default option you can use [Today] plus some number of days... you would have to find the weekday as an integer, compare it to the weekday of Today as an integer, and do some math to get something to add to [Today] to make it next Friday. I'll see if i can find the right formula for it in the mean time. Edit: ok so you can use WEEKDAY([Today]) to ...


4

As you google around for this you are going to come across pages telling you you can do this with calculated columns using the [Today] trick. You can't, it doesn't work and isn't updated dynamically - and even if it were [Today] doesn't include a time component so X hrs is out. A couple of options for you Use a CEWP and JavaScript to modify the ...


4

My colleague has written up the different ways to get this sort of countdown/count up display to work in SharePoint, including JavaScript & CEWP SharePoint Designer and DVWP Visual Studio and custom code 3rd party (disclaimer, one of the options is from my own company) http://blog.pentalogic.net/2011/05/how-to-create-a-countdown-in-a-sharepoint-list/ ...


4

You are unable to change the types of Columns in SharePoint lists - simply because it's impossible to guarantee how to transform the data stored in one column type to another. What you can do, is create your Yes/No column, go to DataSheet view, and see if you are able to copy/paste the values from your calculated column over to the new Yes/No column.


4

Try this formula as default value : =Today+1+(9/24) this should do the trick :) times are stored as fraction, so using this method you can also specify minute, say you want to set default value as 9:30 AM then you can write =Today+1+(9/24)+(30/(24*60))


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

I used the following formula. Week starts on monday. Depending on your regional settings you have to replace the ; with , =IF(INT((StartDate-DATE(YEAR(StartDate);1;1)+(TEXT(WEEKDAY(DATE(YEAR(StartDate);1;1)-1);"d")))/7)=0;52;INT((StartDate-DATE(YEAR(StartDate);1;1)+(TEXT(WEEKDAY(DATE(YEAR(StartDate);1;1)-1);"d")))/7))


3

Create a calculated column and set the fomula to this: =[Start Date]+ROUND(DATEDIF([Start Date],[Due Date],"d")/2,0) This gets the difference between the 2 dates and divides by 2, rounds to the nearest integer, then adds the result to the start date. Here is a reference to formulas you can use in a calculated column: ...


3

As James sugesteed you should put = before your IF statement, but the main problem is that you can't use [Today] in calculated field, but there is a workaround: 1) Create a column caled Today - set it to DateTime and set it to display Today's Date 2) Now you can reference it in your calculated field 3) Remove Today Column and sharepoint will think that ...


3

We've recently released a free HTML Calculated Column; it acts just like a calculated column, but won't escape HTML: Pentalogic's SharePoint HTML Calculated Column Disclaimer: I work for Pentalogic; on this project actually. Oh, and I'm afraid you have to sign up for our newsletter, but that isn't a bad trade (in my unbiased opinion). :)


3

Formulas and functions depend on the language of your site. It's not just about commas vs. semi-colons, the function names will change too. You can play with this example: http://sp2010.pathtosharepoint.com/SharePoint-User-Toolkit/Pages/Color-Coding-Calendar-List.aspx Change the language, and you'll see how it affects the formula. For example, "IF" will ...


3

According to this, the Approval Status field is a lookup field and not applicable for calculated fields. My approach to the issue would be to create a separate calendar view of items with a filter of Approval Status = Pending. This way, approvers can toggle between the approved and pending data and easily distiguish what needs to be approved.


3

You'll want to use IF statements, look at this MSDN article or this Office document for references. It also helps to mock it up in Excel and then copy/paste it into the calculated column. Edit: just about had it figured out and Dribble beat me to the formula, nested Ifs which can go up to 7 deep.


3

I thought the limit in calculated columns was 7 nested IF statements per branch. You can concatenate several nested ifs to achieve your desired results. Are you using Christophe's color coded calendar tool to generate that? The calculated column looks identical, but I cannot make it generate the orange if, most likely it's bumping into the nested if ...


3

You can use Today with some trick, but the problem is that it will use the Today value from the day it was last modified. You'll then need to have something to modify the item each day/week/year, like a workflow. http://weblogs.asp.net/bsimser/archive/2009/03/18/aging-calculated-fields-in-sharepoint.aspx If its not used for any other logic, only for ...


3

Don't think you can do it with a calculated column, but you can use a list workflow to set a text field. Add a Set Field in Current Item action. Configure the value with User Profiles as data source and select the Name field from source. Then match the Account Name field (only option available) to the column with your User ID (assuming that the user id is ...


3

As @PirateEric said, you misplaced the parenthesis. If you are still getting an error after that, here are a couple things to check: your category name (is it [IssueCategory] or [Issue Category]?). your category must be a single choice. Multiple choice or lookup won't work To avoid mistakes, pick the field name from the fields listed in the right column ...


3

I assume you mean manually set the value of the field directly to something other than what the formula spits out, then no you cannot do that. If you need to do that type of thing what you can do is something like having a calculated field and a text field, and use the first to set the second. I would need to know more about your situation to give you a ...


3

Calculated value in Infopath is control, OOTB (out of the box), i.e. just visual container. Controls can be bound or not to data fields (and vice versa, it is possible to have data fields without there visual rendering). OOTB, when you drag'n'drop Calculated value control from ribbon in Infopath Designer (IPD), it is not bound to doesn't create a data ...


3

List and description of date functions you can use in calculated column formula can be found on MSDN: http://msdn.microsoft.com/en-us/library/bb862071(v=office.14).aspx In your case, the formula will obviously look like this: =DATE(YEAR([Column1]),MONTH([Column1]),DAY([Column1])-14) There Column1 should be replaced with the name of your expiry date ...



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