Tagged Questions
0
votes
0answers
14 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 ...
1
vote
1answer
26 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
99 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 ...
0
votes
1answer
318 views
Can sharepoint calculate the number of “business hours” for a list item to be completed?
I work in financial institution and we want a column in a case management database to show the number of "Buinsess hours" from start to finish of a case.
Business Hours
Monday to Friday 5am - 8pm
...
2
votes
3answers
2k 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
181 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
608 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
475 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
515 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
688 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)&\"%)\")";
...
