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
0
votes
1answer
373 views

Calculated Columns - Comparing multiple columns with IF statement

I am fighting with SharePoint calculated columns and trying to compare multiple columns. The SharePoint list has the following columns: Completed Date - Date Completed - Yes/No Due Date - Date ...
0
votes
1answer
23 views

Initiate a Work Flow Every 24 hrs

I have the need to initiate THE MOST SIMPLE ACTION possible every 24hrs in an SP List. The action doesn't even have to do or mean anything, just kick-off in a way that it impacts the entire SP list; ...
0
votes
1answer
40 views

Minus 5 hours 30 minutes from a date

I have a column of type as date and time. I want to minus 5 hours 30 minutes to produce a new time in a new column - Please advise?
0
votes
1answer
53 views

Calcualted column formual "=TEXT(NOW(),"mm/dd/yyyy")-[Last Update]" will show 44,055 if the [Last Update] column is empty

I am working on an online SharePoint site, and I created a calculated column with the following formula:- =TEXT(NOW(),"mm/dd/yyyy")-[Last Update] now the formula is working well if the [...
1
vote
2answers
333 views

How do I create a calculated column that displays Yes or No if ANY other columns in the row have the value "Yes"?

I have a series of 3 Choice columns that are populated by a MS Form to be either "Yes" or "No". I am wanting Column4 to show Yes if ANY of the columns 1 2 or 3 contain the value &...
1
vote
2answers
2k views

Calculated columns cannot contain volatile functions like Today and Me

I am working on a custom list inside a SharePoint online site collection. and i have a custom column named "Last Update" of type DateTime, and i want to create a calculated column to show ...
0
votes
2answers
34 views

SharePoint Date Flow

I have a list that has a CurrentDate column. With no more SharePoint Designer, where someone once helped me build code for this; as I'm really not very good at any of this to begin with), how can I ...
1
vote
2answers
78 views

Calculated column formula not working when referring to a Yes/No type column?

I am working on a SharePoint list validation to automate some process. I have Column A which is a Yes/No type column and I have Column B which is a calculated column that will take input from column A....
0
votes
5answers
58 views

Sharepoint Calculated Compliance Column

I have an SharePoint list with columns: Title (Single Line Text column) DteofAwrd and CurrentDte (both date columns) ComplianceStatus (calculated column) I am using the below to determine compliance ...
0
votes
2answers
40 views

Sharepoint calculated column IF function - Syntax error

No matter which syntax i use, sharepoint throws me a syntax error on IF function. here is what i have tried so far = IF ( [colA] = "dddd"; "yes" ; "no" ) = IF ( [nr1] <...
0
votes
2answers
39 views

Sharepoint list have german date convert into Monthnumber

I have a German client sahrepoint list and I want to convert month from date column in number. Like Month and Year in German: Want to Extract Month and year in separate column for further calculation ...
1
vote
1answer
61 views

Calculated Date Difference Question

Before submitting this question, I've tried researching this in the forums and have attempted multiple variations of suggested formulas with no success. So apologies in advance for asking what seems ...
0
votes
1answer
94 views

Nested IF Statement in SP List Calculated Column

I need to create a Nested If statement based on several columns. Column 1. CurrentDate (Date) Column 2. DteofCQ (Date) Column 3. CQTitle (Text) Column 4. ComplianceStatus (Calculated) There are 8 ...
1
vote
1answer
103 views

Calculated Column - Days Difference - Syntax Error

I have a SharePoint List and I'd like to have a column to calculate the days it take to solve a ticket (Solution date - Submission Date). I tried to create a calculated column, by using a formula = ...
1
vote
2answers
140 views

Multiple IFS in Sharepoiint Calculated columns

I am trying to write a formula in a calculated column that would populate shift hours base on shift name. The Shift title column is names "ERSShift". The different shifts available are "...
0
votes
1answer
122 views

calculated column missing in designer workflow dropdown

I have a calculated column in a list and I want to update that column value from SharePoint designer workflow but when I am trying to update the field in workflow, calculated column is not showing up ...
1
vote
1answer
41 views

Calculated column in SharePoint list - Conditional formula for finding difference

I am working on creating a leave tracker list. For that, I have added a column for Leave Type with 4 choices with 1 choice being company off. I want to add another column that says => Comp offs ...
1
vote
2answers
109 views

Adding days on calculated column from monday to friday

I need to add a calculated column in SharePoint where I have to add +1 day from Monday to Thursday and +3 on Friday but I don't know how to do it. I did some tests with WEEKDAY without success.
2
votes
2answers
230 views

Calculated Column: Prevent date from changing - SharePoint 2013 online

Need some help please - currently working on SharePoint 2013 online. I have a choice column (drop down) called 'Stage'. In 'Stage', I have 3 choices; Start Pause End I also have 3 calculated columns ...
0
votes
1answer
36 views

Add a calculated column with if statements

New in this forum. And I have a quick question: I have a choice column with this values: Kg Lb Ton And I would like to add a column that multiplies if I choose Kg or Lb or Ton and convert ...
0
votes
1answer
28 views

SharePoint time difference in minutes - wrong result

I created a simple SharePoint list and I am having problem with a calculated field. I have a "Duration" field that calculates the minutes between the start and end date/time columns, using the formula:...
0
votes
1answer
36 views

Populate Sharepoint column with the dates of the next 3 Thursdays

I am trying to setup a list that captures signups for a weekly meeting that happens on Thursdays. For each Thursday, there can be up to 4 people signed up on the meeting agenda. I was hoping to find a ...
1
vote
1answer
23 views

Issues with calculated field syntax

Our school district uses O365 Sharepoint in the cloud. I've been tasked with creating a calendar in Sharepoint for all users for conference rooms reservations. I have NO experience with Sharepoint. ...
0
votes
1answer
63 views

Sharepoint list with calculated column - formula IF does not work

Working on a SharePoint list with a calculated column with a date, which I want to make dependent on priority (column is called Prioriteit), and date of creation (Datum melding). I made this formula ...
0
votes
2answers
169 views

extract "all" numerics from text string

I have a Sharepoint Online list with a text field for a contact called Mobile Phone... I want to extract the numerics only... (111) 222-3333 would be 1112223333 +99 111-222-3333 would be 991112223333 ...
0
votes
1answer
158 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
27 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
2answers
52 views

How to have validation for calculated column

I am working on a calculated column that take value from other two different columns. The formula is as this: =IF([Detect-Rental/Lease]=1,IF([Detect-Rental/Lease Taxonomy]="Yes",TRUE,FALSE),TRUE) ...
1
vote
1answer
117 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
0answers
30 views

Need more if statments in calculated column

I have a problem with calculated formula, this take the information from a choice column. The problem is that i have 23 choices, and the calculated column only permit 20. When i add the 21 if, it ...
1
vote
2answers
877 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","...
0
votes
0answers
21 views

Sharepoint 2013 Auto Increment Column

I've read a bunch of articles on how to do this, but I haven't succeeded in making this work. So I have SP Designer 2013, but due to my Gov. restrictions, I can only utilize 2010 workflows. I'd like ...
1
vote
2answers
218 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
129 views

What is the formula to calculate working days between two dates with Fridays & Saturdays as weekend!

What is the formula to calculate working days between two dates on lists SharePoint? Keeping in mind that the working week here in Dubai is Sunday to Thursday - Fridays and Saturdays are the weekend. ...
1
vote
1answer
143 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 ...
1
vote
1answer
16 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
32 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 ...
1
vote
1answer
41 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
46 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 ...
1
vote
3answers
108 views

SharePoint 2013 Description does not show for calculated fields

I have added descriptions to calculated fields in a SharePoint 2013 list, but am unable to make them display in the form like other column descriptions. How can I add these to be visible to my users?
0
votes
2answers
56 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 ...
0
votes
2answers
82 views

Calculated Date Column with Nested IF statements

I am trying to calculate a Date based on two different columns in a SharePoint List: RANK column and PEBD column. Essentially, I need to do the following: IF RANK is E1, then the value of the ...
0
votes
1answer
96 views

Calculated column for date difference taking into account weekends and negatives (Errors #NUM! and #Name?)

I've been fighting this and going around in circles, hopefully someone will be able to help me out. Issue: I am trying to create a calculated column (Text) that compares today's date "Now()" with a ...
0
votes
3answers
850 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
1
vote
1answer
512 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
113 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
0answers
15 views

Calculated Formula to auto populate next PO# available when only one specific choice is selected from another column

I would like a calculated formula for the following: I have a column with a dropdown that will list Vendors to choose from. Only one of the Vendors needs a PO#. I'd like a column to auto calculate the ...
1
vote
3answers
31 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 ...
1
vote
0answers
29 views

Need help counting number of error types for employees

I have a SharePoint list that captures employee details and the error types they have committed. In the same list, I would like a column to auto-capture the number of instances of each error type when ...
2
votes
2answers
139 views

SPO: Create Hyperlink from Calculated Column

I know there are several questions/answers for this, but I still can't seem to get it to work. Name - Text URL - Text Link - Calculated Column Number Link column =CONCATENATE("<a href='",URL,"'...

1 2 3
4
5
23