Stack Exchange Network

Stack Exchange network consists of 175 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

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

How to use a lookup column's additional field in a workflow?

Background I have two lists. One is a list of voltages and their corresponding costs. This is to be used as a lookup for other lists. Voltage Cost 120 2.50 240 ...
2
votes
1answer
4k views

Calculated field based on values in other columns

I have a new SP 2013 List that I would like to add a new field with a calculated 'score' based on the values of a few other columns. For example, The Choices for Col1, Col2, Col3 and Col4 are all ...
0
votes
1answer
3k views

How to auto populate new column based on another column

hope everyone is well; I am trying to auto-populate a column based on another column's choice. For Example, Column A (labeled Job Title) there are 4 choices. I would like to have another column (...
1
vote
2answers
1k views

SharePoint Online - Link to Item - Calculated Column

is it possible to assign Link to Item to a Calculated Column in SharePoint Online? I have read a few solutions suggesting editing AllItems.aspx in SPD designer but the calculated column is not listed ...
1
vote
1answer
713 views

How do I sum a column in SharePoint 2013?

I have a requirement that I need to sum a column in my SharePoint page then send a email if its one or bigger. I have got the email part down and its working, the problem is everything that I can ...
1
vote
2answers
3k views

Can sharepoint calculate the number of “business hours” for a list item to be completed?

I work in financial institution and we want a column in a case management database to show the number of "Buinsess hours" from start to finish of a case. Business Hours Monday to Friday 5am - 8pm ...
1
vote
1answer
603 views

Calculated Column to extract text within file path

Due to SP limitations in workflows for extracting text strings, I'm looking for another way to skin the cat. If I have a single-line text column that has a file path like: C:\folder1\folder2\...
1
vote
1answer
23 views

Calculated Column Next Year in Text Format - (Sharepoint 2013 on Prem)

I have a calculated field [Current Year] in Text Format: =TEXT(Created,"YYYY") which displays "2019" in Text Format. But I also want to create a new Column with a calculated column that is next ...
0
votes
1answer
10 views

Using Excel AVERAGEIF in a Calculated field

Using this statement =AVERAGEIF(B2:B13,"<>0") found here: https://www.extendoffice.com/documents/excel/1573-excel-average-ignore-zero.html My calculated SharePoint field would be this: =AVERAGEIF(...
1
vote
0answers
44 views

SharePoint 2010 - Calculated column - IF statement with (OR) not working

I have the following entered as formula in a Calculated column (returns single line of text)... I'm going to add to the formula, but it's stuck on this point; takes me to error page: =IF( OR( LEFT([...
0
votes
1answer
17 views

Set date column default for specific time on day

I have a date and time column in a SharePoint document library Is it possible for the default value to be a certain time (e.g. 1pm) on the day of creation?
5
votes
4answers
7k views

How to apply CAML query on the Calculated Column of the list?

I have a calculated column that stores the calculated date value. When I apply the CAML query, it does not return any row even if the record exists.
0
votes
0answers
11 views

Adding a sum column which uses data from lookup

I have a list with employee names and a lookup column from another list, which has the training names and training duration. The training duration is added as an "additional field" from the lookup ...
0
votes
1answer
16 views

How to calculate the third Monday of the month an item is created using a calculated column (date / time)?

How to calculate the third Monday of the month an item is created using a calculated column (date / time)? I wish to calculate the date based on the created column.
2
votes
1answer
61 views

3rd Tuesday Calculated Column not working when there are 5 weeks in the month

Looking for some assistance on why my calculated column formula doesn't work when there is 5 weeks in the month. I have one column called Current Patching Date (date/time field) - stores a date I ...
2
votes
3answers
1k views

Calculated field shows text instead of image

SP Online, task list. Created calculated field with this formula: =IF([Task Status]="Completed","<DIV><img src='https://cdn.sstatic.net/Sites/stackoverflow/company/img/logos/so/so-icon.png /&...
41
votes
16answers
20k views

June 13th 2017 Microsoft blocked handling HTML markup in SharePoint calculated fields - how to get the same functionality back

On June 13th 2017 all SharePoint calculated columns with HTML markup stopped working. Basically the fields now render text (regardless of setting the data type to number). The gist of the notice ...
0
votes
1answer
638 views

Highlight upcoming/overdue calculated column dates in a training list

I have a list to track customer training. Two of the trainig items are recurring; Ethics - annual and GPC Refresher - biannual (every two years). The due dates for each training requirement were ...
0
votes
2answers
33 views

Calculated formula not showing correct behavior

I have a calculated column called DaysDifference which calculates days difference between two date fields: [Due Date]- [DateToday], I am updating datetoday field everyday using Flow to set it to ...
0
votes
1answer
16 views

Difference between dates in two last items form the same order

I tried to look for the answer in the forum and google, but with no success. I have a list: let's say: 'Site ID','Date requested' 11111, 2019-03-05 11110, 2019-03-15 11111, 2019-05-01 I want to ...
0
votes
1answer
33 views

Title and date in a calculated column (SharePoint Online)

I need to create a calculated column with the value from the Title column and the date part from a Date & Time column, separated by a space and the date format like YYYY-MM-DD. Something like ...
0
votes
1answer
659 views

Calculated Column formula returns syntax error

Found this one that seems to be the solution needed but i cant get it to work: Column1 has the value of BD122 Formula: =EXACT([Column1], "BD122") Expected result: Compares contents of Column1 and ...
0
votes
3answers
34 views

Unable to calculate field value from conditional formula

trying to find solution for calculation of rates. The data type returned from this formula is number. if ([Role]="​Senior Software Engineer", "200", if ([Role]="​Senior Technical Consultant", "400", ...
0
votes
1answer
703 views

how do I add 90 days to a calculated column?

I have 3 columns, for simplicity we'll say column A, column B and Calc Column. In the Calc Column I need a formula for the following: If column A is blank, and column B is greater than 90 days from ...
0
votes
3answers
1k views

How can I sort this by an actual DATE?

I have a calculated field in a document library that takes the "Modified" property makes a more readable date from it. The problem is, the column is now sorting alphabetically, even though the data ...
1
vote
1answer
61 views

calculated column IF OR

I'd like to create a calculated column that helps me segregate options based on a previously selected choice. The essential argument will be the following that if the user selects Alignment A then ...
0
votes
0answers
6 views

Calculate “Days Since” a specified date

Good Afternoon I am using Sharepoint 2013 OP with SPD 2013. I want to create an element on my SP site which calculates how many days have elapsed since our last accident. For Health and Safety ...
0
votes
0answers
31 views

SharePoint Online : Help to Update Calculated Column in a List on a daily basis

I have a list in SharePoint Online environment where I need to calculate DaysLeft using 'Expiry Date' Field - Today() in a calculated column. The calculated field is not updating on a daily basis. ...
0
votes
1answer
31 views

Is it possible to dynamically refresh a calculated field on the Edit form when a connected field is changed?

On the Edit form, I am trying to dynamically have a calculated field show updated values when the connected field is changed. The idea is to give the user more details on the selected week. Is this ...
2
votes
1answer
811 views

Calculating on Lookup column without the use of SharePoint Designer?

Trying to find a way to join values in two separate columns into a third however one of these is a lookup field to a second list and as I understand you cannot do calculations on lookups without using ...
0
votes
1answer
33 views

sharepoint 2013 library calculated column

I want to create calculated column in SharePoint library, but get error here is error that I got and also here is column Can someone tell me what I have done by mistake?
0
votes
2answers
49 views

Calculated Column Formula to hide blank values

So this is a follow up from my question yesterday as I believe I have found a work around or at least a potential one. To cut a long story short I have a list called "Team Information" this contains ...
0
votes
1answer
758 views

How to add hyperlink from other list with lookup

I gave up. The task looked simple: I have a list with clients with 2 columns: clientname, clientid, URL. I made another list where managers could collect clients from this list that they frequently ...
0
votes
1answer
750 views

Format DateTime field in calculated column display in browser timezone

I want to format my [Start Time] column as a short date. I created a calculated column and employed the TEXT() method like so: =TEXT([Start Time], "MM/DD/YYYY") However, it appears that this is ...
0
votes
1answer
30 views

IF OR Syntax in SharePoint

I need help adding some logic to my syntax. Current formula is set to the following value and it works perfectly: =IF(AAA<>"","Closed",IF([BBB]<>"","Pending Approval","Pending Review")) ...
0
votes
2answers
999 views

SharePoint list - Validation settings Formula

I have a SharePoint 2010 list with Drop Down column named "A" which has 3 choice values. The list has 3 more columns namely "B","C" and "D". I'm trying to set a validation on the list as below: ...
0
votes
2answers
54 views

Background color on column

I am not a SharePoint guru and I don't know much about coding. I have a list which I would like to change the background color of the cell or row based on the Priorities ( (1) Critical, (2) High, (3) ...
0
votes
1answer
28 views

Need help on calculated column formula for below requirement

I am using OOTB SharePoint Task List. Due Date column has date values tagged for each of the tasks. I am trying to add a calculated column which should be set to Valid if following two conditions are ...
1
vote
1answer
47 views

Calculated Column 48 hours due date weekday

I am trying to generate a simple calculated column formula for a 48 hours email alert considering weekdays only. No weekends. New at this. Any ideas.
0
votes
2answers
828 views

The formula contains a syntax error or is not supported

I'm trying to add a column to a table I created in SharePoint. I want the column to do the following: Given the status of an action e.i. due or over due, calculate the number of days that the action ...
0
votes
2answers
955 views

Referencing Choice Field in Calculated Columns

I have a question regarding Calculated Columns. I have a Column Called "NextMileStone", this column can contain "PM010", "PM020, "PM040", "PM070", or some other choices that would be the "else" ...
0
votes
2answers
51 views

SharePoint Calculatted column

I need to create a calculated column to get the number 7261 from the string below. Sometimes it can be 4 digits, sometimes 5, so cant use exact character count. I tried to use the FIND option and ...
1
vote
1answer
868 views

Count occurrences of a character in a string

I would like to find the number of values or commas in a single line of text column. For example if the entry is 1,5 ,10 I would like the count to return 3 (or 2 if counting commas). I have tried ...
0
votes
1answer
783 views

Boolean field values differ between the InfoPath form and the SP view. Why?

I've got a 2010 SP list that tracks tickets about an application I own. It tracks various ticket attributes including'status' and 'type'. I want to create a view of 'open' tickets for my developers ...
1
vote
1answer
799 views

how to change the format of the “person or group” column

In my document set (Sharepoint 2010) I have a column with type of “person or group” which I can add the name of some users to it. The format of the names is like this: firsName1 Surname1; firstNmae2 ...
1
vote
1answer
903 views

Calculate 14 days or less on Expiry Date column from Todays date

I have a library with a column 'Expiry Date'. I wish to create an additional column to advise the user if a particular entry needs to be reviewed. The parameters for this is if the 'Expiry Date' is ...
0
votes
3answers
994 views

How to set Date column with default value as calculated value?

One date time column: Target date Requirement: Need to set default 'Target date',5 Days ahead of item creation date. I have tried this:= but it is not working =[Target date] = [Created] + 5 Kindly ...
0
votes
0answers
29 views

Workflow and columns set up for calculation

In a list that we use as ticketing tool, I have a field where I have to input my working hours every time. I'm looking for a way in which I can just input a number in that field but also have another ...
0
votes
1answer
36 views

Calculated Columns with Conditions

I have found plenty of posts that mentioned how to add multiple conditions to calculated column but my formula is not working. The action is pretty simple that is why I feel like silly that it has ...
0
votes
2answers
27 views

Attempting to get a Calculated Column to output Yes/No (Formula)

I am trying to make a calculated column produce a Yes/No when: IF([Reminder Date]= [Today], “Yes”) and IF([Reminder Date] does not equal [Today], “No”) What is the correct formula?