2
votes
2answers
62 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
4answers
93 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 ...
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 ...
1
vote
4answers
101 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
0answers
118 views

Add month in calculated date column

I'm using SharePoint 2007. I've a column with date in format DD/MM/YYYY I've also another column where I want to add some months to the previous date and obviously I've a column with the number of ...
0
votes
1answer
22 views

Using field [year] in calculated column issue

I have an issue with the calculated field. Basically in SharePoint 2007 I have my field called Year, so this Year I would like to use in another calculated field. So I create the field and put there ...
0
votes
1answer
67 views

Extract data between parenthesis in calculated value field

I'm using SharePoint 2007 and I would like to extract data from parenthesis from another column to a calculated field in the same list. For example: Column named "Team", value "RED (Mark, John, ...
0
votes
1answer
506 views

SharePoint 2007: Calculated column - formula for calculation based on column containing NA

In a SharePoint list, I have 6 numeric columns that can contain numbers in the range (1,4). However, one or all of these columns may contain "NA" value. There is a separate calculated column which ...
2
votes
1answer
133 views

Is there a way to determine if there is an attachment in a calculated column?

I'd like to have a column display "Yes" if there is an attachment to the sharepoint list item, or "No" if there isn't one. Default would be no, but then if they edit the item to add an attachment, I ...
1
vote
2answers
261 views

Default Value for tomorrow at specific time

Say I'm currently using a Date/Time field for workflow purposes, the default value being Today+1. That gives the time at 12:00am tomorrow, which is great. Is there a way to always give the default ...
3
votes
4answers
6k views

How to resolve full names from a Person or Group column (that contains multiple entries) in a designer workflow

I have a custom list with a custom content type, with a workflow, on SharePoint 2007 as outlined in this other StackExchange question. I'm using a Person or Group typed column to contain a list of ...
3
votes
1answer
326 views

“Changed On/Modified” columns - Date Format & Regional Settings

I was wondering if I change my regional settings through: Site Settings - Regional Settings - Locale: Dutch (Netherlands), affects the date format of the standard columns (Changed On/Modified e.g.). ...
1
vote
2answers
1k views

What is the formula for calculated field to calculate the milliseconds of the field “Created” in SharePoint 2007

In SharePoint 2007 List, there is a field (or column) called "Created". It contain the date in which a item is created. I want to create any field, a calculated field, to help me calculate the ...
0
votes
1answer
748 views

Can Search be performed on a calculated field in advanced search? (SP2007)

I have yet to find a definitive answer to this question. Right now this does not work for me in sharepoint 2007 and the only common characteristic I can find for the fields is that they are calculated ...
0
votes
2answers
894 views

How do I set up a calculated column to reference itself?

I need to set up a column that will keep a running total of values. I have a program that automatically sets values for the columns in SharePoint. The program will overwrite the previous value ...
2
votes
3answers
910 views

Calculated Field IF expression separators

I'm creating a list with some calculated fields from code that use IF expressions. fieldCalc.Formula = "=IF([Field1]=0,[Field2],[Field3]&\" (\"&([Field4]/[Field5]*100)&\"%)\")"; ...