New answers tagged

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 ...
user avatar
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 ...
user avatar
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 ...
user avatar
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 ...
user avatar
  • 29.2k
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 ...
user avatar
  • 29.2k
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-...
user avatar
  • 602
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")),...
user avatar
  • 101
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 ...
user avatar
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 ...
user avatar
  • 8,787
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 ...
user avatar

Top 50 recent answers are included