# Tag Info

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

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

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

### 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")),...

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