New answers tagged calculated-column
0
votes
Accepted
Calculate years of seniority on termination date OR if blank Today's date
You can try below formula. In this formula I have considered decimal point as month so in case of 2 years and 11 months it will display 2.11
=CONCATENATE(IF(ISBLANK([Termination Date]),DATEDIF([Hire ...
0
votes
SharePoint List - How to determine percentage complete based on completed columns?
One of the approach to use SharePoint Calculated column to count percentage based on the column values and then you can use SharePoint Column.
By default SharePoint Calculated column will not allow ...
0
votes
Calculated column issue in Sharepoint List - Excel Formula Given
On the Settings page, under Columns, select Create Column. In the Name and Type section, enter the name that you want in the Column name box. Under The type of information in this column, click ...
1
vote
calculate the sum of months from a fiscal year horizontally from one list to a summary list
You cannot create a calculated column in SharePoint list based on data in another SharePoint list.
So, your requirements cannot be achieved using SharePoint OOTB functionalities. You need to develop ...
0
votes
Accepted
Average Ignoring Blank Columns
If all 3 columns are of type "Number", use below formula:
=IF(COUNT([Column1],[Column2],[Column3])=0,0,SUM([Column1],[Column2],[Column3])/COUNT([Column1],[Column2],[Column3]))
I just tried ...
1
vote
Accepted
Calculated column not working properly
Change it to AND instead of OR
I'd recommend reviewing this knowledgebase article. The examples at the bottom provide a clear indication of what your result will be:
https://support.microsoft.com/en-...
0
votes
Calculated Column Syntax nested DATEIF and ISERROR
I know this is a really old question, but it was a top result on Google, so I'd like to answer. It works if you test for the error first.
=IF(ISERROR(DATEDIF(TODAY(),[Training Expires],"m")),...
0
votes
SharePoint Calculated Column Not Posting Date Value
You could set completed date column default value in the PowerApps as following picture shows.
===================================
If the answer is helpful, please click "√" on the left ...
1
vote
SharePoint Calculated Column Not Posting Date Value
You cannot use a calculated column for this purpose. You need to create the logic in the SharePoint form, so when the user ticks the box, the current date (and not the Today function) is written into ...
0
votes
How to write multiple conditional formula (39 conditions) for 7 columns in Sharepoint
If you need more than 19 conditions then return an empty string on the last if statement of your first 19 condition group and then concatenate (Using the & operator) and add another 19 IF ...
Top 50 recent answers are included
Related Tags
calculated-column × 1163calculated-column-formula × 405
sharepoint-online × 283
list × 200
2013 × 108
date-time × 96
sharepoint-server × 87
sharepoint-enterprise × 83
2010 × 80
custom-list × 56
sharepoint-designer × 55
column × 45
lookup-column × 39
workflow × 38
javascript × 36
sharepoint-foundation × 36
modern-experience × 36
date × 31
list-view × 27
document-library × 19
2007 × 19
infopath × 17
error × 17
calendar × 17
designer-workflow × 16