Search Results

You get a -42 thousandsomething number because a blank date defaults to the oldest past date SharePoint can represent, which is 31-21-1899 (or 1900?) So like the others answered you have to test for a …

Start with (and learn) getting your formulas right using Formulas in Excel. Most basic Functions are the same in SharePoint A list of SharePoint Functions and examples and references to Microsoft Docs …

=IF(OR([Status]="Planned",[Status]="Writing"),"5","30") Does not really do what you might think, it does (in human language): IF Status IS "Planned" OR "Writing" THEN 5 ELSE 30 You can accept …

I do not have a Formula for you, just some notes of the top of my head: Empty dates are interpreted True/False values, so IF([ExDate],HasDate,NoDate) is the same as IF([ExDate]="",NoDate,HasDate) TEX …

You can only have 7 nested IF levels... I have not tested it, but at first sight IF([External-ID-Hema]>999,CONCATENATE("18",[External-ID-Hema]), IF([External-ID-Hema]>99,CONCATENATE("180",[ …

Yes, ISBLANK is what you can use, or NOT(ISBLANK(AI217)) if you do not want to rewrite your formula too much. See https://www.365csi.nl/vm365com/365coach/#/Calculated_Column_Functions_List for the cor …

I interpreted your question in two different ways: . 1 - output a linebreak in a View You have 2 options in SharePoint 2013 to format output of the Calculated Column Calculated Column with HTML Y …

Calculated Formulas are processed before a new Item is written to the database where it gets an ID. That is why ID is empty for New items but has the correct ID when an Item is changed/updated. (or y …

Wouldn't it make more sense to display either Date in FieldA =IF( ISBLANK([FieldB]) , DATE(YEAR([End Date]),MONTH([End Date])-3,DAY([End Date])) , [FieldB] )

A Calculated Column Formula can only reference Simple types.. so No Lookup Columns, No People Columns and No Multiple Choice Columns You would need scripting to proces the contents of a filled Field …

I reformatted your formula with line breaks and spaces, makes it easier to spot problems, you can safely copy/paste to SharePoint because they will be ignored. Other poster allready noticed the error …

See: How to use Today and Me in Calculated column

As Eric said in the comments this is not going to work. Your syntax error can be fixed (provided you use SP2013 which has a Today() function) with: =IF(ISBLANK([DISCHARGE DATE]), TODAY()-[ADMIT DAT …

Do not try and built a complex formula in one go. Take it step by step; make LeaveType="Casual Leave" work first.. You have already written down the pseudo code in your description, Now... best do …

SharePoint is very loosly typed so Empty Strings 0 values Empty Dates FALSE are all False values =IF(AND([Col1]=0,[Col2]=0),"No","Yes") If this Formula outputs a Boolean You are saying: =IF(A …