Tag Info

New answers tagged

0

I believe it is blowing up on the MID expression, it isn't supported. Note Microsoft SharePoint Foundation formulas for calculated fields are based on Microsoft Excel functions and syntax. However, Microsoft supports only those functions mentioned on this page for use in SharePoint Foundation calculated fields. For example, the Excel function MID ...


0

Fixed it by the below formula: =IF(WEEKDAY([Effective Date])>4,CONCATENATE(TEXT([Effective Date]+(5-WEEKDAY([Effective Date])),"mm/dd/yyyy")," - ",TEXT([Effective Date]+(11-WEEKDAY([Effective Date])),"mm/dd/yyyy")),CONCATENATE(TEXT([Effective Date]-(2+WEEKDAY([Effective Date])),"mm/dd/yyyy")," - ",TEXT([Effective Date]+(4-WEEKDAY([Effective ...


0

On vacation at Land's End (UK) I had some spare time to work on working code. First of all, the tested and tried SP Workflow method of writing the ID value to another Column is the preferred method, as it runs server side and thus garanteed to execute. As OP states he can not use Designer or any other type of CSR coding it is possible to do it with ...


0

You can also use Today() or Now() Above function also gives todays date


0

Using a calculated column isn't really a good way to solve the problem you're describing... You suggested that you want to change or reformat the column header based on a value change in a list. The primary (logical) problem with your idea of using calculated columns is that even if you were able to get the calculated column to set itself to the value of ...


0

Your options are either: Create a Workflow starting on Item added/changed Create a (Remote) Event Receiver associated with ItemAdded and ItemUpdated Put JavaScript into the New/Edit form


1

You can use below formula =CONCATENATE("FY",YEAR(Date+274)," Q", IF(Month(Date)>10,1,IF(Month(Date)>7,4,IF(Month(Date)>4,3,2)))) Logic CONCATENATE can be used to form formatted TEXT First find FY - So here we can use the same Excel formula FY + Year(Date+274) To calculate Quarter - We need to use IF statements. It take form ...


0

I agree with Eric that LOOKUP is not a usable formula for calculated column. This is the formula I have used for displaying "Q# YYYY" format for a date column: =IF(ISBLANK(TestDate),"",(CONCATENATE("Q"&(INT((MONTH(TestDate)-1)/3)+1)&" "&(YEAR(TestDate)))))


0

I don't remember Lookup being an allowable formula in the calculated column syntax. I think you'd need to replace those with Ifs. This is my go to article for calculated column references. If you break the formula into separate pieces, you should see it work for both year and quarter. To make it easier, you can create the if branch in a separate column, ...


0

To get the number of days between two dates in a calculated column we use this: DATEDIF([Today], [Column1],"d") See here a reference on calculated column formulas. BUT, using [Today] is pointless in a SharePoint calculated column because the value of it will only change when the item is changed. See here loads of resources on how you can get around this ...


1

You can use a calculation for this. Create the column reminderdate as a calculated column of the Date and Time type. Then use the following calculation: =DATE(YEAR([dueDate]),MONTH([dueDate])+4,DAY([dueDate])) If you are using another regional language than english, you may have to replace all commas (,) with a (;). Every time the column dueDategets a ...


1

As you cant use the People or Group Column in the formula, i think the workaround is: create another text column create a workflow which will copy the items from people or group column into text column. Now use the Text column in your formula. You can exclude that column from your view to avoid the misunderstanding.


0

The ID used in Calculated Column Formulas is 0 for newly created items (because it gets its value from the database after all Formulas are evaluated on new item creation) [Update: regular SharePoint method is to have a workflow write the ID value to another Column; this can be done with Javascript code as well] You mention you do not have access to ...


0

I copied/pasted your formula, multiple issues: DAY/MONTH/YEAR function are not required as they extract a day/month/year from a valid Date adn you are working with textstrings. DATEDIF function calculates from a past date to a more recent date, not the other way around (I did not know this either) So =datedif(date(1980,2,1),date(1980,1,1),"D") gives an ...


0

easiest way is to create a column and set it as person/group and choose show name(with presence) option. Now just create a workflow to set created by field(or whoever who want to display full name) name to above created new name column


0

If you are very sure those 10 values are unique you can do it with a String comparison: =IF( ISNUMBER( FIND( "Six" ,"OneTwoThreeFourFiveSixSevenEightNineTen" ) ) , "Something" , "Nothing" )


0

You need to do it the hard way =IF(OR(MyField="1",MyField="2",MyField="3",MyField="4",MyField="5",MyField="6",MyField="7",MyField="8",MyField="9",MyField="10"),"Something","Nothing")



Top 50 recent answers are included