Stack Exchange Network

Stack Exchange network consists of 174 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

Visit Stack Exchange
Make your voice heard. Take the 2019 Developer Survey now

Questions tagged [calculated-column]

Calculated columns are the SharePoint equivalent of Excel formulae. They allow you 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.

2
votes
1answer
14 views

Workdays/weekends/public holidays: is a sharepoint list the way to go for me?

Our team runs many short, streamlined projects. We currently have: A master excel sheet containing current phase/key data of each project Personal .xls tracking tools which automatically calculate a ...
0
votes
1answer
38 views

Calculating the total of numbers input in a field

I have a question: In a list that we use as ticketing tool, I have a field where I have to input my working hours every time. Right now we just change the number in the working hours field ...
0
votes
1answer
31 views

Adding a Dynamic calculated field in SharePoint Edit Form View

I am looking to add a dynamic field in my Edit Form since calculated fields do not show on the Edit View mode. Using the Hillbilly format, I created a table... HTML <tr> &...
0
votes
1answer
18 views

Trying to determine if I can create a calculated column to do math based on specific text

I have been looking over many formulas and ways to do calculated columns in SharePoint. I had some success in Excel but just can't seem to get it to work OTOB in SharePoint. My goal is to Calculate a ...
0
votes
2answers
14 views

How do I use the TEXT function to delete the comma from my Calculated formula for the Fiscal Year?

I'm working in SharePoint 2013. I created a calculated column of data type = SLOT with the formula: =IF(Month(Created)>9,Year(Created)+1,Year(Created)) It works but it's returning the as 2,019 ...
1
vote
1answer
25 views

How do I create a calculated column to determine whether another column contains a link?

I am evaluating column content visually to determine whether it contains a link. I'd like to automate that with a formula in a column that tells me whether any link exists. That's the first step - ...
1
vote
0answers
25 views

Me Filter on Multiple Selection Lookup Column

I have found plenty of information about filtering lookup columns (title: Employee)during searches but I haven't located something that said using [Me] filter. I created a lookup column that has ...
1
vote
1answer
24 views

Calculated Date formula not updating?

We have a Custom List in SP Online which pertains to parts needing to be inspected. Our list has the following fields: LAST-INSP: a manually entered date showing when the part was last inspected. ...
1
vote
2answers
39 views

IF Statement for SharePoint calculated columns comparing months

I'm Trying to display dates in a calculated column in the format of "DD - DD Month Year" (05-10 August 2018) or as "DD Month - DD Month Year" (30 August - 03 September 2018) if the Months are ...
0
votes
1answer
20 views

Calculated field gives “formula refers to a column that does not exist” error for auto increment

I'm working on SharePoint Online (new excperiance) and I've created a document library at the Site Content Types. For that type I'll have a column with auto increments and starting with TN. For this I ...
2
votes
1answer
29 views

Compare two fields in SharePoing using Calculated Column

I have two columns [Lease] and [MOT] whereby I like to have a column displaying message "NOK" or "OK" to make the user act upon it. I now created two calculated columns [LeaseReminder] and [...
1
vote
1answer
40 views

Need Assistance Updating an IF/THEN Statement

I have this calculated column formula for stoplights on my SharePoint list and I need just a little help updating/tweaking this particular formula. IF/THEN statements are not my forte. =IF(OR([...
1
vote
1answer
30 views

How to get a count of values in field using calculated columns

I have a calculated column and would like to get a count of all the occurrences of "true". So the first row shudl return 3 and the next 2 etc.. Can this be achieved using calculated columns Thanks in ...
5
votes
1answer
32 views

Easy way to write a correct formula!

Is there any easy way to write and validate a SharePoint calculated field formula? I am trying to find a formula builder like CAML builder!
1
vote
1answer
26 views

Calculated Column returning Undesired Result in one of over 300 list items

I have a calculated column in a Sharepoint List that is simply adding up 5 other columns with the following formula: =RWDPeriod1+RWDPeriod2+RWDPeriod3+RWDPeriod4+RWDPeriod5 The problem is that ...
2
votes
2answers
27 views

Calculated column displaying “#Name?”

I'm trying to display KPIs that show how long a list item spend in each status. Column name = Time In 5. =IF(OR(ISBLANK([Date entered 6. ]),ISBLANK([Date Entered 5. ])),"No KPI dates",DATEDIF([Date ...
1
vote
2answers
23 views

Formula of Calculated Column

I want to make a formula to my calculated column : If the DD Rating is High => Add 3 months to the [DD Sign-off Date] If the DD Rating is Medium=> Add 6 months to the [DD Sign-off Date] If the DD ...
2
votes
1answer
41 views

how to get minimum dates in a sharepoint list

How can i get a minimum date of some columns with dates field.I know i can use the min function(formula) with numbers but not with dates. is this possible using calculated columns if not would i be ...
0
votes
1answer
26 views

Calculated Field to show difference of hours as value

Hello I have three fields hours1, hours2 and total hours. Total hours is calculated fields based on the sum of hours1 and hours2. I use the formula =VALUE(TEXT(total hours,"hh"). It works if sum of ...
0
votes
1answer
36 views

SharePoint online, MS-Flow and calculated date time column #name issue?

I've got a current staff list with a StartDate (datetime) column and two calculated columns: 'DaysWorkedAt', 'YearsWorkedAt' I have an MS Flow workflow attached to the new employee list on new item ...
0
votes
2answers
40 views

Calculated Column: Combine 3 Coulmns only if 4th Column Value is True

I have created a Calculated Column that combines 3 other columns. The Formula for that is =[Crs Code]&[Crs Number]&": "&[Crs Title] And this works. Now I want to do the same thing, but ...
1
vote
1answer
30 views

Calculated (calculation based on other columns)

I have 2 columns (with a yes/no choice) and want to add a third calculated column (based on column 1 and 2) that will automatically says "yes" only if both columns are set to "yes" and "no" if that is ...
0
votes
2answers
36 views

Stoplight Indicators Pulling From Multiple Columns

I have a requirement asking for some crazy If/Then statements for stoplights. Fields I have: Need Date Column = Date/Time field Open Date Column = Date/Time field Modified Date = Date/Time Field ...
0
votes
0answers
30 views

Multiple choice lookup field does not render on edit form

I have, for the last few years, used a field called "Enabled" and a calculated field which returns the value of the Title field if Enabled is true. If Enabled is false, it returns an empty string ("")....
1
vote
3answers
23 views

SharePoint List Calculated Field updates from using Edit All and Saving (even if field didn't change)

I have a Yes/No field. If yes, a Calculated field puts the current time. =IF(Resolved,TEXT(NOW(),"mm/dd/yyyy hh:mm"),"Unresolved") The issue I have is if I click a list item that is set to resolved,...
-1
votes
0answers
16 views

Adding a new calculated column then running that calculation on all previous entries

I have an events list set up with a number of fields which has been in use for a few years and therefore has amassed a lot of data. I have recently added a new column which uses a concat function to ...
0
votes
1answer
49 views

How to create formula based on column value

I have a column in my SharePoint list named "Container Content." When adding a record in SharePoint you can choose one of three items in this column, it is a choice column. The three items you are ...
0
votes
1answer
34 views

Adding 3 calculated columns together results in my value being off +1 or -1

I have a total sale price, minus expenses then the following formula is run in 3 different calculated columns to split the Sale Price-Expenses over 3 accounts. The break down for those is 70% 20% 10%. ...
1
vote
1answer
25 views

How to use the ROUNDDOWN action along with an IF statement in a calculated column

I have a calculated column that is using a conditional IF statement to do a calculation.I am using a variation of this in 3 different Calc columns. The problem i have is that my amount are rounding up ...
0
votes
1answer
33 views

Calculated Sharepoint Dates

I have 3 potential columns that are due dates in a Sharepoint online/365 List. -Bid Due Date -Customer Specified Due Date -Proposal Due Date They are written in order of importance above and only one ...
0
votes
1answer
29 views

IF statement for date calculation

I have been trying 50 different ways to get sharepoint to display a date based on other columns. I tried breaking it down into smaller parts figuring that my IF formulas were too long or sharepoint ...
1
vote
1answer
39 views

Update list one in response to entries in list two

I have 2 lists. They both have Serial number as a column. list 1 is for jobs that need doing quarterly list 2 is for the engineers to add the jobs as they do them. This list also includes jobs that ...
2
votes
1answer
118 views

Calculated Column IF/AND question

What did I do wrong? I need a calculated column to return the following: If [Status] equals "Pre-OPEN" then return [Date Opened]+3 If [Status] equals "OPEN" then return [Date Opened]+30 If [Status] ...
0
votes
1answer
30 views

Calulated Column with Multiple IF Statement

Ok, I know I am missing something. What am I doing wrong? Trying to write a calculated column with multiple IF statements. Here is what I have. =IF([Status]="OPEN",[Date Opened]+3,"")IF([Status]="...
1
vote
1answer
46 views

Caculated Column IF statement

Having a hard time finding this question already answered somewhere, so here it is. I am trying to create a calculated column that returns the following result. If "column 1" equals "OPEN", then ...
-1
votes
1answer
24 views

How to make a column that color codes based on how old items in the list are

I am trying to make a column for my sharepoint list that is color coded based on how old items in the list are(i.e. if items are less than 1 day old there will be a green circle, less than 2 days but ...
0
votes
2answers
35 views

DATEDIFF() Not Calculating Number of Years Correctly

Using 10/1/2008 as the "HireDate" field, the calculated "Number of Years" returns 9 years when it should clearly be 10 years. Using 8/1/1988 as the "HireDate" field, the calculated "Number of ...
0
votes
2answers
23 views

Need help creating nested IF and LEFT formula in a calculated column

I have the following data in a text column called [Workcenter] 1 SOCS CSS SCXP SCQA SCOO SCPR I need a formula which will create the following results CC CC SCX SCQ SCO SCP I'm trying to ...
0
votes
1answer
29 views

Change text-decoration of value in column with column validation

I need the word Received to have a line through it and waiting for as it is. ="<DIV style='text-decoration:"&IF([Status]="Received","line-through","none"))&";'></DIV>" The ...
0
votes
2answers
40 views

Extract text from document name using calculated column

I need to isolate parts of a document name so that the workflow (SPD 2010) can update respective metadata fields. Doc Name is within the following format : yyyymmdd.xxxx.xxxxxxxx.xxxx.xxxxxxxx The ...
0
votes
1answer
18 views

Start time field calculations on calender events fails on full day event entries

I think I have found a bug in Sharepoint regarding date fields and calculations. Here is how to replicate: Make a sharepoint event/calendar list (where items have a starttime and end time) Make sure ...
2
votes
3answers
41 views

Sharepoint calculated column to show today's date and NEVER update

I have a simple custom list. I want to be able to insert a check in a yes/no box and have the date that box was checked appear in another column. I am able to achieve this, but when that list item is ...
2
votes
1answer
45 views

Calculated column to split metadata

Hopefully this is in the realms of the possible. I have a managed metadata column. I wanted this to allow multiple selections and through a workflow I've copied the column to another for use in ...
1
vote
2answers
326 views

how to update formula of calculated column using PnP in SharePoint Online

I want to update formula of calculated column using PnP or powershell. please note that i am using SharePoint Online. i tried below but its giving me error. please help. PS C:\Windows\system32> ...
0
votes
0answers
27 views

Error when create calculated column in a large list

I hava a list that have more than 20k items, and I need to create a calculated column. When I try to do this, sharepoint takes a long time to do this and after displays an error: Sorry, something ...
0
votes
2answers
21 views

Transform data into a date in a list and make it functional

I am having issues trying to transform data into a functioning date in SharePoint Online in a list. The idea is that we display upcoming birthdays for the company but don't display their actual age. ...
1
vote
1answer
29 views

Calculated column between two date fields but if one is blank use another date field

I would like a calculation that gives the number of days between 2 dates (start date & end date) but if end date is blank I would like it to use todays date. How can I set this formula up?
1
vote
1answer
20 views

Concatenate the docID in SharePiont

Can the document ID column be concatenated and used in a calculated column to numbre items in sharepoint library? If yes, how is that done?
0
votes
2answers
48 views

Calucalted colum in list on SharePoint 2010

Hope you're well; Can I have help with the following SharePoint list, I would like the expiry alert date column to automatically update to 6 months post the contract expiry date column; Is possible ...
0
votes
1answer
50 views

Calculating the GROUP BY total in a SharePoint Column

I am trying to do something here, which I do not know if it is possible. I have a custom list in SharePoint 2010 where the "Course" name is unique. I am using "Group By" in the view which shows me ...