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.

242 questions with no upvoted or accepted answers
Filter by
Sorted by
Tagged with
6
votes
1answer
233 views

Calculate Remaining Spent on a budget list

Goal: Trying to calculate remaining spent on a budget list where item expenses are grouped per object code. Every object code has a fixed amount of money against which the item expenses are deducted. ...
5
votes
4answers
8k 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.
3
votes
1answer
65 views

Yes No calculated field for closed/created in last 7 days and items open or in-progress

I would like to create a calculated field that outputs "Yes" or "No" if an item in my SharePoint list has been created in the last 7 days, closed in the last 7 days (field in status column), or 3) ...
3
votes
0answers
118 views

Sharepoint 2013 Dynamic Calculated Column in List View

I need to calculate transaction totals (total price and tax etc) when entering data into SP2013. The following JS code works very well in the New and Edit views but when I try and implement in a SP ...
3
votes
0answers
231 views

Calculated site columns/Lookup site columns - cannot add calculated numeric fields

I have a list with broken down data that is aggregated to some kind of combined ID data format that references a certain file. (Say, there is a file called 123-1. I have a field then that stores "123" ...
3
votes
0answers
102 views

SharePoint Conditional Validation / Formula

In SharePoint Online can i perform the following? I have a column to calculate the date difference between Last Visit Date and Next Visit Date. Last Visit Date is already provided, and users will ...
3
votes
0answers
62 views

Calculated Column not showing appropriately on Mobile

I created a Calculated Column for a contact list which will create a URL to open the contacts Address in Google Maps. It works perfectly on a desktop browser and while requesting a desktop site while ...
3
votes
0answers
926 views

How can I create a traffic light status column

I want to create a traffic light status column in my task list. I have referenced the Path to SharePoint solution (and most of the others out there) but using a calculated column to display HTML and ...
3
votes
0answers
42 views

no items returned in a view with a filter on a calculated column

I'm having a strange issue and Google isn't helping me much in figuring out why. I have a custom list with 3 fields: Title Year calculated column =left([title], 4) single line of text Month ...
3
votes
1answer
539 views

Duplicate filter values in a calculated column

I have a document library with a calculated column. This document library is populated from a windows service. Every time a new document is added, the calculated column has a formula to choose ...
3
votes
0answers
658 views

CAML Contains on a lookup field of a calculated column

I have some issue when using the CAML Contains statement when the field is a lookup field on a calculated column. It basically does not work, the Equal works though. here is the query, nothing ...
2
votes
2answers
63 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 ...
2
votes
0answers
272 views

How to change date format correctly? (1899-Dec-30 error)

I would like to use date format for "Modified" field YYYY-MM-DD instead of the default MM-DD-YYYY. So I created a calculated field with the code: =TEXT(Modified,"yyyy-mmm-dd") But at about 70% of ...
2
votes
1answer
56 views

SharePoint Absolute Reference - Fixed Value in Calculated Field

I'm looking for a way to get the absolute reference of a specific "cells" in a SharePoint calculated column ? For example I got this SharePoint list: A1 - B1 - C1 A2 - B2 - C2 My calculated field ...
2
votes
0answers
202 views

JS Link not working for Calculated Column with OpenPopUpPage command (SPO)

I am trying to make a JS Link for a calculated column that creates a button that invokes a modal pop form. The Calculated column has the Internal Name 'btnEditor', external name 'Update'. Questions ...
2
votes
1answer
49 views

Code to calculate the duedate

Problem is to get code, which calculates from invoice date due date. Payment term is 150 net days and due date should be always on 10th day. I know only how to get it like in Excel. print_date is ...
2
votes
0answers
34 views

Finding workings days for a month

I have a SharePoint list having field as WorkingDays like workday1, 2, 3 etc. For each and every column I have different reports. I need to create a calculated column for all working days for a ...
2
votes
1answer
175 views

If Average calculated column

I am using SharePoint 2007 and trying to automate a couple of columns using calculated value. I have three columns that you enter a number and in the 4th column it totals the average (this works fine)....
2
votes
2answers
122 views

Replace second “?” with Calculated Column

The string below contains two "?" what calculated column formula should I use to replace the second "?" with "&" but not remove the "?" from other strings that have only one "?" Could anyone ...
2
votes
2answers
74 views

Calculate time including IF column value

I have the basic time value formula, but I am having two problems; The first is with this Total Comp Time formula: =TEXT([Start Time]-[End Time],"h:mm") It does display the difference in time as ...
2
votes
3answers
168 views

Including a script in a jslink file

I'm building a simple app on a SP2013 online intranet that uses the Google Books API to pull in GB content (title, author, image etc). The goal is to modify a SP list view to populate the book isbn ...
2
votes
1answer
718 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
2k views

Calculated column is not being crawled

I have a calculated site column AlertSortOrder, which I added to a list. I created a managed property nvAlertSortOrder (sortable, searchable, queryable, retrievable) mapped to the corresponding ...
1
vote
2answers
27 views

=IF(DATE(YEAR([Compliance Date]),MONTH([Compliance Date])+11,DAY([Compliance Date])), “Due”, “Not Due”)

I am trying to create an If statement that looks at a date column in sharepoint and if its 11months after that date the column displays yes. any help on this as: =IF(DATE(YEAR([Compliance Date]),...
1
vote
0answers
30 views

Getting “#NAME” from SharePoint Survey calculated column

In the results for a Survey done in SharePoint 2013 (survey list - type that I'm "inheriting", if you know what I mean). I noticed we're getting "#NAME" in some of the areas we're pulling down. ...
1
vote
2answers
32 views

How to sort column fields and get its total

Dear SharePoint Experts, I would like to ask for tech support regarding on the screenshot that I attached. As you can see from the image, I have a My Requests, All Items, My Balance views, in My ...
1
vote
1answer
19 views

Sharepoint list - if a value is submitted twice or more - show the amount of entries in a different column

I'm working with MS Flow / Form and I'm trying to show the amount of time a single user submits something into Sharepoint. (see below) Is this possible through a formula?] Thanks.
1
vote
2answers
17 views

Using if and isblank to calculate a result

I am trying to calculate a column based on two others. One might be blank and if it is I want the formula to use today's date. I have tried several ways and tested it in excel to ensure I am on the ...
1
vote
1answer
64 views

HTML Rendering in Calculated Columns - SharePoint 2019 on premise

I know that for 2013 and 2016 on premise that there is the capability to adjust a web app setting to allow HTML rending in calculated columnsm via PowerShell: CustomMarkupInCalculatedFieldDisabled ...
1
vote
1answer
35 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 ...
1
vote
0answers
48 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([...
1
vote
1answer
59 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 ...
1
vote
0answers
68 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
33 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 ...
1
vote
1answer
35 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 ...
1
vote
0answers
69 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
62 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 ...
1
vote
3answers
56 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
vote
1answer
67 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
0answers
23 views

SharePoint online Column Empty Item Count

I have a rather large list and I need to count items in a couple of the columns. For example: column1 is [open date] column2 is [closed date]. Both of these are date columns. Column1 has all the ...
1
vote
1answer
295 views

Calculated columns: count number of times a word is selected in a 8 column list

I have the following types of calculations on 8 choice columns with always the same values High, Medium and Low. If there are 2 entries of High, the column should say High, if there are 4 entries ...
1
vote
0answers
109 views

force infopath field to update

How can you force a number field to be updated? Once the entry has been changed from i.e 365 to 700 the number doesn't refresh. An example I have 2 lines of information. you can only select one by ...
1
vote
2answers
25 views

How can I show two dates in one field if one of the dates is blank?

The business wants two dates to show up in one field in a SharePoint 2013 List. I have created a calculated column which combines the two dates but I run into issues if one of the dates isn't filled ...
1
vote
3answers
1k 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 ...
1
vote
2answers
74 views

How do i get a choice column to change from YES to NO depending on another column using calculated columns

I'm trying to uses nested ifs to change what a choice column displays but I'm not sure if this can be done or if I'm doing it properly. What I'm trying to have accrue is once the next review date ...
1
vote
1answer
72 views

Mysterious “Current” column in SharePoint Issues list

I have a SharePoint 2013 list that is based on the Issue Tracking template. It has a "Current" column that is available in views, but is not displayed on the List Settings page. If I turn on manage ...
1
vote
2answers
124 views

Is it possible tpo use the excel weeksum function in SharePoint to return the week number from a date column?

I am new to SharePoint and I know that in Excel you can use the WEEKSUM function to return the week number from a date column. Is it possible to do the same in SharePoint 2013? If so how can this be ...
1
vote
1answer
28 views

Looking to build a list for employee numbers with multiple data points

I need to build a list in SharePoint that auto assigns a sequential number and can associate that auto assigned sequential number to a "smart number" based on the company code. For Example: ABC ...
1
vote
0answers
25 views

Multiple Content Types Duplicating Values in Calculated Column when updating CT

List Setup I have a list setup with 3 content types. Content Type A, Content Type B, Content Type C The list has 3 choice columns setup for each content type. This enables the choices available to ...
1
vote
0answers
75 views

Calculated column based on specific elements from another site column

I have this site column in a Sharepoint 2013 list showing a few deadlines. I need to create a calculated column next to the one in the picture, that gives as a result the number of days between one ...