0
votes
1answer
18 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
38 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?
1
vote
1answer
151 views

Unable to add a Choice field to a Calculated field (SharePoint Foundation 2013)

I'm not sure why I'm having this issue, as all material says that I should be able to do this... I have a required choice field that I would like to use in a calculated column. However, when I try to ...
0
votes
3answers
262 views

How to show two dates in one calculated column

I'm using Sharepoint Foundation 2010. I have two columns, start date and ending date. I want to make calculated column which shows both of them in the same column. Everything is okay till I add both ...
0
votes
1answer
310 views

Selecting desired option with drop down menu using formula

I was creating a sample List which has Category section, under which we have three different options, namely Hindu Muslim Christian Now, i want to create another column which should help the ...
0
votes
0answers
138 views

Displaying Calculated Form in EditForm

I have a calculated form that concatenates 3 fields. These fields are editable in the new form but in the edit form I've used Javascript to set them as readonly. What I'm hoping to achieve is to ...
0
votes
2answers
332 views

Get Elapse time from Created and Modified Columns

I'd like to created a calculated column which subtracts the modified date/time from the creation date/time, is this possible? EDIT: This worked for me - =TEXT(B2-A2,"h:mm:ss") replace the cell ...
1
vote
3answers
282 views

Auto-populate Sharepoint list based on most recent list item in another

Can anyone help? I want to be able to auto populate a field within a SharPoint list based on the most up-to-date field within another list. . List Details Projects List - List of projects. Fields ...
0
votes
1answer
828 views

Validation formula that TEXT should not to have SPACE

Is there any validation formula which don't allow to save some value in column with SPACE in SharePoint 2010? I know that is Calculate column formula with TRIM formula but I need to validation formula ...
2
votes
1answer
3k views

How to make SharePoint 2010 calendar view Time Sensitive!

I am trying to create Dataview Webpart for SharePoint Calendar Events to display [Today] items. I was sucessful on that, my next challenge is how to make it time sensitive. I want to display events ...
1
vote
1answer
159 views

using calculated field in calculated field

I have field1, field2, field3, calcfield1, calcfield2, complexCalcField1 Calcfield1 and Calcfield2 use field1, field2 and field3 for its values. ComplexCalcField1 uses Calcfield1 and Calcfield2 for ...
0
votes
4answers
2k views

Trouble with IF formula

We have a task list with a column that categorizes tasks into one of 12 categories. We're trying to calculate a NEW column that will be populated with one of two values, "Technical" or "Procedural" ...
0
votes
3answers
1k views

Calculated value column

In SharePoint foundation 2010 can i add a new calculated value column where the calculation are based on when another column is modified ?
1
vote
1answer
782 views

How to Retrieve Numeric Column value from SharePoint List

In the SharePoint list I am having the numeric column and the value is like this 123,456,789,012,346,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000. I am using SPQuery to retrieve items ...
1
vote
1answer
910 views

Problem with formula when creating calculated column when referenced column that has space in its name

Not sure what the problem is but when i use the following formula when creating a calculated column =IF([Event Type]="","Black",IF([Event Type]="PFL","Red",IF([Event Type]="VCL","Gold",IF([Event ...