New answers tagged

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

I know this is an old topic, but there may be people out there still using SharePoint 2013 Foundation with SP workflow 2010 like me, hope this workaround helps. It uses 2 lists and workflows to create a loop until it finds the date that does not fall on weekend or holiday. The advantage is that user can easily maintain their holidays without using hard coded ...


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

Try using below formula: =IF(ISBLANK([3rd Date Column]), DATEDIF([1st Date Column], [2nd Date column],"d"), DATEDIF([1st Date Column], [3rd Date column],"d")) Reference: Date and time formulas. 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 ...


1

In addition to Martiur's response, to calculate the number of days you can use the DateDif function: =DATEDIF(Start_date,End_date,"D") -> "D" for number of days. E.g.: Create a calculated column of type number Formula =DATEDIF(Today(),[PastDate],"D") Microsoft Article


1

Based on many references on this in Stack Exchange, you can use Today() instead of [Today] like: =TODAY()-DateOne


1

Try this: =IF(ISBLANK(DateThree),(DateTwo-DateOne),(DateThree-DateOne))


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


1

No, the IF function is supported in SharePoint formulas, but the IFS is not. But you can create a deeply nested IF condition where another IF function is used the third parameter (the "else" condition), so using the formula you presented you can achieve the same with: =IF([SubmissionDate]="","Pending Submission",IF([DeadlineDate]>[SubmissionDate],"...


Top 50 recent answers are included