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.

I have a list with a series of columns that all return percentages. I have done the stop light chart with status columns but not percentages. I have gone to 'Path to SharePoint' - the site everyone ...

I need to create a calculation that basically is a subtraction between two fields (2 date fields). However it should be done only if a 3rd field is equal to a value of 5 or 6 AND a fourth field less ...

I use [ME] in a calculated field it returns a username of \username.
Customer wants to see the user name as display name not as login name.
Would like to know whether a SharePoint formula I can use to ...

I have a list where in we are capturing Completion Month date. It can be updated by users if required. I need to have a record of number of times this value is updated for each individual row starting ...

Is it possible to have an attribute, like start date, where other columns would use it to calculate their value?
For example the due date column would take the start date and then add the amount of ...

I am trying to create a view where Invoice Admin wants to see all the records where invoice due dates are within next 5 days. I added a calculated column and i have =[DueDate]-5 but this formula only ...

I have a user who has requested a way to track vendors and their price quotes for project work. The user would like to have the list automatically calculate the total of all quotes listed. There can ...

I want to update a Column Name using a Calculated Column. In my attempts below, I'm trying to rename the Column name from Col2change to NewName. None of the code snipperts work.
I do not have access ...

I have 3 columns, for simplicity we'll say column A, column B and Calc Column. In the Calc Column I need a formula for the following:
If column A is blank, and column B is greater than 90 days from ...

I wish to create an auto incremented "TaskId" list field. I had intended to create a new value that padded out the [Id], but obviously [Id] cannot be used as it is not available until after the item ...

I have a calculated column of date strings. The calculated field reads 5 other columns and is filled with a date STRING from the other fields. The calculated field has an type of date. The problem is ...

I currently have a limitation with some 3rd party software being unable to display calculated fields.
I started investigating whether I could display my calculated field value using a COMPUTED column ...

I have been asked to make a list that contains a calculated column containing the week number within a fiscal year starting on 6th April 2015 (Monday) So for example, 6th-12th April would be week 1, ...

Is it possible to create a calculated column that takes a date field and sets the value to the first day of that month?
I want to create a view that only shows the current month events. Basically, I ...

Basically, I'm trying to use SharePoint as some what of a project tool for tasks.
On a new task, we have "START DATE", and a custom number field "ETC". I'd like to have a calculated field "END DATE" ...

I have a problem both in Sharepoint 2010 and Sharepoint 2013 when I create a Excel View to list, and have got a Calculeted Column there after klick on calculeted Column I can edit Excel formulas and ...

I have column in sharepoint 2010 list which has value like
http://mysitecollection/sites/SPDev/Arizona/Lighthouse.jpg
I want the value in calculated column should be Arizona.
Can anyone let me know ...

I am working with SharePoint 2013 at a hosted site (not Office 365).
Most of the questions I see when I search relate to including a lookup field in a calculated column. That is not my issue (but it ...