New answers tagged

1

I think this maybe what you are looking for but we completely need more information like "What you are really looking to accomplish;" Try... =IF([Modified]>[ColumnA], [Modified], IF([ColumnA]>[ColumnB], [ColumnA], [ColumnB]))


0

SharePoint does not record when a COLUMN value changed; if you need that you must create a Workflow and do the administration yourself If you mean you want the maximum value of the 3 columns: DateA or DateB or Modified (SharePoints last registered anything-in-the-ITEM changed) it is: =MAX( [DateA] , [DateB] , [Modified] ) ...


1

Column C formula is =IF([ColumnA]>[ColumnB], [ColumnA], [ColumnB])


2

You can use the MAX function and output it in Date format. =MAX([date1],[date2]) If the two dates are blank, it will output a default date in 1899, so maybe put in a IF condition in there.


0

It is not the datediff that is causing the problem. That function does return 0 when you have the same date with different times. I am not familiar with the formula that you used but I noticed that it is adding 1 day to the datediff result. Tested the formula without the +1 and it looks OK. Give it a try (replace the column names before, and I had to ...


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") , "" )


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"))


0

IF(AND((NOT(ISBLANK([Date 1])),(NOT(ISBLANK([Date 2]))),DATEDIF([Date 1],[Date 2],"D"),"")


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

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


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

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 ...


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.


0

Are there more values that are category specific? I see three options: The simplest way to do this is simply creating 3 content types. Each content type is a category. You can give different columns to each content type/category so each has a different set of form options. You could also try using a survey, it has some options to display and hide specific ...


0

You could use SharePoint item IDs. Your calculated column would look like this: =([ID-1]/3)+1 Example: ID RESULT 1 1 2 1 3 1 4 2 5 2 6 2 7 3 8 3 9 3 10 4 ... ... The problem with this is that it has to be a fresh list to start from ID value 1. (for example if you ...


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)


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 ...


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)


0

To get the time as a fraction of an hour then you'd do ([Start Time]-[End Time]) * 24. Start Time | End Time | In H:MM | In Fraction ------------------------------------------------ 14:00 | 14:05 | 0:05 | 0.083333333 14:00 | 14:10 | 0:10 | 0.166666667 14:00 | 14:15 | 0:15 | 0.25 14:00 | 14:20 | 0:20 | ...


0

=IF([Status]="Approved",LEFT((TEXT([End Time]-[Start Time],"hh:mm")),2)+(RIGHT((TEXT([End Time]-[Start Time],"hh:mm")),2)/60),"") (return as number with 2 decimal points)


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.


0

what is your return type? Try Number to make sure it renders the HTML. Also use semicolons in between your parameters, not commas. ="<span style='height:1ex;width:"&(10*1)&"px;border:1px green green;background-color:"&IF(Rating="Goals ...


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

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 } }; ...


0

Try this: Hours Calculation: =([COLUMN2] - [COLUMN1])*24 This will return the total number of hours between the dates


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 , ...


0

When used in a Calculated Column Formula (set tot datatype=Number/DateTime so it outputs as HTML in A View (and View only)) you have to escape the "(double quote) properly: ="<a onclick=""javascript:location.href='UploadDocuments.aspx' + location.search"">Save</a>"


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" ) ...



Top 50 recent answers are included