New answers tagged

1

Resolved. Fixes: ISBLANK function requires parentheses around the value it's affecting: ([Certificate Date]) and [DATEDIF(Certificate Date)]>365, needs to have parenthesis around it as well. Final formula: =IF(ISBLANK([Certificate Date]),"Missing",IF(([DATEDIF(Certificate Date)]>365),"Expired","Good"))


0

You can achieve this by following below steps: Create Calculated column: use formula like below: =IF([ChoiceField]="Choice1", "https://siteUrl/PicLibrary/Image1.extension", "https://siteUrl/PicLibrary/OtherImage.extension") For multiple conditions you can use Nested IF: =IF([ChoiceField]="Choice1", "https://siteUrl/PicLibrary/Image1.extension", IF([...


0

I replicated this issue : I created site column Added the site column to a list Created a Calculated field, as site column It'll tell me the column doesnt exist Solution : Create a column inside the list instead


1

Try using below formula: =IF(AND([impact]="High", [Urgency]="High"), "Crisis - SEV1", "Low Severity") Note: Sometimes comma(,) does not work in formula (I am not sure but it is based on something language or regional settings on your site). So in that case use semicolon(;) instead of comma(,). Return your calculated field as Single line of text. You can ...


2

Try using below formula, it will work for you: =IF(ISBLANK([completed date]),"Open","Closed") Note: Sometimes comma(,) does not work in formula (I am not sure but it is based on something language or regional settings on your site). So in that case use semicolon(;) instead of comma(,). Return your calculated field as Single line of text. Example: Column ...


3

try the below formula, add the below formula in the status - calculated column =IF( ISBLANK([completed]) , "Open" , "Closed" )


0

Short answer to your question is No. AVERAGEIFS is not available in SharePoint calculated column formulas. However, AVERAGE and AVERAGEA functions are available. AVERAGE function: Returns the average (arithmetic mean) of the arguments. AVERAGEA function: Calculates the average (arithmetic mean) of the values in the list of arguments. Unlike the ...


0

There is a formula called AVERAGEA function, you can use it. Have a try and let's know the result.


0

The first problem, SharePoint does not have the concept of column "ranges" like Excel does. So SharePoint's version of the MAX function is called with comma-separated parameters for each column you want to compare. Such as MAX([Column1], [Column2], [Column3], [etc...]). The second problem is the comparison of dates. Technically, SharePoint's MAX function ...


0

I don't think Today works in calculated formulas: How to use Today and Me in Calculated column


1

Well, you are formatting the result to show only the time value, so what do you expect? In Excel, you can use the [] brackets to show values greater than 24 hours in the hour part. Not sure it works in SharePoint, but you can try. "[hh]:mm:ss"


0

According to my understanding your requirements are (correct me if I am wrong): IF [Ärende tilldelat] is blank then calculated column = "Ej tilldelad" Else IF [Ärendetyp]="Tillkoppling" then calculated column = "test" Else calculated column = difference between [Ärende tilldelat] and [Ärende inkommet] in format of "hh:mm:ss". Try using below formula: =IF(...


Top 50 recent answers are included