Tagged Questions

Calculated columns are the SharePoint equivalent of Excel formulae. They allow you display values that are calculated from the values of one or more other columns. These calculations can be made using standard mathematical operators and SharePoint's built-in functions.

learn more… | top users | synonyms

1
vote
0answers
13 views

Update SharePoint calculated column on Infopath form

I have an Infopath 2010 list form that displays a couple of calculated columns. My users have asked if I can make those fields update dynamically while the form is open. I have already tried moving ...
0
votes
0answers
27 views

Can I create a list which counts the number of documents of a specific metadata type by the folder they are stored within?

Running SP2013 Foundation. My users interact by uploading documents to personal folders within a document library, selecting the type of document they have uploaded via a lookup column and SP list. I ...
0
votes
0answers
20 views

Calculated Colum to pull Image filename and add Network Path

I am working on a project that will have nice Web ready images in our SharePoint (online) site. Each one of the images also has a hi-res counterpart that is on a network drive. The filename is the ...
0
votes
0answers
48 views

SharePoint 2010 - Custom List - Sum of Group and display in Chart web part

I hope anyone out there will be able to help me :) I have to create monthly reports on SharePoint that show a count of something. The reports must include a grand total (corporate level) and sub ...
1
vote
0answers
17 views

Calculated Field formula for triggering the task 15 minutes before the starting time

I need to use a calculated field in order to trigger before 15mins of the task starting time. Please let me know what is the formula that I can use for this. Is it something like below? =[Start ...
0
votes
0answers
23 views

Creating a Calculated Date Field with embedded double quotes

I have been provisioning a load of Site Colummns with PowerShell . I am however, having a lot grief with a calculated field spField.Formula = "=TEXT(DATE([Created],"mmyyyy"))" spField.OutputType = ...
1
vote
4answers
117 views

How to update calculated column on a daily basis without admin rights?

I am running SharePoint 2013 and have a column that is supposed to determine whether or not each phase of a project is late. I am using the NOW() fucntion, which, of course, does not update ...
0
votes
3answers
28 views

How can I sort this by an actual DATE?

I have a calculated field in a document library that takes the "Modified" property makes a more readable date from it. The problem is, the column is now sorting alphabetically, even though the data ...
1
vote
1answer
39 views

Calculated Field to index a String

How do I get the substring ABC from following string Hello(ABC). I used right and left function with no success
0
votes
0answers
18 views

How to copy calculated field formula client-side?

I am trying to copy a calculated field value from SharePoint (using web services) Paste the field value to another field Problem is this: SharePoint seems to give me two wrong versions of the ...
0
votes
1answer
22 views

Validation Formula

I need help with a formula that will return true only when ( category <> "red" ) OR ( category = "red" AND EmployeeName - a people picker field - is not empty ) Thanks very much !
0
votes
0answers
10 views

Can you have a seperate indicator field that lists columns when data is entered?

Is this even possible? I have a list for used for new employees to track what training they have completed. The list has the following columns; First name, last name, when they joined and the dates ...
0
votes
1answer
52 views

Calculated Column with ISBLANK

I am trying to obtain a calculated column with ISBLANK =IF(ISBLANK(AuthorTxt) , Title , Title + " " + AuthorTxt) as suggested here but I get a syntax error or not supported formula message. Why ...
0
votes
1answer
42 views

Calendar Overlay in sharepoint2013 programatically

I want to create calendar overlay in sharepoint2013 programatically using visual studio2012. Please help how to start with that. Happy Sharepoint!!! Regards, Aisha.
0
votes
0answers
11 views

Problem with filtering in a calculated value

I have a calculated value field, named Year1 = TEXT(mydate"yyyy") In allitems.aspx, if I select one year, it doesn't show anything. If I select two years, it show the results of the first year that I ...
0
votes
2answers
33 views

Speedometer gauge using calculated columns?

My idea is implement a speedometer gauge at the top of my page that will change dynamically based on the average of a column, what i'm thinking is to use three speedometer images (low/med/high) and ...
0
votes
1answer
19 views

Display the column IDs for a column having same dates

I have a list with date column. Items having the same dates should store the IDs together. For eg: Item ID 1,12,15,etc. has the same date,then a column in these items should store all these IDs. ...
0
votes
0answers
48 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
29 views

Calculated column help

I have a Column with Title like below "sharepoint Documents(sp2010)". Now i want to have a calculated coulmn that will have sp2010. I have tried like this it is working but it has the value like ...
1
vote
2answers
78 views

Calculated column with link - remove space / whitespace / slash

=IF(Title<>"";"<a href='/test/"&SUBSTITUTE([Title]," ","")&SUBSTITUTE([Title],"/","")>Info</a>";"#") I'm trying to create a link based on two coloums. Is there a way to ...
2
votes
2answers
63 views

the IF(OR) statement

I am trying to nest 6 IF(OR) statements in SP 2007 for a calculated field in a list - But it seems as if it is getting too long, and I get the syntax error thrown at me. I tested half of the length ...
0
votes
0answers
70 views

Updating a (calculated) field based on lookup field :: Workarounds

I am a site owner in SP2010 impl., at work. Not a farm admin / super admin. For one of my needs, I am designing a list using Datasheet View. I have columns of People, Lookup and Choice datatypes. ...
1
vote
2answers
100 views

Validate a Single line of text column type of list in sharepoint 2010 to accept only alphabets?

How to validate a Single line of text column type of list in SharePoint 2010 to enter accept only alphabets? no special character and no number should be allowed in that field.
0
votes
4answers
99 views

Calculated Column [Today] work around?

Ive been doing alot of reading into getting [Today] to work within a calculated column but im starting to wonder if theres a better solution staring me in the face Basically we have an asset register ...
0
votes
1answer
55 views

Calaculated column to display the next 8 business hours

In one of the column I am having the current date and time based on that using calculated column I have to show the date and time of the next 8 business hours date and time. How can this be done?
2
votes
1answer
54 views

Duplicate filter values in a calculated column

I have a document library with a calculated column. This document library is populated from a windows service. Every time a new document is added, the calculated column has a formula to choose ...
0
votes
1answer
34 views

Count Column in SharePoint List

I am trying to add a column that counts every time a date column is amended past the current date stored by more than 7 days. Column A would be a Project Live Date which isn't a fixed date column so ...
1
vote
0answers
49 views

; or , in calculated columns

I can't understand the choice of the separators in calculated columns. I'm using SharePoint 2007 (MOSS), and I wrote a calculated column in order to extract the month name from a date. I used this ...
0
votes
1answer
20 views

Display an image based on date range

I have a SharePoint list of devices that are checked out or reserved by a personnel. We check them out or reserve them based on the requested dates that has a start date to finish date column. How ...
2
votes
1answer
122 views

Use calculated column to add target“_blank” at the end of a Web field URL

It appears I cannot configure a hyperlink column to open in a new window. I read in this post that you can concatenate a hard coded url with the title field of an item to achieve this. However, that ...
1
vote
1answer
177 views

How to fix [today] and [now] in a list

I have the following issue: we use a SP list to send information through the steps of the process. On each step somebody adds information into the list, next person receives it, adds his own part of ...
0
votes
1answer
62 views

Can MIN and ISBLANK be used together in a calculated column?

I have a custom list that displays the expiry date of Certificate 1 and Certificate 2. Candidates must have both to be considered Certified. The Certification expiry date is the earlier of the two ...
0
votes
1answer
53 views

Skipping blank cells when using concatenate in a list's calculated column

I am using Concatenate in a calculated column to combine information from two columns in a list like this =CONCATENATE(A2, ", ",B2," feet"). Can you help me with a formula that would leave the field ...
0
votes
1answer
33 views

Display image based on task completion

I am trying to display a 'progress bar' on a page which includes 5 different images. I would like to create a workflow where the image would change based on the completion of tasks in a task list. The ...
3
votes
2answers
71 views

Calculated Column - IF true AND true

Using a task list I am trying to show a value if a cell is = to a certain string, AND task is complete. Im currently using this but returning a #VALUE error =AND([Task Name]="Task ...
0
votes
0answers
54 views

Change calculated column to xsl:value-of select

I work with a calculated column which depends on the title column. Now i want to change the cascading title inot the filename. This should be done with the SP designer and a customization of the xslt ...
0
votes
1answer
92 views

Changing a Column Choice value and updating the column value for any previously saved items

I have a list with a choice column which has muliple choices, so that the user can pick from a selection. Would like it so that the choice list is updatable (i.e can change the names) at a later ...
0
votes
1answer
71 views

formula to select a choice column

I have two choice columns in a list : choice column 1: values 1 posible 2 unlikely choice column 2: values A bad B very bad and I want to select another choice column based on the previous selected ...
1
vote
4answers
102 views

How to filter calculated columns in the filtering menu

I would like to display my calculated columns fields in plain text in the filtering drop-down menu when I click on the column title. I don't know why SharePoint displays my calculated formula instead ...
0
votes
1answer
15 views

Is it possible to report an activity date and calculate which pay period it falls under in a bi-weekly schedule

I really have no idea how to address this. I am tasked with marking and developing a way to track late entries based on the created date of a list item, the reported activity date(date selector), and ...
0
votes
1answer
24 views

Calculated Date after 3 years

Can anyone please tell how to get the calculated date after 3 years from current date. I have tried different combinations none is working =TEXT(YEAR(Created)+3,"MM/DD/YYYY") It returns ...
0
votes
1answer
116 views

How to render HTML/Plain Text to the filtering drop-down columns

I have a custom list, with some columns. In order to design my list with colors, I used calculated columns with a Content Editor Web Part which contains my script (JavaScript). I used this script : ...
0
votes
0answers
114 views

Sum of a calculated Product Column

I am working with a custom Dataview in SPD. I have a calculated field that is the product of Quantity and UnitPricing. The view is grouped by another field, so I would like to get the node subtotal. ...
0
votes
3answers
58 views

sharepoint list column calculation

In a new list item form,the user wants to have a column to display month & year(pre populated on opening the form) based on the below condition. "1. If the current date is > 15 ,then that column ...
0
votes
1answer
264 views

Folder name as calculated field

I've created a Library which consists of two Folder Content-types. Customer Prequalfication I'm looking to create a calculated column in the Prequalfication folder content-type which fetches the ...
1
vote
1answer
28 views

Calculated column being changed on save

I need to keep the URL of a list item to use in a notification so I have a formula that looks like this: ="http://basicsample.com/next/List/EditItem?ID="&[ID] When I create an item in the list, ...
1
vote
2answers
166 views

Calculated column to retrieve total number of ID

I have a SharePoint list which all has a unique ID to identify the items, so I want to create a calculated column that counts how many ID are there, like a count! Any help is appreciated
0
votes
0answers
26 views

Calculated column as a quick part

I need to return a value from a calculated column as a quick part in MS Word. How can I do this?
2
votes
3answers
212 views

DateTime calculated Column using Formula

I have a column Birthday which contains the date of the user's birthday. I would like to create a calculated column to hold the user's next birthday. For instance, if I wanted to know the birthday in ...
0
votes
1answer
66 views

How to build a modal dialog link in a calculated column to use modal dialog

I have tried appending a hyperlink in a calculated column that should popup a modal dialog but it's not working for me. Anyone got this working?