Questions tagged [calculated-column-formula]

Question related to the Calculated Column

Filter by
Sorted by
Tagged with
1
vote
1answer
431 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
214 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
190 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
2answers
94 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
2answers
116 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
1answer
989 views

Calculated formulas for tracking progress

I would like to let my team know if their document is progressing on track. I have a start date and due date and a column that they must enter their progress %. In a tracking column I would like to ...
0
votes
2answers
401 views

Joining Lists using Calculated Columns

I have two lists, a parent list and a child list, which I wish to join by ID. the end result is that I wish to pull information from the parent list across to the child list according to this common ...
3
votes
1answer
727 views

How to have a calculate column that compares the difference between the current item and the previously submitted item?

I have a list with the columns Room Number, Temperature, and a column Temperature Change. What I would like, is for Temperature Change to be a calculated like so: When the user fills out a new ...
3
votes
1answer
4k views

Sum Calculated Column (SP 2013)

There is a very nice solution below from ViewMaster (http://www.viewmaster365.com/#/Create/Sum) that involves some scripting within the formula of a calculated column itself. However, the Sum will be ...
1
vote
1answer
220 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
32 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
303 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 ...
0
votes
2answers
157 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
320 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
3answers
5k 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
1answer
718 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 ...
2
votes
1answer
252 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="$...
1
vote
1answer
54 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
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
251 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 ...
3
votes
1answer
680 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
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(...
2
votes
2answers
139 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
111 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
651 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%...
0
votes
1answer
115 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
2answers
307 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
787 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, ...
1
vote
0answers
150 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
46 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 ...
1
vote
1answer
273 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) ...
1
vote
0answers
74 views

Calculated column based on specific elements from another site column

I have this site column in a Sharepoint 2013 list showing a few deadlines. I need to create a calculated column next to the one in the picture, that gives as a result the number of days between one ...
0
votes
2answers
296 views

Calculated column looses brackets

I have a strange problem with my calculated column. I want to build a link utilizing the ID of the entry. So I have a formula like this: ="<a href='someurl.html?id="&[ID]&"'>some text&...
0
votes
1answer
457 views

Totaling Three Columns for a Balance Column in a SharePoint 2013 List

Newish to SharePoint so, hopefully, I am explaining this clearly. I want to build a simple Timesheet List where I have the following columns: Employee Name (Choice column, drop down of employee ...
2
votes
0answers
34 views

Calulated column displays html markup sharepoint 2013 [duplicate]

I am experiencing an issue with a calculated column that presently returns html markup for the purpose of KPI in sharepoint 2013. It was working well, all of a sudden it started displaying the raw ...
2
votes
1answer
624 views

JavaScript Code in the SharePoint 2013 calculated column

I added the code below to a SharePoint calculated column in order to get today's date, and it works well, however, I will need to add another calculated column to get the date difference between "...
1
vote
1answer
246 views

CountIF statement in SharePoint

I am trying to make something like a CountIF statement in SharePoint for the purpose of counting specific choices made in a drop down category for a calendar event. Currently, when I make a new ...
0
votes
2answers
1k views

SharePoint 2013 calculated column adding multiple if statement

i created a calculated column(column name"status") with a simple formula below: =if([Priority]="Low"), "Yellow", if([Priority]="Normal"),"Green", if([Priority]="High", ”Red"))) As you can see, what ...
1
vote
1answer
283 views

Help with SharePoint Calculated Field Multiple Values

I have the following formula on a calculated field that searches the value funnel status for values, then sets as live or active. Rather than search does the field contain a specific value, I would ...
4
votes
2answers
105 views

SharePoint Calculated Column

Im no expert but I seem to be struggling with this. I have a calculated column field called [Review Days] for which I hope to enter an amount of days that a document will need reviewing. 1 year will ...
13
votes
1answer
779 views

Save Calculated Column Formula in Language Localized notation using REST or JSOM?

[multiple blogs/posts out there noted the issue, no solution was ever published] What is required to save a Localized Calculated Column Formula using JSOM/REST? I am injecting the script below into ...
1
vote
1answer
85 views

SharePoint 2013 filter based on created date

I am struggling to construct a SharePoint formula in which I want to show items within 14 days from created date. i.e. between created and created+14<=Today.