0
votes
1answer
15 views

Getting Calculated Filed Data into Links

I know I can make links with calculated fields; however, I am having a hard time getting the value of a column I need within the URL. Here is my code. I think I am close here but still having ...
1
vote
1answer
61 views

Help with 'IF' Statement for Calculated Column

I need help writing an IF statement for a SP calculated column. I have it working right now to display the green indicator, but need to add the clauses for it to display the yellow and red indicators ...
0
votes
2answers
128 views

Calculated column value for Yes/No field in sharepoint

I am developing a KPi, where am using a column named Complete which contains Yes/No field in it. For this if i write a calculated value for yes/no field: =IF(CompletedTask=1,"Yes","No") its not ...
1
vote
1answer
68 views

Calculated value formula

I need help with the formula for the following problem. I have a list where you fill in a number of ordered items, and another column where you fill in how many of the items that are receieved. Lets ...
0
votes
1answer
119 views

Calculated Column formula returns syntax error

Found this one that seems to be the solution needed but i cant get it to work: Column1 has the value of BD122 Formula: =EXACT([Column1], "BD122") Expected result: Compares contents of Column1 and ...
0
votes
0answers
107 views

Calculated column with formule in visual studio

I am creating calculated column through content type in visula studio.But the Formule is empty when i check in the calculated Column. Can any one help me .Below is the scenario which i have tried. ...
0
votes
2answers
450 views

Autoincrement a field based on ID

So I'm trying to autoincrement a field on a list item. First i tried using a calculated value field "=[ID]" which works the first time, but after saving a new item to the list the "[]" are gone and, ...
1
vote
1answer
197 views

MAX Formula for Calculated Field

The Question How can I create a Calculated column with a formula that works the same way as an Excel MAX formula? Why I have a need to create unique ID's for process documents, but can't rely on the ...
0
votes
1answer
436 views

How to create a Project Tasks List view for Overdue tasks?

How do I create a dedicated view to display only the Overdue tasks based on three columns. Start Date and End Date (Actual End Date) and Target Date (projected completion date) Target Date - Start ...
0
votes
1answer
1k views

Use value of Hyperlink column in a calculated column

I want to create a calculated column, it should show the value of Title and the URL of a Hyperlink column called Main Website. But I get an error for my formula: =[Title]&" ("&[Main ...