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

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
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) ...
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 ...
2
votes
1answer
630 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 ...
1
vote
1answer
56 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
1answer
141 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
1answer
202 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
1answer
62 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 ...
1
vote
1answer
614 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
1answer
78 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
1answer
84 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
1answer
193 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
247 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
1answer
71 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 ...
0
votes
1answer
18 views

SharePoint Calculated Formula

I have 3 columns... "CEO" + "President" + "Vice President" The 3 columns are using Choice field YES or NO (I tried and could also use drop down column Yes/No). The CEO or President or VP will go to ...
0
votes
1answer
37 views

Pulling info from one of several columns

When documents are added to my library, one of 4 approval workflows runs based on the metadata entered on the item (if the document is for Sales, the Sales approval workflow runs, etc). I would like ...
0
votes
1answer
36 views

Title and date in a calculated column (SharePoint Online)

I need to create a calculated column with the value from the Title column and the date part from a Date & Time column, separated by a space and the date format like YYYY-MM-DD. Something like ...
0
votes
1answer
32 views

Complex calculated column in SharePoint

we have to create a calculated column from a string that can be of the form A01 (letter + 2 digit number) or it can be 2 letters plus number, as in AA1 the logis to use the ASCII codes of the letters ...
0
votes
1answer
37 views

Showings days past due and days until due in same field

=IF(ISERROR(DATEDIF(NOW(), [Renewal Date], "d")), -DATEDIF([Renewal Date], TODAY(), "d")) I am using the formula above and this is correctly showing me the items that are past due and for items that ...
0
votes
1answer
29 views

How do you assign value to individual choices

Using: SharePoint Online How do you assign value to the following choices Low = 1 Medium = 2 high = 3 Then later on I want to be able to calculate 5 different questions for the total risk rating. ...
0
votes
1answer
53 views

How to create formula based on column value

I have a column in my SharePoint list named "Container Content." When adding a record in SharePoint you can choose one of three items in this column, it is a choice column. The three items you are ...
0
votes
1answer
23 views

Column validation sharepoint list.Whats wrong with this formula

H All, I have a date i need to validate to make sure the user picks a date not less that todays date. I typed in this formula below ="Review Date"<TODAY() that works for the validation. but ...
0
votes
1answer
745 views

Calculating overdue status in a Sharepoint list using calculated column

Hoping someone can help as I am relatively new to Sharepoint. I've created a list to track completion of internal audit activity. It includes a status column and due date column. I'm trying to ...
0
votes
1answer
23 views

How do I create an formula in SharePoint Online?

hope you're well; I would like to know how to create a formula for weekly in SharePoint online. For example Tax year is April 2018 but I would like weekly number to be from Tax year.
6
votes
0answers
95 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 ...
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
610 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
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(...
1
vote
0answers
28 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
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 ...
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
143 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
72 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
0answers
70 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
0answers
64 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
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
108 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
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
984 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
0answers
186 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 ...
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 (...
0
votes
0answers
84 views

pop up info tab for custom list in sharepoint 2013

I am looking for a pop-up something like in the picture. (column info) Is it possible to use calculated column or Client Side Rendering for this kind of requirement. Anyone who have any idea ...
0
votes
0answers
56 views

SharePoint List formula

I need help on below list. Pur No. Stock Qty, Sold Qty, Balance Qty. 001 500 First time when user enter the sold Qty it will work (Stock Qty - Sold Qty = Balance Qty) so if sold Qty is ...
0
votes
0answers
2k views

how can we get the Current UserName instead of LoginName using calculated column in SharePoint 2013?

using [Me] as formula in column gives me current user login name. help me out if we can get the user name instead of login name.
0
votes
0answers
469 views

Content Type IDs help

I have 2 Content Types, A and B. I am trying to create Content Type ID's(not proper ID's) and completely separate from the ID already in the list. I am creating them as a calculated field but I cannot ...