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
15 views

Sharepoint list with calculated column - formula IF does not work

Working on a SharePoint list with a calculated column with a date, which I want to make dependent on priority (column is called Prioriteit), and date of creation (Datum melding). I made this formula ...
0
votes
2answers
14 views

extract “all” numerics from text string

I have a Sharepoint Online list with a text field for a contact called Mobile Phone... I want to extract the numerics only... (111) 222-3333 would be 1112223333 +99 111-222-3333 would be 991112223333 ...
0
votes
1answer
25 views

SharePoint Calculated Column by searching another column for various strings

I am working with a SharePoint 2016 list that contains one column with names and other values. I want to use a calculated column to search that "name" column and return another value if that "name" ...
0
votes
1answer
20 views

How to calculate the difference between two data in the same list column

I want to know how to calculate the difference between two data in the same column of a list. It is useful if we are monitoring the changes (daily-monthly-etc). TX for your suggestions on how to make ...
0
votes
2answers
28 views

How to have validation for calculated column

I am working on a calculated column that take value from other two different columns. The formula is as this: =IF([Detect-Rental/Lease]=1,IF([Detect-Rental/Lease Taxonomy]="Yes",TRUE,FALSE),TRUE) ...
1
vote
1answer
14 views

SharePoint List - Time Calculation

We have a change control SP list and do aging metrics on how long an item is open. I have a calculated field to calculate how long an item has been open, but am getting a negative serial date as a ...
0
votes
0answers
28 views

Need more if statments in calculated column

I have a problem with calculated formula, this take the information from a choice column. The problem is that i have 23 choices, and the calculated column only permit 20. When i add the 21 if, it ...
1
vote
2answers
31 views

Calculated column from a multiple lines column

I made this formula for a calculated column that works from with single line columns, but am unable to make it work with a multiple line column. =IF(ISERROR(FIND("flight",[shipping])),"ground","...
0
votes
0answers
8 views

Adding Column that links to specific document automatically

I wanted to create a column in Sharepoint that will be able to calculate a link based off another column. So for instance I have a Sharepoint list with all these documents in which we specify "related ...
0
votes
0answers
12 views

Sharepoint 2013 Auto Increment Column

I've read a bunch of articles on how to do this, but I haven't succeeded in making this work. So I have SP Designer 2013, but due to my Gov. restrictions, I can only utilize 2010 workflows. I'd like ...
1
vote
2answers
33 views

Increase number of decimal places in SharePoint calculated column while list exceeds the list view threshold

I am facing an issue while I need to increase number of decimal places of list calculative column. I need it in SharePoint online - unfortunately the list contains more than 40K records (and ...
1
vote
1answer
29 views

What is the formula to calculate working days between two dates with Fridays & Saturdays as weekend!

What is the formula to calculate working days between two dates on lists SharePoint? Keeping in mind that the working week here in Dubai is Sunday to Thursday - Fridays and Saturdays are the weekend. ...
0
votes
0answers
9 views

Auto-calculate Average in Range

I have a user that wants to convert her Excel file to a SharePoint list and use the same formulas. I have one column that is an Average of the cells in a range over the column next to it. Example: ...
1
vote
1answer
41 views

How to set date for 2 weeks out for an automated reminder

I have a SharePoint list that is populated with ticket data. There are two primary columns "Open Date" and "Calculated Date" I'm trying to figure out how to set the calculated date 2 weeks out from ...
1
vote
1answer
9 views

Marking item as “Delivery not met” sharepoint list

New to SharePoint lists.. trying to find a way to mark items that did not meet the deadline. I have the column "Expected Completion Date" and "Date of Completion" (Both are in mm/dd/yyyy format). I ...
1
vote
1answer
20 views

Calculating Formula for days and text

Trying to write a formula that calculates the expected completion date based on the priority of the project day it was assigned. For two of the priorities, it needs to be a text response in the ...
1
vote
1answer
31 views

Calculated column: If this than that, with a calculation

I have a column named Soort. It has 3 stringvalues. One of them is Brandstof. There are 2 other columns: AantalKm and Km-vergoeding. They are both numbers fields. And there is a KostenBrandstof column....
1
vote
2answers
27 views

Calculated Column as Title on SharePoint Calenar

I am working in SharePoint to create a calendar that will pull the information from the "Content Category" column and the "Title" column into the title field. To do this, I am trying to create a ...
1
vote
3answers
19 views

SharePoint 2013 Description does not show for calculated fields

I have added descriptions to calculated fields in a SharePoint 2013 list, but am unable to make them display in the form like other column descriptions. How can I add these to be visible to my users?
0
votes
2answers
27 views

SharePoint online When date column has date in it or is TRUE update different column with preexisting selection

I'm having trouble figuring out what to do in this specific circumstance. I have a PowerApps form. In this form I have several fields but there are 2 that I'm trying to build a dependency on. A date ...
0
votes
2answers
24 views

Calculated Date Column with Nested IF statements

I am trying to calculate a Date based on two different columns in a SharePoint List: RANK column and PEBD column. Essentially, I need to do the following: IF RANK is E1, then the value of the ...
0
votes
1answer
40 views

Calculated column for date difference taking into account weekends and negatives (Errors #NUM! and #Name?)

I've been fighting this and going around in circles, hopefully someone will be able to help me out. Issue: I am trying to create a calculated column (Text) that compares today's date "Now()" with a ...
0
votes
3answers
49 views

How to count number of days from SharePoint list?

How to count number of days between two dates from SharePoint list using CAML query/JavaScript? Thanks
1
vote
1answer
25 views

Yes or No in calculated fields instead of 1 or 0

Say, I have a SharePoint list with 2 columns, A and B. A contains a list with three items: one, two and three. B is calculated yes/no field, where I use the formula =If(A="two";TRUE;FALSE). This ...
1
vote
1answer
26 views

Add Sharepoint calculated field using AddfieldasXML - key cannot be null

I am trying to add a calculated field using the AddFieldAsXML method. And below is how I constructed the field xml. > fieldXML ="<Field ID=\"{ABB544B1-5433-4B49-A629-7B242D3548E5}\" > ...
0
votes
0answers
14 views

Calculated Formula to auto populate next PO# available when only one specific choice is selected from another column

I would like a calculated formula for the following: I have a column with a dropdown that will list Vendors to choose from. Only one of the Vendors needs a PO#. I'd like a column to auto calculate the ...
1
vote
3answers
25 views

If a column is NO, change another column to Closed

I have a SharePoint list with a status column which has the following in which works great. I'm looking to add to the formula dependent on another column - is this possible? If consent required ...
1
vote
0answers
27 views

Need help counting number of error types for employees

I have a SharePoint list that captures employee details and the error types they have committed. In the same list, I would like a column to auto-capture the number of instances of each error type when ...
2
votes
2answers
64 views

SPO: Create Hyperlink from Calculated Column

I know there are several questions/answers for this, but I still can't seem to get it to work. Name - Text URL - Text Link - Calculated Column Number Link column =CONCATENATE("<a href='",URL,"'...
2
votes
2answers
29 views

DATEDIF Calculation losing a minute

I have a timesheet for users to enter Start Time, End Time and Breaks. I've created this calculation to total the number of minutes worked. However, sometimes it loses a minute. How do I fix this ? ...
0
votes
1answer
24 views

Populate Column with IMAGE based on another column's content

Here's a variation I'm having an issue with: I'm trying to populate a column based on the content of another column (choice field). While I'm currently doing this with a workflow, I know it can be ...
2
votes
1answer
29 views

Display text in a column based on what is in two columns

I have two columns [Impact] and [Urgency] that are choices - I would like to display text in another column based on the choices in those columns. if[impact]=High and [Urgency]=High then display "...
4
votes
2answers
53 views

Calculated column to show status if another has a value

I have a SharePoint list with a completed date column. I wish to have a calculated column called status so when the completed date column has a date in it, it shows "Closed" and when it is blank it ...
0
votes
2answers
11 views

is AVERAGEIFS possible in Sharepoint calculated column list?

Sorry I'm new to SharePoint. I am building a tool to track projects and would just like to ask if it is possible to have a column to automatically average all projects with the same 'priority name' ...
1
vote
2answers
37 views

date calculation

do not know if this can be done with SharePoint calculation. what i am trying to do is calculate between two or three dates. i know the formula for calculating between two dates but it is the latter ...
0
votes
2answers
39 views

Workflow calculation - number of days based on TODAY

I initially tried to create this as a Calculated Column. But, of course, they don't like [Today] as a variable. I'm trying to populate a column with a number that is a calculation based upon a date ...
1
vote
1answer
43 views

Date Difference in minutes SP Calculated Column

I have a SharePoint Calculated column that is supposed to calculate the difference in hours and minutes between two dates. This is the expression I am using for that: =TEXT([IN/OUT Time]-[Staging ...
0
votes
0answers
19 views

Calculated column won't be created!

I am trying to create a calculated column. I tried below formulas: =([ContractFinalKm]-[Present/RealFinalKm])/ABS([Present/RealFinalKm]) AND =([Present/RealFinalKm]*100)/[ContractFinalKm] Neither ...
0
votes
1answer
28 views

Need help with displaying text depending on choice

I am trying to get this formula to work. I want: IF column ärende tilldelat is blank I want the calculated column to say "Ej tilldelad". If you have chosen "Tillkoppling" in the column Ärendetyp I ...
0
votes
1answer
22 views

Does Sharepoint allow IFS formula

I tested this on excel but can not translated to Sharepoint. I am trying to test for example if Column C has date that is greater than the one in column D = Submitted on time, if column C's date is ...
0
votes
1answer
31 views

Calculate number of days from date to today [duplicate]

I have tried and looked for the answer to calculate the number of days from a date to today's date and getting an error. Calculated columns cannot contain volatile functions like Today and Me. ...
0
votes
1answer
21 views

When adding an item, will deleting the coloumn where we add new data, will it delete the previous data already entered in the records

I have a share point website with a list and important records. However my manager told me to amend the columns, as it's type has also to be changed to choice from Azure AD rather than the single line ...
0
votes
2answers
36 views

Display a date field in a specific format as single line of text using calculated column

I Need the Right Formula for the following Problem: I got a column that contains only date but sometimes it contains no Information. =DAY([AB])&"."&MONTH([AB])&"."&YEAR([AB]) This ...
0
votes
2answers
35 views

Sharepoint calculated field rendering

Currently in my SharePoint list, the fields are displayed in Tabs format But When I am adding the calculated column, it is not getting displayed on New/Edit forms. but it is visible on the display ...
0
votes
1answer
67 views

Create Sharepoint View Filtered by Current Quarter in sharepoint lists/Library

I'd like to create dates for the projects we are working on in our company, and it has to be filtered by quarters and calculated columns. Can any one help me with that? Please and thank you!
0
votes
2answers
62 views

Problems on RIGHT function on Sharepoint

I have a calculated field which is filled in automatically thanks to a simple formula: =(X*X*Z/162-Y*Y*Z/162)*X This generate a number like: 1.637.037 I have a problem on adding RIGHT function to ...
0
votes
1answer
55 views

Replace “,” to “;” in single line of text column

I need an advice on the following situation. I have column that is single line of text which stores email addresses separated by comma (the value is created by lookup table). Example: ABC@yahoo....
0
votes
1answer
36 views

SharePoint 2010 List Custom ID Column Creation

My team is trying to create a custom ID column for our SharePoint 2010 list. The column should show YYMMDD-ID, with YYMMDD the date the item was created and ID the ID of the item. I tried using =[...
0
votes
1answer
16 views

Simple ISERROR Calculated Field Assistance

I have a simple calculated field =[Total Reviews Failed]/[Total Reviews Completed]. The problem is that if these numerical columns are blank, The field returns #DIV/0!. Can I replace the #DIV/0! with ...
0
votes
2answers
25 views

Response date fucntion

I want to obtain the response date (number of days) based on other parameters. Used to use an excel file for document management, trying to upgrade to sharepoint and use meta-data. The formula i'm ...

1
2 3 4 5
20