0
votes
1answer
17 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
43 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
127 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
101 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
190 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 ...
2
votes
3answers
4k 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
261 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
995 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
662 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
727 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
843 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)&\"%)\")"; ...