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

2
votes
2answers
67 views

Show image based on calculated column value

Why does SharePoint not understand to change the image when I use If statements? Specifically when I use it on a calculated culumn. Building a status (project/risk) page and I use Probabiliy and ...
0
votes
1answer
32 views

Can someone spot the error please

I am trying ti create a calculated column where it will add the vale "has been completed" if the approval column is approved. Below are the code and screenshot of the error. Thank you =IF([...
0
votes
1answer
135 views

How to add an image in a calculated list column

I want to use and image instead of a text in a field. see this image The edit column its a calculated column. If users click on it. It will opens the editform.aspx. So i want to use an image instead ...
0
votes
3answers
58 views

Nested IF to Calculate Complete or Incomplete

I have several columns on a list that are radio buttons for either "Completed" or "Not Applicable". I need to draw the status of an item based on if those columns have data in them. Someone may choose ...
2
votes
2answers
118 views

Replace second “?” with Calculated Column

The string below contains two "?" what calculated column formula should I use to replace the second "?" with "&" but not remove the "?" from other strings that have only one "?" Could anyone ...
11
votes
3answers
2k views

Sharepoint calculated column shows year with comma

I am new to SharePoint and I am trying to display year with the help of calculated column. However, the resulting year is displaying with comma i.e. 2,016 instead of 2016. Is there any easy way of ...
0
votes
2answers
438 views

how to create history column?

I have implemented a document library in which a person assign a document to review to a responsible person. He assigns it selecting his name from the Responsible column. Then an email goes to that ...
3
votes
2answers
280 views

Can someone spot an calculated column error Please?

I am trying to create a calculated column where 'Today Date' is another date column. The first two block are working fine till the [Enter time]=2 condition when I add other two it says syntax error. ...
1
vote
1answer
82 views

Syntax problem in calculated field

I am trying to create a calculated field where I am trying to add Today date Column and 365 days. I think I applied wrong syntax. The text [Today Date]+365 shown as it is in column entry.
1
vote
1answer
361 views

Calculated Field with formula DATEDIF + dispay text

I have created a CustomList called BirthdayReminder and also set up a Site-workflow which runs everyday at 00:00 to update the fields - otherwise the Birthday Reminder will stay static. My aim is ...
0
votes
2answers
134 views

Custom Calculated Column to sort dates based on entry date

**Edit: Hi, I know it has been a while since this was answered but I am having some issues with this formula. Since the start of the year it is giving me two different week numbers for each week. This ...
0
votes
1answer
38 views

In a calculated column, how can search find capitalized words?

I am setting up a calendar for notification of professional development events (taking the place of group emails). In my calendar, I set up a calculated column to search the Summary column for ...
1
vote
1answer
521 views

Calculating Dates Excluding Weekends

I am creating some scheduling of dates for a task in SharePoint Online. The user enters the first date and a number of days it will take to complete the work. I have created a calculated column which ...
0
votes
1answer
66 views

SharePoint 2010 - Calculated Columns

I am hoping to get some help with this scenario: IF Date Intake Decision Documented exists THEN (Date Intake Decision Documented – Date Opened) IF ≤ 21 days THEN Yes ...
0
votes
1answer
2k views

Calculated Column Extracting Date Only in Date and Time Column Type

Intent: To create a calculated column that shows the date ONLY from date and time column type. I created a formula, but it is wrong and not sure where I am going wrong. Can anyone help? Note: I ...
0
votes
2answers
717 views

Calculated Column: change date format issue for all day events

I discovered an strange behavior when I try to display a date/time in an other format within an calculated column. The formula of the calculated column is: =TEXT([End Time],"dd‑mmm‑yy") this ...
0
votes
1answer
144 views

Retrieve lookup values in a formula

I need to get lookup values, but i cannot use SharePoint Designer. I tried to use the solution proposed there, but it does not work with document libraries. It raises an error: "Unable to get ...
0
votes
1answer
32 views

Item being delayed from view

So I have a field in one of my SharePoint lists that shows a program status (shown below): This field is a drop down list but I want to set a rule that if this field changes to cancelled (which is a ...
1
vote
2answers
243 views

Formula to check if a column has one of two values and LEN=9

I'm trying to work out a formula to check if a column has CIP or GEN as the first three characters, followed by 7 numerals. I have a formula to check for CA1234567. =(LEN([Order Number])=9)+(LEFT([...
0
votes
1answer
227 views

Calculated Column to determine another column

I am trying to create a column that calculates a column's status based on date. I currently have =IF([Start Date & Time] - [today's date]7, Major, Minor) However, for whatever reason SharePoint ...
0
votes
2answers
598 views

Issue With Calculated DateTime Field

I created Two Calculated Fields : The First Formula of Calculated Field =TEXT([Created];"mmmm") the Result is : First spring (Name Of Hejri Month in Hijri Format Arabic ) The First Formula of ...
2
votes
1answer
63 views

lookup column added calculated column formula

I created a list of date where my team members can meet. It is a lookup column. Now I have to write a formula with this lookup column in a new column called formula1. For example "=NOT([Due Date]=0)"...
1
vote
2answers
59 views

Formula for calculated column

The question is:- If an employee is willing for an increment and his experience is more than 2 years, then the increment rewarded should be 10% of the current CTC(Cost to Company). For this, I wrote ...
1
vote
2answers
58 views

Calculated column formula that always adds 1 to new item in List

What formula I can use in a column so the value in the field always increases by 1 every time a new item is created?
0
votes
1answer
142 views

SP2013: Calculated column returns 0 instead of “” when list items change

I've got a simple list with 3 columns; Employee Name, Status, and a calculated field. Status column is a dropdown choice between "Active" & "Inactive" Calc field formula is: =IF(Status="Active",[...
1
vote
1answer
85 views

Calculated Value Changing when issue tracking list has been resolved

*Hope someone can help me with this issue. I am currently using the following formula to calculate a number of hours a ticket has taken to complete. =IF(Completed="","",INT(((Completed-Created)*...
0
votes
1answer
83 views

Calculated Value - Date time problem

The formula contains a syntax error or is not supported. I get this error and I tried this formulas: =TEXT([LeavingTime]-[ArrivingTime],"h") =DATEDIF([ArrivingTime], [LeavingTime],"d") where ...
0
votes
3answers
161 views

Conditional Formatting to apply color to indicate progression towards a numeric target

I'm wondering if anyone can help me with a calculate column/JS Link formula. I have a monthly performance indicator which is a count of the number of inspections I perform. There is a target number ...
4
votes
4answers
555 views

How do I create a calculated conditional column using today's date, and automatically update each field daily?

I have created the following list (Timeframe) in SharePoint; Timeframe Start Date End Date Another column, [Is Current Timeframe], needs to be created that specifying whether or not the Timeframe ...
1
vote
2answers
64 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 ...
3
votes
2answers
9k views

if and else if in calculated field

I have a column in SP called Pursuit status that contains various states a proposal can be in. For a diffrent project I need to lump them into 3 buckets (win - loss - pending) The fields below are: ...
0
votes
2answers
83 views

Calculated Field - Open/Today Until Closed

I have seen a few tickets with this general solution, but I have a thought about how this would work and how I would like it to update and need some input on how to make it work. I have a trouble ...
1
vote
1answer
45 views

SharePoint Date Formula

Let's say you have a date formatted as 31/Dec/16 but wanted to calculate two cells over to show 201612. How would I put in this formula because excel and sharepoint do not have it already formatted in ...
0
votes
1answer
21 views

Calculating field if it's empty

I have a calculated field containing "RemainingWork". The calculation in this field is based on two other fields, "Estimate" and "RegisteredHours". If "RemainingWork" has not been set, it's supposed ...
0
votes
2answers
494 views

Setting Field Formula Programmatically

I have a field formula which is working as intended which I've set in my list settings for the respective list. Now, my question is if it's possible to set this formula programmatically somewhere so ...
1
vote
1answer
233 views

Calculated column - Find Multiple Spaces

A SharePoint list contatins three columns, Requestor name (Single Line of Text) First name (Calculated column) Last Name (Calculated column) I want to extract First Name and Last Name from the ...
0
votes
0answers
70 views

Show Conditional calculation output of Column 1 & 2 in Column 3 in SharePoint 2013 List

I`m working on how to get the output of the filtered total value in Column1 and Column 2 and show it in Column 3. Example for better understanding - **Column 1 Column 2 Column 3 (...
1
vote
1answer
130 views

How to calculate Nth business date using Calculated column?

Find the Nth business day from today. Here, I need to find the 13th business day from today using calculated column of SharePoint. I want to exclude Saturday and Sunday because I only need 13 ...
2
votes
3answers
3k views

Javascript Functions in Calculated column

I am trying to use javascript functions within an calculated column which is working pretty fine e.g. if I use the following formula: ="<img src='/_layouts/images/blank.gif' onload=""{" &" ...
1
vote
3answers
921 views

Calculate the total of column using calculated column

Is it possible to get the total count of items within a column on another column in the same list using calculated column formula? I researched a lot cant find any calculated column formula that ...
0
votes
3answers
91 views

How to make a KPI appear next to a value in a column

I am trying to work my way around, adding KPIs next to a desired value. I have tried this so far by using this in the calculated column formula field <img src=" "/_Layouts/images/kpidefault-" &...
1
vote
2answers
102 views

Another SharePoint query regarding calculation

Sorry I just need abit of help understanding this: I have column W, X, Y, Z. W is Dates X is Rota Y is Yes or No Z needs to be something, for example: If X is Rota1 and Y is Yes, then Z will be 1....
0
votes
2answers
114 views

SharePoint calculation query

I have a column in my list that states a date, we can refer to that column as X. I need some help, I want to make a column that would show the quarters based on column X For eg January-March is ...
1
vote
1answer
42 views

Calculated Formula to mirror status

I have created a custom list with a dropdown field called Project Status with the following options Unassigned Work in Progress Hold Dropped Completed I have also created another hidden field ...
2
votes
2answers
2k 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
5answers
4k views

IF statements in Calculated List Column always returns “The formula contains a syntax error or is not supported”

No matter how simple I make my formula I always get an error when I try to save a new calculated column with an IF statement in it. For example: =IF("Foobar"="Foobar", "Foo", "Bar") On save I get "...
1
vote
2answers
371 views

How to display text rather than a number in a Calculated Field?

I have a List containing a Calculated Field, "Risk Priority", which is calculated using the formula: =IF( ISBLANK([Internal Control Score]) ,Impact*Probability ,Impact*Probability*[Internal ...
1
vote
2answers
51 views

Calculating Project End Date

In the project I'm working on I have created a column called Project Delivery Start Date and a column called Delivery Days. I want to use the start date and delivery days to create the Project ...
0
votes
1answer
252 views

Hiding the top line (control) in a repeating table using InfoPath

I have set up a Data Connection to retrieve the data from a list (such as Time, Price, etc..) I have created a repeating table to have this section in each line. I was using a Formatting to hide the ...
0
votes
2answers
23 views

2013 Calculating a column from 2 existing yes/No columns - FAILS SharePoint bug?

Here is the requirement: Col1 (Employee is PM?) Col2 (Employee works at HQ?) Col3 (Calculated Value) Formula: If both Col1 AND Col2 = "No", than Col3="No", Else Col3="Yes" This SHOULD WORK: =IF(...