New answers tagged calculated-column
In English language environments no problem, in other languages I can not get it to work, no one has answered my question yet: How to save a Calculated Column Formula in Language Localized notation using REST or JSOM Scriptfile Extract the JSOM code (the REST version is way more code) you are after or execute in an existing Formula (FldEdit.aspx page) ...
Type =Me in the calculated value
Regarding the accepted answer: Stop linking to outdated and incorrect information about creating a [Today] column, linking to it and then deleting to it. It was allready explained in 2008 By Christophe it just does not work... For a complete explanation read: How to use Today and Me in Calculated column
A boolean column is a TRUE/FALSE value so =IF( [L6]=True , "" , "" ) is exactly the same as =IF( [L6] , "" , "" ) And... Since a TRUE value equals 1 and a FALSE value equals 0 You can use a Boolean in a calculation You state: so if L6 is False, the answer should be 0 Then your calculation can be: =[L6] * [C6] / 53 * [Column B] * .1 If you are ...
If column B is a choice that a user has to make, then you don't have to do any logic on it as they are supplying the value for you. The calculation is 10% of the value entered so it could be written as (untested): =If([L6]=True,[C6]/53*.1*[Column B]*.1,0)
Last date of the month (this works for leap year as well) QDate = August 2015 =DATE(YEAR(QDate),MONTH(QDate)+1,DAY(QDate))
You can fix that problem with an if =if(weekday(Today + 10,2)=6,Today + 10 + 2,if(weekday(Today + 10,2)=7,Today + 10 +1,Today + 10)
Top 50 recent answers are included