Hot answers tagged

6

To average multiple columns in an item, you'd use a calculated column such as =AVERAGE([Column1],[Column2],[Column3]). To average a column, edit the view and expand the Totals section. By your column name, if it's a number, you can select average (etc) from the dropdown.


3

Regarding the error you are receiving, if you are using different regional settings than English in your site, try to replace all the commas (,) to semicolons (;). You could make a easier calculation to. This one returns the number of days, hours and minutes between the 2 dates. =TEXT([Fin Diag]-[Debut Diag];"d:h:mm") Update Tried out your calculation ...


2

=IF([Fecha01]>[Fecha02],(DATEDIF([Fecha01],[Fecha02],"D")-IF(WEEKDAY([Fecha02])=7,FLOOR((DATEDIF([Fecha01],[Fecha02],"D")+WEEKDAY([Fecha01]))/7,1)*2,FLOOR((DATEDIF([Fecha01],[Fecha02],"D")+WEEKDAY([Fecha01]))/7,1)*2+1)+IF(WEEKDAY([Fecha01])=7,2,1),0)


2

=MONTH( "January" ) will not return a value because SharePoint doesn't have a clue what you meant You have to convert the Month TEXT to a valid Number (january=1 in SharePoint) IF([column]="January" , 1 , [column]="Feb2" , 2 , ...


2

You can do it by jslink. Make one js file (ex. ViewMonth.js) and add following code: Replace your column name instead of MonthNum and month (function () { var monthctx = {}; monthctx.Templates = {}; monthctx.Templates.Fields = { "MonthNum": { "View": setmonth } }; ...


2

What you need is a formula at list item validation. Go to list settings, and find validation settings. The formula you need to use should be something like the below one: =IF([Status]="Closed",IF([Date Closed]=Today(),TRUE,FALSE),TRUE) Instead of checking the [Date Closed] to be today only, you might want to just check [Date Closed]>=Today(). Or, if ...


2

One way to achieve this - Assuming data is in the correct format in all cases =LEFT((MID(CountryWF,FIND(":",CountryWF)+1,LEN(CountryWF))), FIND(":",(MID(CountryWF,FIND(":",CountryWF)+1,LEN(CountryWF))))-1)


2

There is no "formula" that can send an email. You can use a formula to calculate a value in a column, and that value can look like an email address. Such a formula might look like =IF([ChoiceField]="jack","jack@abc.com",IF([ChoiceField]="bob","bob@abc.com","tom@abc.com")) If you have more than three choices you need to nest more IFs. If you want to send ...


2

When you subtract a date field from another date field in a calculated column, the result is given in days. You can therefore multiply the difference by 24 to get the result in hours, so your formula would likely look like this: =24*(End-Start) Make sure to set your calculated column to return a number instead of text.


2

Change your calculation to =24*(start-end) and set the column type to Number with 1 decimal.


1

None of these answers work. Did anyone bother to test them? After looking elsewhere and working it out myself, here's what works: =TEXT([Start Date],"mm/dd/yy")&" - "&TEXT([End Date],"mm/dd/yy") You can adjust the way the date shows by using the mm/dd/yy part, which is intuitive.


1

=IF( AND( [Prior Status]="Green" ,[Current Status]="Yellow" ) ,"Value if true" ,"Value if false" ) =IF( AND( [Prior Status]="Green", [Current Status]="Yellow" ) ,"Value if true" ,IF( AND( [Prior Status]="Yellow", [Current Status]="Red" ) ...


1

In SharePoint Formulas only double-quotes " are string delimiters '<A href="#"><span class="fa-stack fa-lg"><i class="fa fa-square-o fa-stack-2x"></i><i class="fa fa-download fa-stack-1x" data-toggle="tooltip" data-placement="bottom" title="Download this File"></i></span></A>' Must become: "<A ...


1

Check if one of the value is empty, if it is, return blank, else calculate the difference. =IF(OR(ISBLANK([Date 1]),ISBLANK([Date 2])),"",DATEDIF([Date 1],[Date 2],"D"))


1

Since SharePoint doesn't really care about Types. Blank Dates values are False values, and valid Dates are True values, So Erin was the closest, just had a too long Formula =IF( AND([Date 1],[Date 2]) , DATEDIF([Date 1],[Date 2],"D") , "" )



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