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.
1,212
questions
1
vote
1
answer
9
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
0
votes
0
answers
9
views
Sharepoint List Calculated Column gives different results in Classic View
I have a Sharepoint List. One of the columns (called "Assessment Date/Date Re-Joined") is a date, and another column is a calculation based on that date column:
=DATEDIF([Assessment Date/...
- 101
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
15
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
1
answer
9
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
0
votes
1
answer
19
views
Calculated Column- First Name from Full Name
I'm trying to write a calculated column formula to return the First Name from a Full Name column. The issue is, that the full names are displayed in different formats:
Jacob J. Smith
Peter Grabowski
...
- 1
1
vote
1
answer
51
views
Calculated column with IF condition
I'm writing from Italy. I have a list of 5 columns: one of them is called "available" and it's a yes/no column.
Another column is a text column called "last name". I want to create ...
- 13
1
vote
2
answers
50
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 ...
0
votes
1
answer
22
views
How to check for a date/nulls and compare to the current date?
=IF(ISBLANK[Version-created];"";[Version-created]+365)
=IF([Version-created]="";"";[Version-created]+365)
I created these formulas to first detect if there is a date in ...
- 1
0
votes
0
answers
9
views
In a Date Column. Default view a calculated "Due Date" based on a date "Start Date" that can be edited with actual "Completed Date"
The columns I want to use are:
"Start Date" and "Event Date"
I want the default value in "Event Date" to show "Start Date"+21 (indicating the "Event" ...
0
votes
2
answers
25
views
'#Value!' error in filtered lookup column
I'm trying to create a filtered lookup from a 'Projects' list that sits on a SharePoint site.
I followed the steps to create a filtered column in a SharePoint list as outlined here: How to make a ...
- 39
1
vote
2
answers
56
views
Combine date and text columns in a new calculated field
Creating a new calculated field in a SharePoint List (Office 365) that combines a text (Region) and a date (StartDate) column. The Region field has a value "DFO" and the StartDate has a ...
- 13
0
votes
1
answer
95
views
Field not showing in the view all details of a list item
I have a list on a SharePoint site that is coming from the Content Type Hub. Since I don't know where the content type fields are being used I created a new field on the site list settings and not ...
- 23
1
vote
1
answer
22
views
Calculated column Multiple with multiple IF(IF()) error
Good morning people. I'm sorry but I need your help.
I have tried to create a calculated column in SharePoint list, depending on two values "height" and "area" corresponds to a ...
0
votes
0
answers
12
views
How do I write a NETWORKDAYS formula in SharePoint? [duplicate]
I am trying to write this formula =(NETWORKDAYS([open date],[closed date])-1) in a SharePoint list. Any idea how we can make this work?
1
vote
1
answer
22
views
Calculated Value Code
I have a list with about 15 columns. I need to have one of my columns pull the initial value entered (only) of one of the other columns.
Example:
[Column A] is blank then changes to 2/2/2023 .... [...
- 11
0
votes
1
answer
43
views
SharePoint Lists - Can you Lookup a Lookup column value?
Hear me out on this one, I know it sounds silly but I am looking for a work around to this issue. We know that building a database would be the best solution, but that is a project for the future at ...
0
votes
1
answer
34
views
Nested Calculated Column Returns Invalid Syntax
I have a column [Meeting Date] which is used to determine [Initial Date]. The user when creating a new list item, inserts a date for [Meeting Date] which is automatically set to Today's date. [Initial ...
- 113
1
vote
2
answers
43
views
SharePoint Online - Calculated Column
This is my first attempt at this and I'm getting syntax errors. What I want is a column that has a conditional value based on another column "Probability".
I have tried a few variations with ...
0
votes
0
answers
22
views
SharePoint List Using a Master Date
I am creating a SharePoint Critical Path list with dues dates. I would like the due dates to be calculated using an "Opening Date" - weeks out column.
I am wondering where I can set this ...
0
votes
1
answer
22
views
Calculated Value with IF statement
I never seem to get this right...
I have a date column 'Option1 and a numeric column 'Length'
The calculated date needs to be if Length = 1 add 7 days to Option1, if Length = 2 add 14 days:
The ...
- 51
0
votes
1
answer
18
views
SharePoint Calculated Column Multi Conditional Formula
I have a Final Submission Due Date calculated column.
I am trying to create a condition to where if another column (Yes/No Boolean) is checked add a certain value, if not use the original value.
I ...
- 113
0
votes
2
answers
20
views
How to express this condition in SharePoint Calculated field
How to express this condition in SharePoint Calculated field?
A field should have a result of yes or no with below condition:
If ALL the fields value is completed answer should be No, else Yes.
1
vote
1
answer
33
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
0
votes
1
answer
31
views
How to combine two columns into one formula?
I have this formula for column named "Level of Risk":
=IF([MultipleFunctional]<6;"LOW";IF([MultipleFunctional]<10;"MEDIUM";IF([MultipleFunctional]<20;"HIGH&...
- 57
0
votes
1
answer
10
views
Whats wrong with my formula?
I'm using this formula in SharePoint for "Level of Risk":
=IF([MultipleFunctional]<6;"LOW";IF([MultipleFunctional]<10;"MEDIUM";IF([MultipleFunctional]<20;"...
- 57
0
votes
1
answer
12
views
Answer of date after editing the column
I have 2 columns, one of them "Approve Status" - it's a choice of two options, after selecting one of them column "Approve Date" setting the date by using this forvula "IF(OR([...
- 57
2
votes
1
answer
61
views
Calculated column syntax error
I use this formula for the date to appear after changing the data in the column (two answers). This formula works for me:
(IF([Approve Status]="Approved";TEXT(NOW();"dd/mm/yyyy hh:mm&...
- 57
1
vote
1
answer
34
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
32
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
64
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
143
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
0
votes
1
answer
106
views
SharePoint List Calculated Column with multiple conditions
I currently have two columns in a SharePoint List, "Due Date" and "Received Date". I would like to create a calculated column that shows a status of Complete, In Progress, or ...
- 1
1
vote
1
answer
47
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 ...
0
votes
2
answers
39
views
Month and Day functions treating dates as 1 day back
Can any one explain this. I have 3 columns, a date column, month and day columns. The month and day columns are calculated columns of the date column.
DOB - Date/Time (Date only format)
DOB_Month - ...
- 39
1
vote
1
answer
367
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 ...
0
votes
0
answers
32
views
SharePoint list running total column using data from a different column in the same list
We have an excel sheet that I am trying to bring into a SP list. The sheet tracks total submissions, total "passing" and total "failing". This number is cumulative number, so ...
- 1
1
vote
1
answer
38
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
1
answer
41
views
Help with Calculated Column conditional formula with OR
I am trying to categorize a SharePoint list of projects into colored approval tracks based on project type using a calculated column. So, depending on the choice from the Project Type column, the ...
- 23
1
vote
0
answers
249
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
31
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
15
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
11
views
Getting the results of two or more columns to change another calculated column
I have searched and searched the web for the answer but nothing I try seems to work in these SharePoint calculated columns, basically, I have a column called Email Sign Off and another called ...
0
votes
0
answers
13
views
Create a calculated Column in SharePoint. using If then statements to search cells for answer, if empty keep searching
I need to Create a calculated column called “region” using an if then statement as the algorithm to search for an entered cell out of the 5 regions, if it finds it, insert it in the new calculated ...
0
votes
1
answer
59
views
Use Metadata field in formula
It seems that SharePoint didn't allow Managed Metadata columns to be used in calculated fields something like a decade ago.
Is there a way to add metadata field/column in a calculated column's formula ...
- 111
1
vote
2
answers
78
views
SharePoint list calculated column 3 validations for IF statement
I have a SP list that contains software installation data. There is a calculated column that calculates price. There is a column called Installation Date which has 2 choices either Before Sep 30, 2020 ...
- 13
0
votes
0
answers
19
views
Can I display Modified Date for documents only (not folders) in a Document Library view?
I have a document library in a SharePoint on premises site. I want to display the modified date of documents in the library, but folders show the modification date of the folder itself, not the most ...
- 135
1
vote
1
answer
37
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([...
0
votes
1
answer
15
views
Years of Service with IFBlank but what if date is in future
I have a field that calculates "Years of Service" and calculated to either TODAY for a active employee OR to the termination date if terminated. However, on the list dashboard if the start ...
- 5
1
vote
1
answer
65
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