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.

356 questions with no upvoted or accepted answers
Filter by
Sorted by
Tagged with
6
votes
1answer
416 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. ...
3
votes
1answer
101 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
165 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
353 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
103 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
83 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
972 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
46 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
684 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
698 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
918 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
1answer
567 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
112 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
233 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
70 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
281 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
167 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
103 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
207 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
1k 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
1answer
29 views

How to remove space from a title column in SharePoint online

I am sure this question has been asked many times, but would someone please be able to guide me with my issue with removing a space between title word, e.g. title "Project ABC" and I would ...
1
vote
2answers
34 views

SharePoint List calculated field syntax

I am unable to get this SIMPLE calculated field to work. Note that I am not a programmer and do not use codes a lot. So please help in details. I have a SharePoint list where I want to get a simple ...
1
vote
1answer
33 views

Calculated column formula help

I have a request to generate a tracker number when a new item is created to a list based on the below logic: The number format is "TN" + CurrentDate(ddMonYY format) + Counter. eg: ...
1
vote
1answer
30 views

ID column does not work with concatenate formula in SharePoint list

I am trying to create simple unique ID for my SharePoint List. All I need to say is ABC-001, ABC-002 ETC. I am using formula =concatenate("ABC-", ID). It works if I refresh the formula every ...
1
vote
1answer
9 views

Can I overload a URL to return multiple subfolders in a calculated column?

I have two images that are both located in my site assets folder and I want to show the two images based on when a source column returns "yes" or "no". I have a wrapped around a ...
1
vote
1answer
51 views

Check if a time is between two other times including minutes

I have a PowerApps form which contains an adjustable "Submission Date" field. Here is a screenshot to show what I mean: I am trying to come up with a formula for a calculated column in ...
1
vote
1answer
24 views

SharePoint Online Calculated Formula

I am trying to create a formula that will auto-populate a column based on the input from two other columns. The auto population would need to check the boxes of the appropriate items that apply based ...
1
vote
1answer
37 views

Calculated Column Formula not Working

I'm trying to create a calculated field with the following formula, but when I try to save the column with this formula it returns a syntax error. What's wrong with the formula? Formula: =CONCATENATE(...
1
vote
2answers
237 views

Sharepoint List 2016 - Replace text

How can I replace the space in between a file name in a calculated column in SharePoint list 2016? Example I have a file name that contains ABC 123 and I want a calculated column to return the value ...
1
vote
2answers
28 views

Multiple IF statement in one calculated column

I have tried everything, can someone help me with this? =IF(ISBLANK([Date1]),DATEDIF([Created],[Date2],"d"),IF(NOT(ISBLANK([Date1),DATEDIF([Date1],[Date2],"d")))) It keeps saying ...
1
vote
2answers
83 views

IF Statement in a SP Library Calculated Column

I have an SP Library that has a 'Name' column. The names of the documents are formatted as follows: 2021 CT0000 Driver Charlie Tuna 1_1_2021.jpg 2021 CT0000 Driver Capatain ...
1
vote
1answer
141 views

Multiple conditions in in Sharepoint calculated column

I am a bit new to SharePoint lists. I am trying to create a calculated column with multiple conditions as below. So the priority needs to be automatically calculated based on other 2 columns Impact ...
1
vote
1answer
21 views

Calculated column from period

My sheet contais 3 columns - date, time period (choices: one yer period, two years period and half year period) and I would like to create rule for the third column which suppose to calculate the ...
1
vote
1answer
40 views

SharePoint calculated column using AND

I'm wanting to create a column that will provide a yes or no answer depending on some other conditions. I thought I found something that was going to work but it didn't. So basically Annual pack days ...
1
vote
1answer
28 views

SharePoint Calculated Column showing #NUM!. One of the Column needs to be in Completed Status

I have a calculated column that will get the date difference between the two columns. Conditions: Difference between Completed Date and Created Date. Weekend should not be counted. If Completed Date ...
1
vote
1answer
13 views

How can I set a special format in a column or leave the field blank

I have a column that is called APC Standard. In this column I want to set the following format APCxxxx (APC + 4 numbers). I also want to have the possibility to leave the column blank. I have already ...
1
vote
1answer
175 views

JSON formatted list view does not display a calculated column value

I am using JSON view formatting to display list items in tiles. I use a calculated column to display a date in the "23 March 2021" format and output it as a single line of text. However, ...
1
vote
1answer
108 views

Column 1 and 2 are equal or the same then column 3 defaults to yes

I want to change a column to yes if two other columns are equal, so same title and report week. So if report week column and title are the same, then duplicate entry is yes. =IF[Report week][Title]<...
1
vote
1answer
130 views

Extract description rather than URL in calculated column to use it with another url

Let's say the first column is UID having number 12345. You will be directed to the URL after you click on 12345. The second column I am trying to create is like a URL to some website followed by 12345....
1
vote
1answer
260 views

Microsoft Lists - Date formula to exclude weekends

I am using Microsoft Lists for our work schedule and I would like the "Due Date" column to be calculated based off the "Prepare Date" and "Number of Days" columns ...
1
vote
1answer
35 views

My Calculated Field with a nested IF(OR) statement is returning error

I am trying to input an email address into a calculated field with the following formula (I have replaced proprietary information with generic information in this formula): =IF(OR([Customer Name]=&...
1
vote
1answer
64 views

Sharepoint: Creating another view with unique values and sum

I have such a list as per screenshot. I need to create another view, where first column "Risk Category" will show only unique values (so only 3 items in this case: "Legal risk, "...
1
vote
1answer
35 views

Sharepoint list columns

Is it possible to create a SharePoint column based on choice (definition) that when selected populates the rating on another column? I will need to add sum of all scores: Thanks a million!
1
vote
1answer
46 views

Mulitple IF Statements based on other criteria

I have this and it works on its own: =IF(ISBLANK([Basic Finish]),"Past Due",IF([FCM 4 Expected Date]>[Basic Finish],"On Time",TEXT([FCM 4 Expected Date]-[Basic Finish],"h:m:...
1
vote
2answers
345 views

How do I create a calculated column that displays Yes or No if ANY other columns in the row have the value "Yes"?

I have a series of 3 Choice columns that are populated by a MS Form to be either "Yes" or "No". I am wanting Column4 to show Yes if ANY of the columns 1 2 or 3 contain the value &...
1
vote
2answers
80 views

Calculated column formula not working when referring to a Yes/No type column?

I am working on a SharePoint list validation to automate some process. I have Column A which is a Yes/No type column and I have Column B which is a calculated column that will take input from column A....
1
vote
1answer
61 views

Calculated Date Difference Question

Before submitting this question, I've tried researching this in the forums and have attempted multiple variations of suggested formulas with no success. So apologies in advance for asking what seems ...
1
vote
1answer
105 views

Calculated Column - Days Difference - Syntax Error

I have a SharePoint List and I'd like to have a column to calculate the days it take to solve a ticket (Solution date - Submission Date). I tried to create a calculated column, by using a formula = ...

1
2 3 4 5
8