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.

Filter by
Sorted by
Tagged with
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 ...
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 ...
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 ...
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 .... [...
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 ...
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&...
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;"...
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([...
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&...
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 ...
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 ...
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 - ...
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 ...
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 ...
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 ...

1
2 3 4 5
25