Welcome to Office & SharePoint Pro Sign in | Join | Help
in Search

SUBSCRIBE to Windows IT Pro Magazine & SAVE 30%      FREE Email Newsletters Vista UPDATE, Windows IT Pro UPDATE & More

Office & SharePoint Pro » SharePoint (WSSv3 and MOSS2007... » Customization and Design » Ability to use a Workflow Status column in a Calculated column?

Ability to use a Workflow Status column in a Calculated column?

Last post 04-08-2008, 1:25 PM by dgilmour22. 0 replies.
Sort Posts: Previous Next

  •  04-08-2008, 1:25 PM 29517

    Ability to use a Workflow Status column in a Calculated column?

    Reply Quote 
    I have a Document Library that has three different Workflows. I am attempting 
to create a calculated column that will evaluate to "Yes" if any of the 
Workflows have been approved. (Evaluated to 16, the value of the Approval).

However, when ever I try to use the column, I get this error:  One or more 
column references are not allowed, because the columns are defined as a data 
type that is not supported in formulas. 
 

This is my ultimate formula: =IF(OR([Pre-Approved Change 
Approval]="16",[Standard Change Approval]="16",[Emergency Change 
Approval]="16"),"Yes","No")

But I get the error with just this too:  =[Pre-Approved Change Approval]

I have seen that the "," really needs to be a ";" and I will change that 
when I test further... I also found some posting there that a Document 
Library list is different in some undocumented way than other lists.

Why can't I use the columns from the Workflows?

Thanks,
Doug
View as RSS news feed in XML
SPONSORED LINKS FEATURED LINKS

SharePoint Security SimplifiedHaving trouble with Permissions in your SharePoint environment? Check out USPM v2007® Order Your Fundamentals CD Today!Get up to speed quickly and learn how to uncover rich information management and deployment capabilities with this free SharePoint CD. Simplify Content Migration for SharePointEase the job of SharePoint migration and ongoing site maintenance. Michael Noel outlines your migration options in this white paper. Download today! Prepare Yourself for Exchange CatastropheRead this white paper to learn how you can keep Exchange server healthy, as well as predict and respond to server failure. Featured eBook - Fundamentals of Fax Server TechnologyTake advantage of the benefits of fax servers and find out how you can implement a solution that is easy to support, secure, and integrate. Dramatically Accelerate Microsoft SharePointDeliver unimpeded access to SharePoint - Learn how to fix more than just the symptoms of slow application delivery and poor performance. Protect Your Company’s Digital AssetsDo you know the risks of sending important files over email or FTP? Read this white paper to learn what you can do to safeguard your company’s data. Boost Customer Confidence and SatisfactionRead this eBook to learn how fax servers can ease communication with less computer-savvy customers while reducing your security, compliance, and support woes. Implement a Successful Archiving SolutionView this web seminar to learn the best practices for creating an email archive that is secure, compliant, and searchable.