The Stack Overflow podcast is back! Listen to an interview with our new CEO.

Questions tagged [calculated-column-formula]

Question related to the Calculated Column

124 questions with no upvoted or accepted answers
Filter by
Sorted by
Tagged with
6
votes
0answers
97 views

Formula in spreadsheet being converted to a custom list

I am currently trying to take an existing spreadsheet and replicate this as a SharePoint list. The spreadsheet contains the following columns: Received - This will be a number column with 0 decimal ...
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([...
3
votes
3answers
329 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 ...
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) ...
3
votes
0answers
102 views

SharePoint Conditional Validation / Formula

In SharePoint Online can i perform the following? I have a column to calculate the date difference between Last Visit Date and Next Visit Date. Last Visit Date is already provided, and users will ...
3
votes
0answers
6k views

Calculated column formula for not equal

Hi can I use the <> operator in a SharePoint Calculated column? The following formula is accepted but I'm not sure it is supported. My requirement is: If any values equal High AND are not ...
3
votes
0answers
612 views

Sharepoint 2010 Nested If Limit

In SharePoint 2007 the limit for the number of nested IF statements was 7. On the 8th SharePoint would return and error. On my 2010 site I made an error and added 8 nested IF statements and there was ...
2
votes
2answers
65 views

Calculated column displaying “#Name?”

I'm trying to display KPIs that show how long a list item spend in each status. Column name = Time In 5. =IF(OR(ISBLANK([Date entered 6. ]),ISBLANK([Date Entered 5. ])),"No KPI dates",DATEDIF([Date ...
2
votes
1answer
56 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 ...
2
votes
0answers
67 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
122 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 ...
2
votes
2answers
74 views

Calculate time including IF column value

I have the basic time value formula, but I am having two problems; The first is with this Total Comp Time formula: =TEXT([Start Time]-[End Time],"h:mm") It does display the difference in time as ...
2
votes
1answer
721 views

How to use a lookup column's additional field in a workflow?

Background I have two lists. One is a list of voltages and their corresponding costs. This is to be used as a lookup for other lists. Voltage Cost 120 2.50 240 ...
2
votes
2answers
70 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 ...
1
vote
2answers
28 views

=IF(DATE(YEAR([Compliance Date]),MONTH([Compliance Date])+11,DAY([Compliance Date])), “Due”, “Not Due”)

I am trying to create an If statement that looks at a date column in sharepoint and if its 11months after that date the column displays yes. any help on this as: =IF(DATE(YEAR([Compliance Date]),...
1
vote
0answers
30 views

Getting “#NAME” from SharePoint Survey calculated column

In the results for a Survey done in SharePoint 2013 (survey list - type that I'm "inheriting", if you know what I mean). I noticed we're getting "#NAME" in some of the areas we're pulling down. ...
1
vote
2answers
32 views

How to sort column fields and get its total

Dear SharePoint Experts, I would like to ask for tech support regarding on the screenshot that I attached. As you can see from the image, I have a My Requests, All Items, My Balance views, in My ...
1
vote
0answers
33 views

Need to count entries

I am looking to make it so that each item in a list has a column that shows how many total items there are in that list that share the same value in a column as that list item. If that makes sense. To ...
1
vote
1answer
68 views

Calculated column between two date fields but if one is blank use another date field

I would like a calculation that gives the number of days between 2 dates (start date & end date) but if end date is blank I would like it to use todays date. How can I set this formula up?
1
vote
2answers
524 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
75 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
166 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
0answers
219 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 ...
1
vote
1answer
256 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 |...
1
vote
2answers
124 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 ...
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 ...
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
0answers
155 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(...
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 * ...
1
vote
0answers
75 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 ...
1
vote
1answer
691 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 ...
1
vote
0answers
74 views

Submitting and emailing an InfoPath quiz

I need the Submit button to email the quiz results and also submit the results to SharePoint. I first used a rule button and created 2 rules, 1 to email and 1 to submit the form to SharePoint. It ...
1
vote
1answer
79 views

Formula syntax error

I'm trying to add more than one if's (also) statements inside a formula, but it is not working because of a syntax error. What I'm trying to do is if actual sign date column is less or equal to the ...
1
vote
2answers
59 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?
1
vote
1answer
89 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)*...
1
vote
0answers
65 views

Calculated column with custom ID

I have a list form which contains 3 fields: Company (choice field), NewID (lookup number field) and MyID (number field with min/max values 0000-9999). On NewID field lookup formula is set: =IF([...
1
vote
0answers
60 views

Calculated Column Requirements

KPI (Time) will be triggered from the 6 Milestone Expected Date fields (M1 Date Expected -> M6 Date Expected): If the date required of any of the milestone Expected Date field does is not greater ...
1
vote
1answer
206 views

Create calculated field in Visual Studio Community 2015

I need some help creating a calculated field which includes div styles in the formula. I created a list as part of a project in Visual Studio and now I'm creating all the necessary columns including ...
1
vote
1answer
275 views

Create Lookup + Calculated column

I've an issue on calculating lookup value from other list.. I have List called "Product". in that I have column name "ProductCode"(Single line text) and "Unit Price"(number with 2 decimal). I've ...
1
vote
2answers
817 views

SP2013 : Overriding Thumbnails column in PublishingImages library

I'm really stuck with this one, so if someone has a little time to help me on this... What i want : I have a pictures library in a site. It is even a PublishingImages library. a lot of my images are ...
1
vote
3answers
256 views

How to create formulas in share point - quality assessment

I'm new to this forum and just want some help on the basics. I want to create a Quality Assessment form and want to know how to create formulas that are not Yes or No answer. For example: Score ...
1
vote
0answers
31 views

how to enable the calculated value using power shell?

We want to enable the calculated value option for the Date field,add some formula in that text box. can any one help on this?
1
vote
0answers
44 views

Way to calculate a column based off of a another column after filter is set?

This is the example after I filtered on what I need to calculate. JPP: = 14681369 WC/Site Code:= 386746 Bill =$1,138 ANOTHER Invoice is JPP: = 15091824B WC/Site Code:= 386734 Bill =$21,874 ...
1
vote
0answers
110 views

How to filter lookup field by site name

I have a list like this: Title Site AAA Site1 BBB Site2 CCC Site2 which is referenced in a lookup column. Requirements are to filter in the lookup column only the items whose "Site" property is ...
1
vote
2answers
136 views

How to get the workflow task title in a calculated field in workflow tasks list?

I want to get the task title in a calcualted field to form a URL to custom approval page. Basically I tried =CONCATENATE("<a href=http://****/SitePages/ApprovalPage.aspx?WFTitle=",[Request ...
1
vote
0answers
107 views

; or , in calculated columns

The separator is related to the language settings. Rule of thumb: of the decimal separator is a . (dot) then the parameter separator is a , (comma) So most non-english languages have the , (comma) ...
1
vote
0answers
996 views

Calculated field with library folder name

I have a library (e-amil enabled) with e-mail with attachments and I need to make a calulated field using the e-mail subject. The problem is that the calculated field shows only when I drill down the ...
1
vote
1answer
72 views

How exactly does =[Me] work?

I've read that in 2010, using 'volatile columns', like [Me], isn't encouraged. Though this functionality is needed as a default value for a column separate of Created By or Modified By. However, when ...
1
vote
0answers
188 views

Calculated Fields and language packs

We are programmatically deploying a calculated field in a Sharepoint 2010 website using a site collection feature. Now we need to add localization support for a number of diff languages, so we had to ...
1
vote
1answer
64 views

calculated column IF OR

I'd like to create a calculated column that helps me segregate options based on a previously selected choice. The essential argument will be the following that if the user selects Alignment A then ...