Questions tagged [calculated-column-formula]

Question related to the Calculated Column

Filter by
Sorted by
Tagged with
2
votes
1answer
863 views

SharePoint 2010 using REPLACE and FIND functions multiple times in a calculated field

I'm working on a SharePoint 2010 site where I have a field which contains three letter characters which are separated by a hyphen e.g. AMO-SMF. I have created a calculation which can FIND and ...
0
votes
1answer
28 views

SharePoint Calculated Column by searching another column for various strings

I am working with a SharePoint 2016 list that contains one column with names and other values. I want to use a calculated column to search that "name" column and return another value if that "name" ...
0
votes
1answer
22 views

How to calculate the difference between two data in the same list column

I want to know how to calculate the difference between two data in the same column of a list. It is useful if we are monitoring the changes (daily-monthly-etc). TX for your suggestions on how to make ...
0
votes
1answer
2k views

Calculating overdue status in a Sharepoint list using calculated column

Hoping someone can help as I am relatively new to Sharepoint. I've created a list to track completion of internal audit activity. It includes a status column and due date column. I'm trying to ...
6
votes
2answers
708 views

Calculated Column Based on Version Not Updating

I'm using a calculated column [DocumentStatus] and versioning to try and do some colour-formatting based on Approval Status. I have Major & Minor versioning turned on. Since I cannot use Approval ...
1
vote
2answers
41 views

Calculated column from a multiple lines column

I made this formula for a calculated column that works from with single line columns, but am unable to make it work with a multiple line column. =IF(ISERROR(FIND("flight",[shipping])),"ground","...
1
vote
1answer
20 views

SharePoint List - Time Calculation

We have a change control SP list and do aging metrics on how long an item is open. I have a calculated field to calculate how long an item has been open, but am getting a negative serial date as a ...
0
votes
1answer
27 views

Sharepoint list for vacation accruals and usage

I've been trying to create a sharepoint list that displays the current available balance of an employee's vacation hours. I'm having issues creating a column that is calculated based on several other ...
0
votes
1answer
15 views

Date must be more than 2 Years from today

I have a date column in a SharePoint list. This column need to be filled with dates that 2 years forward from today or more. How can I write the validation formula for this? Much appreciated if ...
0
votes
1answer
23 views

Share point calculated columns with nested if statements

can anyone please help me in cracking the logic in below if statement, that i am trying to solve. Below is the logic i am trying three columns Item status, Treasury status and MD status if Treasury ...
0
votes
0answers
14 views

Creating a sequential number on a SP online list

I thought this would a fairly straight forward problem to solve. My client needs a unique identify number for a list item and it has to be seven digits long and sequential. I thought there would be a ...
1
vote
2answers
697 views

How to Conditionally Require Data in more than one SharePoint Column

I am attempting to calculate the outcome a status field based on the outcome of other columns. They are all Test Fields. For Example: "Overall Approval Status" column is to be based on Accepted/...
1
vote
2answers
46 views

Increase number of decimal places in SharePoint calculated column while list exceeds the list view threshold

I am facing an issue while I need to increase number of decimal places of list calculative column. I need it in SharePoint online - unfortunately the list contains more than 40K records (and ...
1
vote
1answer
53 views

How to set date for 2 weeks out for an automated reminder

I have a SharePoint list that is populated with ticket data. There are two primary columns "Open Date" and "Calculated Date" I'm trying to figure out how to set the calculated date 2 weeks out from ...
0
votes
0answers
9 views

Auto-calculate Average in Range

I have a user that wants to convert her Excel file to a SharePoint list and use the same formulas. I have one column that is an Average of the cells in a range over the column next to it. Example: ...
1
vote
1answer
9 views

Marking item as “Delivery not met” sharepoint list

New to SharePoint lists.. trying to find a way to mark items that did not meet the deadline. I have the column "Expected Completion Date" and "Date of Completion" (Both are in mm/dd/yyyy format). I ...
1
vote
1answer
21 views

Calculating Formula for days and text

Trying to write a formula that calculates the expected completion date based on the priority of the project day it was assigned. For two of the priorities, it needs to be a text response in the ...
4
votes
1answer
3k views

How to filter tasks for previous calendar month

How to setup view, that would show all "Tasks" for previous month ? I can find first and last day of previous month. End of previous month: End_of_previous =DATE(YEAR([Activity Date]),MONTH([...
0
votes
1answer
24 views

How to write the calculated formula for a column SPList to display total number of items in the list

In the SharePoint List, total is being displayed. But I need to upate the total in a column of every item using calculated formula. If this is possible can anyone help me with the calculated formula. ...
1
vote
1answer
37 views

Formula for swapping the choice in a drop down with a numerical value

I've got a SP drop down column which contains options like: Doesn't align to current priorities Somewhat aligns to current priorities Aligns strongly with current priorities I want to assign all of ...
0
votes
0answers
12 views

Switch function in SP calculated field? [duplicate]

I've got a SP drop down column which contains options like: Doesn't align to current priorities Somewhat aligns to current priorities Aligns strongly with current priorities I want to assign all of ...
0
votes
1answer
30 views

Adding Multiple Conditional Formulas to a Single Custom List

Conditional Formulas? Have a formula that will work for comparing 2 items to see if one is not greater than another, but I need to add multiple validations into a single custom list. How do I do this? ...
0
votes
1answer
917 views

How to Set Specific Date and time in Field of SharePoint List

I have a requirement where we need to create a view in a sharepoint to filter items created after 4pm on Friday until next week 4pm on friday. This is what i have accoimplished so far. Created a ...
0
votes
1answer
1k views

Copy to Clipboard Button in a Calculated Column (SharePoint Online)

I have a Text field called urlText in a Document Library List. Everytime a document is created, a workflow populates this field with the URL of the Document. I want to make a calculated column/button ...
1
vote
1answer
33 views

Calculated column: If this than that, with a calculation

I have a column named Soort. It has 3 stringvalues. One of them is Brandstof. There are 2 other columns: AantalKm and Km-vergoeding. They are both numbers fields. And there is a KostenBrandstof column....
1
vote
2answers
30 views

Calculated Column as Title on SharePoint Calenar

I am working in SharePoint to create a calendar that will pull the information from the "Content Category" column and the "Title" column into the title field. To do this, I am trying to create a ...
0
votes
2answers
28 views

SharePoint online When date column has date in it or is TRUE update different column with preexisting selection

I'm having trouble figuring out what to do in this specific circumstance. I have a PowerApps form. In this form I have several fields but there are 2 that I'm trying to build a dependency on. A date ...
3
votes
2answers
127 views

Percentage formula showing extra numbers

I'm trying to get a SharePoint formula to show a percentage of time remaining on a contract. I'm nearly there but it's showing a lot of numbers to the right of the decimal point. I've tried a few ...
0
votes
3answers
61 views

How to count number of days from SharePoint list?

How to count number of days between two dates from SharePoint list using CAML query/JavaScript? Thanks
0
votes
1answer
683 views

Using calculated field to fill an email recipient, subject and body?

I am using calculating field to fill an email field and it does work perfectly for the "recipient" field. <Field ID="{BE6CFDC4-07CF-4175-98E7-E82259A41B5F}" Name="myfieldInternalName" ...
2
votes
1answer
27 views

Showing the time remaining between two Date columns as a perentage

I've got two columns 'Contract Commencement Date' and 'Contract End Date' and I'm trying to show the time remaining as a percentage in a third column. Using Flow I've got a field to show todays date,...
1
vote
2answers
66 views

Calculated field question

Currently working on documents with status and expiration date and created 2 columns in SharePoint I want the status column to automatically tell me if the document is current or expired. The formula ...
1
vote
1answer
51 views

Columns doesnt count right

So I got this example: The green value should show 01:00:00 but it doesnt. I think the formula I got "ROUND" it somehow (I got the code online). And I need this code so the value can exceed 24 hours. ...
1
vote
1answer
38 views

Yes or No in calculated fields instead of 1 or 0

Say, I have a SharePoint list with 2 columns, A and B. A contains a list with three items: one, two and three. B is calculated yes/no field, where I use the formula =If(A="two";TRUE;FALSE). This ...
1
vote
1answer
37 views

Add Sharepoint calculated field using AddfieldasXML - key cannot be null

I am trying to add a calculated field using the AddFieldAsXML method. And below is how I constructed the field xml. > fieldXML ="<Field ID=\"{ABB544B1-5433-4B49-A629-7B242D3548E5}\" > ...
0
votes
1answer
22 views

Working out the percentage of a term left from dats into months

I've got a field called Term months which contains the length of a contract in months and a field called Days Left which has the remain length of the contract in days. What would the formula be for ...
1
vote
3answers
25 views

If a column is NO, change another column to Closed

I have a SharePoint list with a status column which has the following in which works great. I'm looking to add to the formula dependent on another column - is this possible? If consent required ...
0
votes
1answer
36 views

Reference to custom column in formula raises “The formula refers to a column that does not exist” (SPO365)

I wanted to illustrate Calculated column in a List of a SharePoint 365 site. My List, "Inventory", has columns "Product", "Origin" (text), "Stock (Kg)" and "Security Level" (numbers) all mandatory, ...
0
votes
2answers
17 views

Perform column Calculation only when particular field is updated?

In a custom list, I have a choice-type column named "STATUS" which has the following available choices: To command commanded received I also created a Calculated column named "CHANGE" with the ...
2
votes
2answers
29 views

DATEDIF Calculation losing a minute

I have a timesheet for users to enter Start Time, End Time and Breaks. I've created this calculation to total the number of minutes worked. However, sometimes it loses a minute. How do I fix this ? ...
1
vote
1answer
30 views

Calculated Column: Nested if statement

Good Afternoon, Goal: Calculated column called "Certificate Status" (Data type returned: single-line of text) that identifies if an individual has provided the certificate for a required training. ...
0
votes
1answer
33 views

Populate Column with IMAGE based on another column's content

Here's a variation I'm having an issue with: I'm trying to populate a column based on the content of another column (choice field). While I'm currently doing this with a workflow, I know it can be ...
2
votes
3answers
4k views

“The formula refers to a column that does not exist. Check the formula for spelling mistakes or change the non-existing column to an existing column.”

I am trying to create calculated column using csom. var fieldXml="<Field Name='calctest' DisplayName='calctest' StaticName='calctest' Type='Calculated' Required='FALSE' ColName='sql_variant1' ...
2
votes
1answer
32 views

Display text in a column based on what is in two columns

I have two columns [Impact] and [Urgency] that are choices - I would like to display text in another column based on the choices in those columns. if[impact]=High and [Urgency]=High then display "...
4
votes
2answers
55 views

Calculated column to show status if another has a value

I have a SharePoint list with a completed date column. I wish to have a calculated column called status so when the completed date column has a date in it, it shows "Closed" and when it is blank it ...
0
votes
2answers
11 views

is AVERAGEIFS possible in Sharepoint calculated column list?

Sorry I'm new to SharePoint. I am building a tool to track projects and would just like to ask if it is possible to have a column to automatically average all projects with the same 'priority name' ...
0
votes
2answers
17 views

calculated coluum formula error

Escalation status to be calculated as per below: Conditions: 1)if the status is "ETA Slipped" and Original ETA is > 15 days and Revised ETA is null Escalation status should be "ETA slipped beyond 15 ...
0
votes
0answers
19 views

Calculated column won't be created!

I am trying to create a calculated column. I tried below formulas: =([ContractFinalKm]-[Present/RealFinalKm])/ABS([Present/RealFinalKm]) AND =([Present/RealFinalKm]*100)/[ContractFinalKm] Neither ...
0
votes
1answer
28 views

Need help with displaying text depending on choice

I am trying to get this formula to work. I want: IF column ärende tilldelat is blank I want the calculated column to say "Ej tilldelad". If you have chosen "Tillkoppling" in the column Ärendetyp I ...
0
votes
1answer
28 views

Does Sharepoint allow IFS formula

I tested this on excel but can not translated to Sharepoint. I am trying to test for example if Column C has date that is greater than the one in column D = Submitted on time, if column C's date is ...

1
2
3 4 5
11