Questions tagged [calculated-column-formula]

Question related to the Calculated Column

Filter by
Sorted by
Tagged with
0 votes
0 answers
8 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
21 views

Calculated Total in Descending Order - view in Group By

Is it possible to sort in descending order the calculated total based on group by? See pic below:
  • 11
0 votes
0 answers
5 views

SP List Formula: due date 2 business days after travel date

I have a column with a travel date and need a column for a travel request form which needs to be 2 business days after date of entry.
  • 1
1 vote
1 answer
14 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
31 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
38 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
20 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
16 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
17 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
19 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
19 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
20 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
10 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
36 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
22 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
22 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
52 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 ...
1 vote
1 answer
18 views

Validation in SharePoint List (IF, AND, OR)

I need: If [estado]= "concluido" > turn into mandatory columns [Diagnostico Final] and [Atribuído a] And: If [estado]= "Executando Trabalho" or "em transito" or &...
0 votes
1 answer
32 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
25 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
24 views

Two formulas in validation settings

I am trying to add two formulas in validation settings but getting syntax errors. I have created a leave request list in SharePoint. My requirements are below: If Half Day(Yes/No column) is equal to ...
  • 23
1 vote
1 answer
116 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
22 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
29 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
1 answer
25 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
0 votes
1 answer
31 views

Can you make a SharePoint View that will only show items from Last Year

If at all possible I want to create a SharePoint View on a list that will only show items from the Previous Year. I have a view to show the current year using two calculated columns, but I am trying ...
  • 1
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
10 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 ...
1 vote
1 answer
23 views

List validation to make multiple fields mandatory if dropdown meets condition

I've tried a plethora of solutions from other posts, however I am having no luck. I would like to make FieldA, FieldB, and FieldC required if Dropdown1 is set to 'WON' when creating an item in my ...
  • 13
0 votes
1 answer
46 views

Key-Value in SharePoint List column

I would like to add in a column some key-values choice (multiple or not) KEY1 : "Short description 1" KEY2 : "Short description 2" KEY3 : "Short description 3" saved ...
  • 111
0 votes
1 answer
39 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
42 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
1 answer
21 views

Calculate working days between two dates by each month

I have a SharePoint list with start date and end date. I also have 12 calculated columns for each month - Jan to Dec. I want to calculate these columns so that they display working days between start ...
  • 1
1 vote
1 answer
23 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
43 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 ...
0 votes
1 answer
17 views

Calcualted column is returning "#Name?"

I have the following formula for a single line of text Calculated column named ShowInApp: IF(OR(Status="Inactive",ISBLANK(Status)),"Hide",IF(FIND("Pending",[Category]),&...
0 votes
1 answer
180 views

IF Statements in SharePoint List

I have created a flow within Power Automate that when a Form is submitted it creates an entry into a SharePoint List. Once the entry has been approved a new entry is created in a new SharePoint List, ...
1 vote
2 answers
143 views

Adding Calculated Column to List to sum values in columns while ignoring blanks

I have a questionnaire that populates a SharePoint list. There are a number of questions that return answers as picked from a choice column. I have a calculated column that I'm trying to get to return ...
  • 13
1 vote
3 answers
118 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
29 views

Create column that is filled automatically (depending on another columns)

I am working with a SharePoint list that contains information about new employees. One column represents the StartDate, another column the EndDate (according the contract). In my company we have two ...
1 vote
1 answer
58 views

List Validation with IF & LEN

SharePoint Guru's please guide me to complete List request. Requirements: I have been creating a List for doing User Audit Manager has to select the Choice either Approved or Rejected under Access ...
0 votes
1 answer
34 views

SharePoint List Validation Settings gives me Syntax error

=IF([Urgency Level] = "XL", IF(ISBLANK([Date and Time of Production Stop just in case of XL]),false,true),true) I get a syntax error message with this formula. It tells me either the ...
  • 3
0 votes
1 answer
48 views

Need help with another sharepoint validation formula

I am trying to validate the Ticket Number field for certain task types and i am trying to validate the Manager email field for certain task types. My fields are like this: Task Type (Radio button ...
1 vote
1 answer
54 views

Average Ignoring Blank Columns

Really struggling with formula on a calculated column on my SharePoint list for some reason! I am trying to get the average of 3 columns sometimes one will be blank some times there will be no blanks. ...
  • 13
1 vote
1 answer
39 views

calculate the sum of months from a fiscal year horizontally from one list to a summary list

List 1- Food Jan Feb Mar Total 1000 1000 1000 3000 sum sum sum sum This list is a category and lists 2-Clothes, 3-Water, 4-Internet, 5-Misc are the same I need the sum of the columns of this list ...
0 votes
1 answer
27 views

Calculated column not working properly

I have a calculated column which is not working as intended. There is an 'if' condition which checks the value from a date column called 'Modified' and it sets the calculated column to 90 days after ...
  • 103
2 votes
1 answer
29 views

Need help with column validation on a single line of text field

I am looking to validate that my field always starts with the following text before allowing it to be saved "inc", "sctask", "prb", "chg", or "ritm". ...

1
2 3 4 5
15