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.

0
votes
1answer
15 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.
0
votes
1answer
15 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
2answers
30 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
26 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
3answers
28 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
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
24 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
20 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 ...
0
votes
1answer
26 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
1answer
28 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
1answer
26 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 ...
0
votes
2answers
43 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) ...
1
vote
1answer
39 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
47 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 ...
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
31 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
19 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?
2
votes
2answers
48 views

SharePoint Calculated Column depending on future date

I'm trying to create a calculated column which will return a specific name based on the date in another column. If the 'week ending' column date is within 28 days, I need the calculated column to ...
1
vote
1answer
25 views

How to sort after “group by” in a SharePoint Online list

I have created a list and populated it with some data. I have grouped it with ID column. So now it is appearing with count as below : Numbers in () are the count of times with same ID. I want it to ...
0
votes
1answer
24 views

Average function in Sharepoint - Not compute empty cell

I need the Average of the 4 variables, if one of the variable is empty, then the Average should be the Average of the 3 variables only. This is my formula. =AVERAGE(VALUE([Variable1]),VALUE([...
1
vote
0answers
19 views

Sharepooint Color Progress Bar Calculated column not working in Sharepoint 2013

I copied a formula for color coded progress bar from Path to sharepoint site And everything seems simple, however I think this code was written for sharepoint 2013 and I am getting error for ...
1
vote
0answers
24 views

Need to count entries

I am looking to make it so that each item in a list has a column that shows how many total items there are in that list that share the same value in a column as that list item. If that makes sense. To ...
0
votes
1answer
25 views

Complex calculated column in SharePoint

we have to create a calculated column from a string that can be of the form A01 (letter + 2 digit number) or it can be 2 letters plus number, as in AA1 the logis to use the ASCII codes of the letters ...
1
vote
1answer
7 views

Sharepoint 2007 - Date diference

i need to determine the number of days between two calendar dates. I have create a 2 columns, the first Date 1 and the second Date 2. The date is chosen by clicking on the calendar. What i require ...
1
vote
1answer
27 views

Using a Lookup Column (follow up question)

Following up this question on using Lookup columns: How to use LookUp column? How would you make this work looking up values from a calculated field (Store No) rather than manually inputting the ...
2
votes
1answer
24 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
64 views

Calculating the total of numbers input in a field

UPDATE Hi again, Unfortunately it doesn't work. Here's what I've done: 1 - I've created 1 column called "Nr of hours" as Number column with no other settings. This column is included in my Edit ...
0
votes
1answer
42 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
21 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
34 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
40 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
41 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
26 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
47 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
59 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
33 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
43 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
36 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
36 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
27 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
32 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
25 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
45 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
27 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
81 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
42 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
32 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
44 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
32 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
29 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,...