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
1
vote
2answers
37 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
79 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
49 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
64 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
69 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
572 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
367 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
100 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
15 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
30 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
29 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
126 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
39 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 ? ...
2
votes
1answer
268 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
41 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
132 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
58 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
48 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
61 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
98 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
20 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
30 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
273 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
48 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
22 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
234 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
73 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
389 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
333 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
218 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
165 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
71 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
27 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 ...
0
votes
1answer
277 views

Average and Total in a Calculated Column

I am currently calculating the difference between created date and modified date in my SharePoint custom list. Is it possible to also calculate the average of the # of days, totalled by month? I ...
1
vote
2answers
234 views

Calculated Column Working Not Working

I have a calculated column that worked in SharePoint 2007, 2010, 2013, and 2016. But now in SharePoint 2019 the calculated column is not appearing right in the column instead of showing the employees ...
0
votes
3answers
597 views

Column to display day of week

I am using the following formula to calculate the day of week based off of the Start Date column: =TEXT(WEEKDAY([Start Date]),"dddd") The problem is that when I create the event on the calendar view ...
1
vote
1answer
49 views

Filter pane bug in modern experience when using a calcuated column

I've run into an odd bug when using the filter pane to filter a calculated column in SharePoint 2019 on premise. When using the see all option, the "8_" text is added to the filter value and the ...
0
votes
1answer
82 views

Number Reset as Beginning of the Month

I have an ticket tracking system in a SharePoint list that runs by a Fiscal year, month, then counts for the month. And my leadership wants to automate the number assignment. Ex: ABC (current ...
0
votes
1answer
914 views

SharePoint Online: Calculated field with week number starting Saturday

I've found a few ways online to calculate the week number but none that allow me to start the week on Saturday. Here is the formula that I tested, but doesn't give me Saturday-Friday. =INT(([Time In]-...
1
vote
1answer
68 views

SPO Calculate Total Cost Per Group View

I will try to summarize my main goal if it's possible to achieve it. I have a list which contains the following columns: Invoice ID Number, Item Name, Quantity, Item Cost,Total Cost. What i want to ...
1
vote
1answer
51 views

Columns doesnt count right

So I got this example: The green value should show 01:00:00 but it doesnt. I think the formula I got "ROUND" it somehow (I got the code online). And I need this code so the value can exceed 24 hours. ...
0
votes
1answer
33 views

Calculated Column with Multiple Queries

This may seem really basic but I'm struggling to get my head around it. I have 2 boolean columns (Checked by TL and Checked by CSS), I need a calculated column to give me one of three results; 1: ...
0
votes
1answer
15 views

adding years to existing date to produce expiry date ( SP list)

I have a list of training course that all have different levels of validy. So course A lasts for 3 years Course B lasts for 2 years Course C lasts for 1 year At the moment I have a column with ...
3
votes
2answers
166 views

If exceed 24 hours show "23:59:59"

So I got this calculated column called "Due time" with this format in it: =IF([Hours]<24&&[Minutes]<60;CONCATENATE([Hours]&":";[Minutes]);"23:59:59") I only get syntax error with ...
0
votes
1answer
22 views

Averages of Column values placed into either its own column, or workflow variable

I've researched this one - and while I have found many helpful articles CLOSE to it, nothing hits exactly what I'm needing. I'm trying to populate either a variable in a workflow OR a column with the ...
0
votes
1answer
24 views

COUNT of items in list, with more requirements

Here's my current predicament: I'm trying to assign a COUNT value in one list to a column in another list (on the same site, of course). But, here's the twist - I want a COUNT of columns of a certain ...
0
votes
1answer
20 views

Calculation Overload from Excel to Sharepoint

How can I convert this Excel Formula to SharePoint? =IF(AND(F6="REG",G6>=4,G6<8),0.5,IF(AND(F6="REG",$G6>=8,G6<=16),1,IF(AND(F6="HDY",G6>=4,G6<8),1,IF(AND(F6="HDY",G6>=8,G6<16)...
1
vote
2answers
29 views

View only latest added items if item already exists (same name)

Need some help figuring out how to go about this! I have a list, people will add items to it, sometimes with the same title (which is correct). We then group these items by the column 'title' on the ...
0
votes
1answer
122 views

Compare times in calculated column

I want to compare the time from a column called "Date and time" (datetime format) with a fixed time value. I have created a calculated column for this. =IF(AND(TIME([Date and time])>TIMEVALUE("06:...
0
votes
2answers
230 views

Have a column pull criteria from two columns and display specific value

My goal is to have a calculated/or lookup column to display the company number if two columns contain certain information. I do not have access to PowerApps, Microsoft Forms, SharePoint Designer, ...

1 2 3
4
5
22