Hot answers tagged calculated-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))
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 ...
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
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
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 ...
3
I think that the only way to do this is to add a test to your formula that says "if this item is older than [Date], then use 3m else use 9m".
BTW, I'm not sure that your formula is going to work the way you want it to when you get to months >= 4. It looks like you will then get month 13.
2
Give this a try. Just based on your input as I don't have this mapped out anywhere to test:
=IF(OR([Boolean A]='No', [Boolean A]='Yes'), IF(AND(LEN[Text B] > 0, LEN[Text C] > 0), "READY", "NOT READY"))
Maybe this is better!
=IF(OR([Boolean A]='No', AND([Boolean A]='Yes', AND(LEN[Text B] > 0, LEN[Text C] > 0)), "READY", "NOT READY"))
2
If you want a view of overdue tasks which have not been completed, you do not need the start date. You need the current date, and the Target Completion Date. If current date > Target Completion Date, the task goes on the list.
Not sure why you're referring to End Date (Actual End Date). Once there's an Actual End Date, that means the task is done - it was ...
2
Nope. In Infopath, OOTB, it is possible to access only data (from data sources or data fields) not control's values.
Update:
And calculated value control in Infopath has an expression (based on values of other data fields or data sources) as its data source but is not and cannot be (without converting it to another type of control) bound to a "its own" ...
2
Unfortunately [ID] isn't actually a supported field in calculated columns.
When a new item's values are being processed it doesn't yet have an ID, so the calculated field has nothing to work with. Since it's the same code that recalculates the item's values on edit, it doesn't bother looking for the ID then either.
However, when the calculated field is ...
2
Column2:
=LEFT(Column1, 2)
Column3:
=RIGHT(LEFT(Column1, 4), 2)
FYI
Calculated columns use formula from Microsoft Excel... So if you want to generate formula for Calculated Columns easy way is to generate formula in Microsoft Excel first!
I hope this helps
2
SharePoint uses Excel formulas (and same engine to parse them) for calculated fields. And as you probably know, Excel uses localized formulas.
Thus, when trying to define formulas through GUI and having non-english site, you should use the localized version of function names and ";" instead of commas. This definitely brings some confusion, because this fact ...
2
I finally succeeded in setting up my formula. In fact, I add to face two actual issues.
The first issue is that the ContentTypeId is of type ContentTypeId which is one type that is not supported by the formula columns.
In order to solve this issue, I add to create a new column, ContentTypeIdCopy, of type text, which is the copy of the content type value. ...
2
How long is an item considered new for?
You could create a custom column (Age) that defaults to a value "NEW" and then test that in your calculated column to decide whether to set to 9 months.
You would then need to either manually or with a workflow, change the column Age to "OLD" and you calculated column would set these to 3 months.
1
I think the problem is that you're not from US or UK :) This is a known issue with calculated fields: since they use the same engine as MS Office for formulas in calculated columns, you have to use same formulas syntax, and the thing is, as you might have noticed, in Excel your formulas are localized. So you should use localized formulas: i.e. ";" instead of ...
1
No you're not. Retention policies won't recognise a calculated date even if it's set to date/time format.
A good way around this is to shift the date calculation into SharePoint Designer. Use the "Add Time to" action to subtract 14 days (-14) from your deadline day and output this to a variable. In the next step, pause the workflow until then and your ...
1
Why don't you replace ColB in ColC formula wiht ColB formula like ColC(=(ColA-12%)-10%)
Also, if you need help in calculating percentages.. The Calculate Columns actually use Microsoft Excel based formula's so you can take help from here:
How to do percentages in Excel
1
I don't think that a calculated item will work in this case as any column that references the file path is not available in the calculated column arsenal. You could use a workflow on item creation and item edit to update a text field leveraging some of the internal fields (like Server Relative URL, Path, or URL Path).
1
This article is a bit dated, but it shows you how to properly do HTML in your calculated columns: http://blog.pathtosharepoint.com/2008/09/01/using-calculated-columns-to-write-html/
I would avoid using the number column method as your alignment issues would be impossible to fix adequately without affecting other columns.
1
Thanks you for the suggestions.
Here's the working solution: I had to create a xsl:stylesheet for the field. (The View stayed as before). The xsl I had to deploy in the sp-folder
"{SharePointRoot}\Template\LAYOUTS\XSL"
My Template looks like this:
<xsl:stylesheet xmlns:x="http://www.w3.org/2001/XMLSchema"
...
1
If you look in SharePoint Columns – Features and limitations you'll see that you can't use Hyperlink columns in a calculated field.
Your options are to use an Event Receiver or a workflow update a text column with the coumputed value.
1
Create a new list with the currency codes and conversion values, and use a lookup column to pull the right values. This will scale far better, anyway, since conversion rates are far from constant.
I'd also suggest that you implement the lookup column as a Site Column so you can use it later in additional locations in your Site Collection.
Just because we ...
1
If you create the column in Visual Studio, you can make it to a calculated field and then seal the column.
EDIT:
Here's one i have in my sollution.
<Field ID="{CAB6736A-8254-43E4-B4EA-905B487CA9AD}" Group="TF Intranet" Type="Calculated" Name="TFHyperlink" ResultType="Number" DisplayName="Vís" Sealed="TRUE">
<Formula>="<a ...
1
There are any number of ways you could do this, but all will involve some custom code:
You could put event receivers on the Tasks list that update an "Actual Time" field on the Projects list whenever a task changes.
You could write some client object model javascript on the view page that would fetch all of the calculations in real time and display them ...
1
Create a Single-line of text column and make it as hidden. Through event receiver populate its value in your desired pattern (e.g. Dear Joe Bloggs, Jane Doe, and John Doe) from the "Person or Group" column. And use that new column in the workflow instead of "Person or Group" column. I know there is a overhead of writing event receiver but you will be able to ...
1
I wrote an article a while back about the different methods for creating a CountDown on a list view, which is essentially what you're looking for:
Warning: This also mentions our own product as a possible solution
How to create a Countdown in a SharePoint list
Here is a summary of the options:
JavaScript: Use a Content Editor Web Part.
Designer: Create ...
1
Did you google "dynamic value of today sharepoint" ? You can see that this topic has been discussed again and again, in MOSS and SP2010.
There is a workflow with loop "solution" :
https://sites.google.com/site/sharepointhill/tutorials/mssp/sp-dynamic-today-date
Or a XSLT "Solution" :
...
1
You can do this with SharePoint Designer. Like any view, you have a little more flexibility when you edit the CAML directly. Unfortunately, the Calendar view format causes the CAML to be fully escaped and makes it less straight forward.
Create a new view using the Calendar View view format. Specify all the options you want. Change the Default scope to Day.
...
1
Please have a look at following article
Using calculated columns to add color coding to your SharePoint lists
There are a variety of ways to add color coding to your SharePoint lists and document libraries, from embedding custom code on your page to creating data view web parts with conditional formatting in SharePoint Designer. The trick is determining ...
1
You can extend the use of those calculated columns to provide the color coding you need. With the help of CEWP, you can use the calculated formula to provide additional formatting and the formula will determine which color the value will be.
You need the a script to load on a CEWP and make changes to the calculated column.
Check out this link to follow ...
Only top voted, non community-wiki answers of a minimum length are eligible
