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.
398
questions with no upvoted or accepted answers
6
votes
1
answer
500
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
1
answer
108
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) ...
- 31
3
votes
0
answers
185
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 ...
- 31
3
votes
0
answers
363
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" ...
- 410
3
votes
0
answers
104
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 ...
- 33
3
votes
0
answers
96
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 ...
- 31
3
votes
0
answers
989
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 ...
- 2,326
3
votes
0
answers
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
...
- 718
3
votes
1
answer
736
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 ...
- 101
3
votes
0
answers
704
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 ...
- 670
2
votes
2
answers
1k
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,046
2
votes
1
answer
736
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 ...
- 319
2
votes
1
answer
138
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 ...
- 21
2
votes
0
answers
245
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
...
- 123
2
votes
1
answer
85
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 ...
- 21
2
votes
0
answers
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 ...
- 21
2
votes
1
answer
298
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)....
- 21
2
votes
2
answers
196
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 ...
- 21
2
votes
2
answers
107
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 ...
- 21
2
votes
3
answers
224
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 ...
- 569
2
votes
1
answer
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 ...
- 517
2
votes
1
answer
3k
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 ...
- 283
1
vote
2
answers
34
views
Make a column display only when data is in it
I am trying to make a column display only when data is entered in it. If it has no data, then the column should not display on the page. I tried this formula, but it isn't working. I will appreciate ...
- 11
1
vote
2
answers
25
views
How to combine ISBLANK AND if
I am trying to pre-populate a column in SharePoint to show as 'live' where a separate column is either blank or has a date > than 'today' and to show as 'closed' where a date is entered and is < ...
- 11
1
vote
1
answer
51
views
Creating a calculated field to show 'Red' 'Amber' or 'Green' based on a due date column
I am trying to create a calculated column to return "Red" "Amber" or "Green" based on a due date.
I have a date column called "Due Date" and I am trying to add ...
- 11
1
vote
1
answer
13
views
Can I use a calculated column to show whether a vehicle check submission has already been completed on any given day
I am creating a list which will be used for daily forklift checks that need to be completed via a power app. What I would like is a column that can calculate whether there has already been a check ...
- 11
1
vote
1
answer
30
views
SharePoint list calculated column based on status in other columns
I have a list built with three levels of approval on an item. I want to add a calculated column to quickly show the status of the item based on those approvals.
So if all three approvals exist, the ...
- 11
1
vote
2
answers
13
views
ISBLANK WITH OTHER CRITERIA
I have a sharepoint calculated field that looks at a date and values in two other fields to populate with either a blank or a date.
First criteria:
Units > 0
Second criteria:
Type = "RDS"
...
- 11
1
vote
2
answers
53
views
SharePoint List Column Calculation formular with conditional Calculation
I am working on a fuel issuance list in SharePoint online with 3 different vehicle engines.
Using the columns given below:
Requester Name: (Name Field)
Vehicle Location (Dropdown List)
Vehicle ...
1
vote
1
answer
123
views
SP Calculated Columns with nested IF statements
I'm looking for some advice on nested IF statements within SP as what I am trying keeps giving me errors. I'm trying to get my statement correct and if I can't should I be using a flow instead of the ...
- 11
1
vote
1
answer
69
views
Calculated Column that allows user input if blank
I need a list column with 6 choices, which are color categories: blue, red, green, grey, gold, purple. I want the column to default to a particular color based on another list column, called Project ...
- 23
1
vote
1
answer
48
views
Calculating Date Difference in SharePoint using column Condition
I have sharepoint list to track projects:
Date Started
Date Completion
Project Status (On-going, Completed, Hold, Cancelled)
I want to compute the number of days the project was completed.
If ...
- 11
1
vote
1
answer
112
views
Color format calculated currency column in SharePoint List if formula
I am trying to format this calculated column to show if a number is more than or equal to format it green, or if it is less than or equal to 0 format it red?
- 11
1
vote
1
answer
326
views
SharePoint Online - Multiple Nested If Statement in Custom List Calculated Column
I'm new to the forum. Nice to be here. Hope someone can help me.
I'm trying to apply the following nested If statement to a calculated column in an SPO list. The formula works fine in Excel (with cell ...
- 11
1
vote
1
answer
153
views
Calculated Column in Sharepoint List that allows for manual entry
I am not sure if this is possible or not. I have a dropdown box in a Sharepoint List that is for Grant Type. If "SAG & ESSRS" are selected, I want another column to appear where you can ...
1
vote
1
answer
654
views
SharePoint list calculated column to sum values from another column
I am trying to create a calculated columns in a SP list to show a running total of data from other columns. I am doing this in excel and it works exactly as I need it to, but I cannot find anything ...
1
vote
1
answer
87
views
Formula to convert Julian to Calendar date
I have created a calculated column with which i want to convert julian date (from another column) to calendar
Does anyone know a formula to do that? I've searched the web but I can only find from ...
- 11
1
vote
0
answers
465
views
SPO Calculated Column Not Updating When Item is updated or when Column Formula is updated (by power automate)
I have a calculated column in SharePoint.
It is dependent on non-calculated columns.
So for instance, my calculated column is "past deadline?" and its formula is:
=IF([run]="yes",...
1
vote
1
answer
43
views
How to use an IF statement on a Time/Date column to automatically populate a new column?
On my list, I have a Time/Date column named 'ActivityDate'.
The format of this column is "mm/dd/yyyy hh:mm AM/PM"
I am trying to set up a new column called 'Result'.
If the time on '...
- 11
1
vote
2
answers
16
views
Calculated Column IF MsLists
I'm trying to move one of our old spreadsheets onto MS Lists. There is a formula in there which is:
=IF(AND(E2=0),"0",IF(AND(E2>=6.5,E2<=8),1,2))
I've tried a few variations through ...
- 11
1
vote
1
answer
55
views
Sharepoint List - Calculating weekdays between two dates ignoring blanks (Project Registration Date to Gate 0)
Hi I have a calculated column that counts me no. of weekdays
=(DATEDIF([Registration],[Gate 0],"D"))-INT(DATEDIF([Registration],[Gate 0],"D")/7)*2-IF((WEEKDAY([Gate 0])-WEEKDAY([...
1
vote
1
answer
75
views
Calculated column hyperlink generated not displaying text
I have a SharePoint on-premises calendar list created. need a hyperlink column in event view form to download ics file from a hyperlink.
The download link gets created and works fine but i need to ...
- 13
1
vote
3
answers
240
views
Calculated column to calculate approved status workflow
How to use calculated column to calculate approved status workflow?
I tried this but it doesn't work.
IF([Approve status]="Pendding", 1, 0)
- 23
1
vote
1
answer
25
views
CALCULATED column issue
Scenario:
Need to get difference between two dates (Start Date, End Date) in months, and if End Date is blank, then display "Open".
I am trying:
=IF(AND(ISBLANK[End Date], " ", (...
1
vote
1
answer
346
views
Calculated Column IF OR AND 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:
= IF(
OR(
...
- 11
1
vote
0
answers
85
views
Calculated column dates are a day out when queried in Flow?
I've got a SharePoint list that is used to work out renewal dates of software. The three key columns are "NCE SKU", "NCE Purchase Date" and "NCE Renewal Date". The &...
- 57
1
vote
0
answers
84
views
My Column Formatting No Longer Works (and the problem seems to only be on my computer...)
I have a column that is a Risk Index that calculates based on other columns. The equation calculates as following:
-50
0
30
70
100
-50 = Pending Review / 0 = Completed, no risk / 30 = Risk Mitigated ...
- 61
1
vote
1
answer
522
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 ...
- 23
1
vote
2
answers
194
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
1
answer
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: ...
- 25