New answers tagged

0

To average over a date column, modify view->in Totals section, choose Average for the date column:


0

Have you checked the Regional Settings of your SharePoint Site? https://sharepointmaven.com/sharepoint-time-zone/ Let’s first start with Regional (Administrative setting). It is important to note that the Regional Setting is set for each site separately. If you set the time zone at the top site of the site collection, it would not propagate ...


1

Created By is a "People Picker" field, and those are not supported by SharePoint Calculated Columns. You can create a SharePoint Designer workflow to copy a selected "people" property into a Single Line of Text column that can be used by a Calculated Column. This is showing a dialog from the workflow designer. It is using a "Boss" column instead of Created ...


3

I could reproduce your issue on my end if the column "Score" is a single line of text column. Solution 1: change the type of column "Score" to number instead of single line of text. Solution 2: add quotes to the number 70 in your formula, like this: =IF([Score]>"70","A","F")


1

Use below formula: ="<DIV style='font-weight:bold; font-size:24px; color:"&IF([Review Status]="Approaching","Green",IF([Review Status]="OverDue","Red","Yellow"))&";'>•</DIV>" Note: Return this field as Number field. Microsoft blocked handling HTML markup in SharePoint calculated fields for recent versions, see here. If you are using ...


0

Ganesh's Formula is correct and you can change the "Both Date Fields" to your required text.


0

Below formula shows will show blank field in calculated column if both date fields are blank otherwise it will show "Both Date Fields are not blank". =IF(AND(ISBLANK([Actual Release Date]),ISBLANK([Forecast Release Date])),"","Both Date Fields are not blank") References: IF function. AND function. Update: Below formula meets all your requirements, ...


0

Do a search on "excel if and formula" . Here is an example from exceljet.com =IF(AND(A1="this",B1="that"),"x","")


0

Found a JavaScript solution, posting it here as well. Just replace the Column Name with the name of your column: <script type="text/javascript"> SP.SOD.executeFunc("clienttemplates.js", "SPClientTemplates", function() { var fieldContext = {}; fieldContext.Templates = {}; fieldContext.Templates.Fields = { "Column Name": { "View"...


Top 50 recent answers are included