Stack Exchange Network

Stack Exchange network consists of 175 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

Visit Stack Exchange

Questions tagged [calculated-column-formula]

Question related to the Calculated Column

1
vote
2answers
465 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
62 views

How do i get a choice column to change from YES to NO depending on another column using calculated columns

I'm trying to uses nested ifs to change what a choice column displays but I'm not sure if this can be done or if I'm doing it properly. What I'm trying to have accrue is once the next review date ...
1
vote
1answer
142 views

Perform a calculation based on other criteria

sorry in advance supernoob here failing hard and need help. I'm trying to create a timesheet in sharepoint that will eventually be a powerapp then go into PowerBI and I'm struggling bad with the ...
1
vote
2answers
361 views

Extract data from meta data field and copy to new field

I have a managed term set which provides date meta data for a column used by accounts. They tag a document depending on the period (month and year) it relates to. What I wish to achieve is to have a ...
0
votes
1answer
38 views

Attempting to get one out of four possible status based on due date

I have a SharePoint list and the three columns I am working with are Status (shows either complete or not complete), Due Date (shows when an item is due) and a new column (this is the calculated ...
1
vote
1answer
29 views

Getting Sharepoint to calculate columns and render them as a | delimited

This a great online community! I am trying to get columns to calculate and then display the calculated value in delimited format. Example is [COLUMN 1]+[COLUMN 2]+[COLUMN 3] The calculated result I ...
0
votes
1answer
97 views

Calculated field on List View

I've set up a Calculated field up on a view with the following formula: =ID+800 At first it's fine. It shows incremental numbers (1001, 1002 etc) but after around two items are added or the view is ...
1
vote
1answer
1k views

Calculating Week Number in calculated field

I'm trying to calculate the week number based on a fiscal year starting on November 1st with moderate success. Current formula: =INT(([Project Start Date]-DATE(YEAR([Project Start Date]-WEEKDAY([...
1
vote
1answer
768 views

Creating KPI Status Indicators with Calculated Column

I am trying to use calculated columns to have a possibility of 3 status indicators come up based on another column that is called projectstartday which shows how many days are left until a project ...
2
votes
3answers
469 views

trouble with calculated field

I am experiencing a couple of problems with calculated field in document library. Problem one: Calculated field gives me this error: The formula refers to a column that does not exist. Check the ...
4
votes
4answers
1k views

What is the workaround for limit in nested if statements in sharepoint calculated column?

I have to create a list wherein when user inputs a data to a column the corresponding calculated column should take the data and analyze the condition and then return the value, but my SharePoint ...
0
votes
1answer
41 views

Calculating column using formula based on four selection boxes

I have a Sharepoint (2010) list, where I have a column that's supposed to be calculated based on four previous columns. Each of these columns are selection box columns, each with three options, and ...
1
vote
1answer
414 views

Calculate Yearly Quarter

Trying to create a column that will determine the financial quarter that a date field currently represents. The 1st quarter should always begin on November 1st. Current formula: =IF(ISBLANK([Actual ...
1
vote
0answers
213 views

Sharepoint Calendar View Filter - Show items in current year

I have events on my calendar that have Start Time dates in 2016, 2017, and 2018. I have a calculated formula on my Calendar list named Year Calculated Event - Current. The formula is =YEAR([Start ...
3
votes
1answer
181 views

Calculate Hours Worked Per Week

I'm currently using two lists, one stores tasks [Task List], the other stores the hours worked for completed tasks [Time Sheet List] When a user marks a task as complete, it creates a corresponding ...
1
vote
1answer
209 views

Add/Subtract amounts from column in one list to “cell” in another list

I am trying to build two lists to keep track of our purchase orders we have. My two lists looks like this: List 1: PO +-----------+-----------+-------------+ | PO | Amount | Used/Left |...
0
votes
1answer
31 views

Fill the date field if you have value of other filed

I have sharepoint 2013 I have list with two columns. First column is STATUS (choice type = not startet, in progression, finish) Second column is FINISH_DATE (date type). I need automatic fill. When ...
3
votes
3answers
296 views

Is there a way to calculate the number days between two list items in a list?

I have an InfoPath library/list in SPO. I need to calculate the number of days between two different list items. It's to show the number of days since the last work event. Is there an easy way to ...
1
vote
2answers
114 views

Is it possible tpo use the excel weeksum function in SharePoint to return the week number from a date column?

I am new to SharePoint and I know that in Excel you can use the WEEKSUM function to return the week number from a date column. Is it possible to do the same in SharePoint 2013? If so how can this be ...
0
votes
2answers
152 views

Sorry, something went wrong The formula contains a syntax error or is not supported

=<a href=""https://www.google.co.in"" target=""_blank""><button>Edit</button></a> Could you help me out with the error in here? it says " Sorry, something went wrong The ...
1
vote
1answer
288 views

Column validation with multiple arguments

I have two columns that wish to validate on. Column A is a number field and Column B is a choice (drop-down) field. I wish to restrict the options that can be selected in Column B if the number ...
1
vote
2answers
90 views

Calculated Column - Looking for highest column value per column

Not sure if this is possible and am hardly a novice with any coding, but here it goes. I'm trying to get the highest item value on specific columns that will be fluctuating over time. I'm not ...
1
vote
3answers
4k views

Calculated field formula to create an incremental number

Hoping this will be easy. I'm starting at 900 at need a field to go up one when an item is added to a list. Is there a simple formula to achieve this? Thanks in advance
1
vote
0answers
25 views

Multiple Content Types Duplicating Values in Calculated Column when updating CT

List Setup I have a list setup with 3 content types. Content Type A, Content Type B, Content Type C The list has 3 choice columns setup for each content type. This enables the choices available to ...
0
votes
3answers
304 views

Getting error when creating calculated columns

I am trying create a simple calculated column, but I am getting an error: The formula contains a syntax error or is not supported The formula looks like: =DATE(YEAR([RevisjonsDato])+1,MONTH([...
0
votes
1answer
688 views

Update date calculated column depending of date

I have calculated in a list column who compare dates and return yes or no Formula: =TODAY()<[Fieldone] So it returns yes or no correctly, problem is when conditioning of date changes because ...
1
vote
1answer
53 views

Calculated field based on list

I have a list where the user can add new items. I would like to generate an ID based on who creates the item. For example if Person A is the creator, then her ID="10000 + number of items she ...
2
votes
1answer
248 views

how to create a calculated fields programmatically

I need to create a calculated item , which has: the ID of the item, the created date and title. How to do this combination in xml. i tried this code : <Field Type="Calculated" DisplayName="$...
2
votes
1answer
51 views

SharePoint Absolute Reference - Fixed Value in Calculated Field

I'm looking for a way to get the absolute reference of a specific "cells" in a SharePoint calculated column ? For example I got this SharePoint list: A1 - B1 - C1 A2 - B2 - C2 My calculated field ...
0
votes
1answer
238 views

Find minimum and maximum dates based on column

I have a list with multiple Tasks, each Task is grouped in a Category. Every Task also has a Task Start and Task End Date. I would like to make a calculated column for the Category Start and Category ...
0
votes
2answers
1k views

Referencing Choice Field in Calculated Columns

I have a question regarding Calculated Columns. I have a Column Called "NextMileStone", this column can contain "PM010", "PM020, "PM040", "PM070", or some other choices that would be the "else" ...
2
votes
0answers
65 views

Subtracting work days not working

I tried a formula for subtracting 3 working day, I found googling and a piece of it does not work for me. I found this: =IF(WEEKDAY(DATE(YEAR(RStartDate),MONTH(RStartDate),DAY(RStartDate)-3),2)=6,DATE(...
3
votes
1answer
640 views

Calculated Column checking against a multi-selection lookup

FieldA is a lookup (to another SP list) with the option to select more than one choice from 9 options: let's call them 1 thru 9. FieldB needs to be a calculated field that evaluates FieldA. Certain ...
2
votes
2answers
130 views

Calculated columns formula today not update (SP 2010)

Created a field with the formula Today + 2 days, checked the next day, the date is old, i.e. in which this column was created, I need the date to be updated every day, how to implement it?
0
votes
1answer
30 views

Need help using a calculated column while factoring 3 different columns of data

I'm putting together a list to break down stress tests ran on various systems in our department. Without getting into unnecessary details, we conduct random tests using (3) measures that produce (4) ...
1
vote
1answer
108 views

Calculated Date [Sharepoint Online]

Currently having an issue with a calculated date column when the field is not filled in. Displays the date as December 1899. Current formula is: =TEXT(YEAR([Closed Date]),"00")&"-"&TEXT(...
1
vote
1answer
43 views

How to create column with other column's data?

I want to create a column by using the other column's data. For example : There are Modified Date , Modified By , Name columns. I want to create a new column by using Modified Date. If Modified ...
3
votes
1answer
599 views

Correctly url path?

I upload photos into my sharepoint online into assets folder, when I go to that folder navigator bar shows: https://mybusiness.sharepoint.com/siteassets/Forms/AllItems.aspx?id=%2FSiteAssets%myFolder%...
1
vote
2answers
283 views

Calculate Column = Multiple Columns that could be empty

I have a calculated column that is set to the concatenation of several columns that could be empty...I have tried a few different options, but I keep getting an error. Help would be greatly ...
1
vote
0answers
38 views

Sharepoint 2013 Form validation - I have 4 date fields I want to validate on. The first 2 are compulsory second 2 can be blank or filled in

I am having dificulty getting my validation formular to work. Field Names: DateAdded (first date) Expectedleave (second date) these are compulsory and the Expectedleave must be equal to or greater ...
1
vote
1answer
751 views

Wrapping ISDATE calculated column with IFERROR (Sharepoint Online)

Currently, have a calculated column that calculates the difference in days between 2 date columns. =DATEDIF([Issue Date],[Due Date],"d") When there is no value entered or an incorrect value entered, ...
0
votes
1answer
110 views

Calculated Column's Search Function and Arrays

I've been attempting to find the location of the first non-zero in a string, where the string does not begin with any numbers. An example of one such string is ABC0*0# where the asterisks (*) ...
1
vote
0answers
146 views

Calculated Column formula not working correctly on refresh

I have a List in SharePoint 2010 which contains a list of Vendors. The List has three columns: Vendor, Inactive, and SortVendor. SortVendor is a calculated column with the formula: =IF(ISNULL(...
0
votes
1answer
25 views

Calculated column not working in SharePoint 2007 list

In a nutshell, I have two columns; the standard [Modified] and [ACTION_DATE]. I'm using this formula =IF([Status]="New","","[Modified]") in the ACTION_DATE column to populate it with the last ...
1
vote
0answers
49 views

Calculated Column based on multiple other columns that may not exist

Is it possible to create a Calculated Column based on other columns that may not exist? Here is the hypothetical scenario. We have a Term Set such as the following: * Animals * Mammals * ...
0
votes
1answer
45 views

Calculated Column - extract only letters

I have a calculated column [lastname] with the following formula: =RIGHT([Staff Name],LEN([Staff Name])-INT(FIND(" ",[Staff Name]))) [Staff Name] is generated by SharePoint Designer (from another ...
3
votes
1answer
1k views

SharePoint 2013 - Color Code Text in a Column

How would I color code text in a column when an overdue date threshold is reached? I created a calculated column (# days overdue) that shows total number of days the item has been open. When the # ...
1
vote
1answer
253 views

Nested if calculated column, checks for 3 columns if blank to update a status

I have this formula that does not work, really stumped. I've worked through this several times and just can't quite get it. =IF(ISNUMBER(Find("4",Priority)),"Deferred",(IF(ISBLANK([Close Date]),(IF(...
0
votes
1answer
18 views

If-$/true=$ - assistance needed with field formula

I am tracking a list on sharepoint and want to use this to reconcile the invoice. I have a field named "Appraisal Type" that has two choices. If one of them is chosen (MVProRE Exterior)I want ...
3
votes
1answer
65 views

Yes No calculated field for closed/created in last 7 days and items open or in-progress

I would like to create a calculated field that outputs "Yes" or "No" if an item in my SharePoint list has been created in the last 7 days, closed in the last 7 days (field in status column), or 3) ...