Questions tagged [calculated-column]

Calculated columns are the SharePoint equivalent of Excel formulas. They allow you to display values that are calculated from the values of one or more other columns. These calculations can be made using standard mathematical operators and SharePoint's built-in functions.

Filter by
Sorted by
Tagged with
0
votes
1answer
19 views

Remove characters from Text within a list - SharePoint 2016 onprem

I am trying to remove certain characters or only display certain characters within a list. The source field is called [Issue Status] and created a calculated column with the following: =LEFT([Issue ...
3
votes
1answer
33 views

Help combining SharePoint formula statements - DATEIF and ISERROR

I am running a SharePoint formula that calculates the length of time (in yrs, months, and days) before a project expires. In the "Will Expire" column the following formula is running: =...
2
votes
1answer
32 views

Calculated Column Greater than or equal to with nested if

Can you please help with this formula. =IF([Result2]<=3,"Low",IF(AND([Result2]>=4, [Result2]<=6),"Low Med",IF(AND([Result2]>=7,[Result2]<=12),"Medium",IF(...
1
vote
2answers
27 views

How to Create Calculate column using other Lists

I have a DB on my SharePoint site using several Lists. For one of the lists I need to count Total, Pending and Completed records from the other tables. There's one list for each department and on it ...
1
vote
4answers
38 views

SharePoint Column - Conditional Formatting

I basically have a calculated column that shows the date 1/29/1900 if there are some empty values in the other columns. Is there a way to use JSON formatting to format it so that if the column ...
0
votes
0answers
29 views

How to get a Power Automate flow to stop updating after 1 item in a SharePoint list

New to SharePoint and Microsoft flow/Power Automate. I have made a flow that copies the sum of a calculated column (Summa) into a currency column that can display a sum (Total). The reason of course ...
0
votes
1answer
36 views

Count occurrences of a particular value in sharepoint folder

Trying to either use FLOW or calculated column in sharepoint to try and achieve the following. Appreciate anyones help on this. God Bless Janan
0
votes
1answer
66 views

Sharepoint list: How can I calculate difference between two dates without Fridays and Saturdays

I need a formula that can calculate difference between 2 dates without calculating Fridays and Saturdays. I need to use this formula to create a calculated column in list. Thank you
0
votes
2answers
20 views

I need it to show Yes automatically when the status is completed

I need it to show YES automatically when the status is completed and remaining as NO if is still in progress. Please share a code to make this happen. See the images attached. I have also tried ...
0
votes
1answer
26 views

Unable to Reference 'Name' Column for SP Calculate Column

I created an SP document library and moved 2700 .jpg files into it. I am trying to create a Calculated column that looks at the 'Name' column in the library and extracts characters 1 - 4 the first new ...
0
votes
2answers
34 views

Create calculated column that increases daily and resets on value of another column

Let's say I have two columns in a SharePoint list: [Invoice Age] - text (20, 23, 25) [Payment Status] - text (Not Paid, Paid) I'd like to create a calculated column [Invoice Age] that will increase by ...
0
votes
1answer
26 views

SharePoint calculated column, converting time into decimal then dealing with greater than 24 hours using IF

I have a SharePoint list that has the following columns: Start Time End Time Employee Count Total Hours Total Hours (Decimal) The "Start Time" and "End Time" are DATE format, "...
0
votes
1answer
49 views

Calculated Column and File Name 'Title' Field

I uploaded more the 2000 images files to an SP document library. When I checked the 'See Details' under the file name property options, I noticed the actual name of the file appears in the "Name&...
1
vote
1answer
29 views

Sharepoint: Creating another view with unique values and sum

I have such a list as per screenshot. I need to create another view, where first column "Risk Category" will show only unique values (so only 3 items in this case: "Legal risk, "...
0
votes
3answers
47 views

Document Library Calculated Column

I have a document library in which are a couple thousand image files formatted as such: CQYr UnqID Title FNme LNme Agency 2020 RR0000 Bus Driver Roger Rabbit Federal I am trying to create ...
0
votes
1answer
13 views

Date Calculation for Leave Entitlement

I am trying to calculate leave entitlement based on the date of joining and current date, at antry date the person has 20 days of leave if the person has completed their 2nd year anniversary by 01 ...
0
votes
1answer
39 views

Adding / Creating Calculated Column

I have a document library with a 'Name' column that has files formatted as follows: CQYR UnqID Title FirstName LastName 2020 RD0000 Teacher Rodger Dodger Is it possible to ...
0
votes
2answers
26 views

Calculated Colum - Ordering nested IF statements

I don't know if what I am trying to do is possible, but this is the theory. I have a 3 columns in SharePoint Project State - TEXT Days Overrun - NUMBER Actual Finish Date - DATE The "Project ...
0
votes
1answer
22 views

How to use Calculated column to check if time is between 2 times

If I have an end time of "12.30 PM", how do I use calculated column to check if this is between lunch time from 12pm-1pm. I want to display "Yes" if it falls between and "No&...
0
votes
1answer
23 views

I am trying to create a IF/AND/OR statement in SharePoint, but it's not capturing what I need it to

The formula I have now is: =IF(AND([Add or Remove]="Add",[RealPage Complete]="No",OR([Add or Remove]="Terminate",[RealPage Complete]="No",[CMP Contact Unmapped]=...
0
votes
2answers
38 views

calculated field in SPO

I am using SharePoint online. My final goal is to show a calculated value. So what I am trying is: SUM all values in one column if the ID of the item is the same. It is a list of documentations and ...
1
vote
1answer
13 views

Help with nested If statements that format a phone number based on country

I am trying to create a calculated column with nested if statements. Due to my users not wanting to format the phone number correctly I am creating this new column to take the phone number in the ...
1
vote
3answers
38 views

Calculated text column in SharePoint Online results in a ‘0’

I would like either entry in the Status column to return a blank text value. Right now "Assigned" is resulting in a "0". =IF(Status="Discontinued","",(IF(Status=...
0
votes
1answer
52 views

I am working on a microsoft flow which updates a column on the basis of another column

Here is the screenshot of the source and destination: 1. I am working on a flow which updates a column SME Comment CK on the basis of another column SME Comment. These columns are multiline text. but ...
1
vote
1answer
18 views

Number formatting

I have a two choice columns that display same three choices: 0, 3, 9 Column 1 has a value of 9 Column 2 has a value of 3 I want to add 9 and 3 on a new column. Something so simple is giving me issues? ...
1
vote
1answer
31 views

Sharepoint list columns

Is it possible to create a SharePoint column based on choice (definition) that when selected populates the rating on another column? I will need to add sum of all scores: Thanks a million!
0
votes
1answer
19 views

SharePoint List Autoincrement number field?

I need a autoincrement number using number field ( I set default value is 5000 once add the items it will increase one by one) in SharePoint. Can anyone help me using formula.
0
votes
1answer
25 views

Calcluated Column multiple IF with SEARCH statement coming up as #Name?

I want to search each cell in a column for a certain pharse. I figure I should use IF statements but since the following text can be anything I need to incorporate a SEARCH statement as well. Like at ...
0
votes
1answer
22 views

Calculated Column - Dynamic project end date

I am building a project list that has the following columns: The "Projected End Date" column is calculated by taking the "Start Date" and adding the number of of "Quoted Days&...
0
votes
1answer
24 views

Calculate the difference between two dates in hours and minutes

In SP online in a list, I have a formula that calculates the difference between two dates and outputs the result in Days+Hours+Min. I was wondering if it's possible to obtain the results only in Hours ...
0
votes
1answer
37 views

Calculating business days between dates and allowing a negative number

I have some working code that calculates business days between two dates: =(DATEDIF([Date Submitted],[Start Date],"D"))-INT(DATEDIF([Date Submitted],[Start Date],"D")/7)*2-IF(...
0
votes
1answer
19 views

SharePoint Calculated Yes/No Column

I've tried to create a calculated column in a SharePoint list that looks for a word in the title of the list entry and then returns yes or no based on if that word is included in the title or not. =IF(...
0
votes
2answers
27 views

Calculated Filed

I have created a calculated filed to convert a date field to another format, the issue I have is the calculated filed populate data for empty fields as well. Is there anyway it can only populate data ...
0
votes
1answer
202 views

How to format calculated column number in Flow

I am using a calculated column (number) in a SharePoint list, and putting the value into an email using a Power Automate Flow. The value will always be an integer. When the value is passed through to ...
0
votes
1answer
18 views

Calculation in Calculated Column not Working

I am unable to determine why SP keeps kicking back on error on the following. This is a calculated column that is reading the contents of a CertQualTitle column and applying/returning the appropriate '...
0
votes
2answers
25 views

Calculated Column Question Blank Dates

I have been stumped on this particular task for weeks. Any help would be greatly appreciated. I have three columns I am working with: Date Admitted to Hospital (date column), Date Discharged (date ...
1
vote
1answer
46 views

Mulitple IF Statements based on other criteria

I have this and it works on its own: =IF(ISBLANK([Basic Finish]),"Past Due",IF([FCM 4 Expected Date]>[Basic Finish],"On Time",TEXT([FCM 4 Expected Date]-[Basic Finish],"h:m:...
1
vote
3answers
27 views

Blank a column if a condition is met

I have a established a custom list with 5 columns for testing. Title column Date columns (Date1 & Date2) Calculated column to count days between the 2 dates (Total) Calculated column to count how ...
0
votes
1answer
16 views

Calculated field in Sharepoint Lists when some of the text fields are empty

I am trying to create a calculated field that produces a person's full name in the following format: "1stLastname 2ndLastName, FName MName". I am using the following formula, but keep ...
0
votes
1answer
22 views

Calculated Column to Get Totals & Percentages

So I have columns set up like so: Entity Region Quarters Year Month #ofOps #ofMisops %ofMisops Company A East Q1 2020 Jan 1 1 100% Company A ...
1
vote
1answer
23 views

Nesting IF Statements in SharePoint Calculated Column

Uhh!. I have 3 statements that individually return my values. Now, I need to put these together into one formula. Here are my statements that need combined into one calculated column. Thank you. 1st ...
0
votes
1answer
34 views

How to get a particular value in the calculated column

I am trying to implement the following code in a calculated column named [Valid] in a document library in modern SharePoint online. =IF([Valid Until]-TODAY()>=0,"Valid","Expired"...
0
votes
1answer
58 views

Button on SPO Page that copies the URL of an item in a list view web part with a checkmark next to it

Basically, if ONE document in a document library LVWP is checked, a button should become active. When clicked, the button will copy that document's absolute encoded URL to the clipboard. It doesn't ...
0
votes
1answer
20 views

Priority Due Date column sharepoint online

I need to setup a Due Date calculated column on an SPO list and whilst I've managed to work out the formula for days, I cant quite work out hours?! I have SLA priorities on my list as per the below: 5=...
0
votes
1answer
41 views

Calculated Column with TODAY() issue

Using the following: "If Authorization Date is null, calculate the difference between Receive Date and today; If Authorization Date is not null, calculate the difference between Receive Date and ...
0
votes
1answer
40 views

My Sharepoint formula not working

=IF([Sett. Start]<=Today,"Visit Due",IF(ISBLANK([Visit Notification No.]),"Visit Not Due","Visit Done")) I am using above formula in SharePoint List but it is working ...
0
votes
3answers
54 views

=IF(ISBLANK([Last Update]),“”,TEXT(NOW(),“dd/mm/yyyy”)-[Last Update]) is retruning negative numbers

I have the following formula inside a calculated column:- =IF(ISBLANK([Last Update]),"",TEXT(NOW(),"dd/mm/yyyy")-[Last Update]) but today is 27/08/2020, and on some cases where ...
0
votes
1answer
52 views

Calculated Columns - Comparing multiple columns with IF statement

I am fighting with SharePoint calculated columns and trying to compare multiple columns. The SharePoint list has the following columns: Completed Date - Date Completed - Yes/No Due Date - Date ...
0
votes
1answer
23 views

Initiate a Work Flow Every 24 hrs

I have the need to initiate THE MOST SIMPLE ACTION possible every 24hrs in an SP List. The action doesn't even have to do or mean anything, just kick-off in a way that it impacts the entire SP list; ...
0
votes
1answer
37 views

Minus 5 hours 30 minutes from a date

I have a column of type as date and time. I want to minus 5 hours 30 minutes to produce a new time in a new column - Please advise?

1
2 3 4 5
21