0
votes
4answers
54 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
16 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 ...
0
votes
1answer
44 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
22 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
24 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
150 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
514 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
85 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
193 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
124 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. ...
1
vote
2answers
987 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
413 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
528 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
2k 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 ...