New answers tagged calculated-column
1
The following works for three fields:
=(q1+q2+q3)/(IF(q1=0,0,1)+IF(q2=0,0,1)+IF(q3=0,0,1))
So, add the values for the three fields, and then divide by the number of fields with a non-zero value.
You may need to add another if statement around the rest to avoid a divide by zero error.
0
To average over a date column, modify view->in Totals section, choose Average for the date column:
1
You cannot do this with a Calculated Column. They can only access data from the same item. You create a SPD 2013 workflow and web service calls to read the other rows.
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
Try using below formula, it should work:
=[Department Name]&" - "&[Title]&" - "&[Department Team]&" - "&[Department Branch]
Also, you can use CONCATENATE function instead of &, like below:
CONCATENATE([Department Name]," - ",[Title]," - ",[Department Team]," - ",[Department Branch])
Reference:
CONCATENATE function
1
Columns with spaces or symbols need to be enclosed in square brackets:
=[Department Name] & " - " & [Title] & " - " & [Department Team] & " - " & [Department Branch]
I added extra spaces for clarity. While "Title" does not require the brackets as there are no spaces, they do no harm and make it clear this is a column reference.
1
Have your issue solved?
Same issue post:
https://social.msdn.microsoft.com/Forums/office/en-US/d77e44f2-7af4-4329-8b21-366abce9497a/list-view-grouped-by-type-quotnumberquot-then-by-type-quottextquot-does-not-expand-to-show?forum=sharepointcustomization
Top 50 recent answers are included
