Welcome to Office and 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

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?

    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

Order Your Fundamentals CD Today!Get up to speed quickly and learn how to uncover rich information management capabilities with this free SharePoint CD. IT ConnectionsDive into the new Microsoft platforms and products you implement and support with the experts from Microsoft, TechNet Magazine, Windows ITPro and industry gurus. There are 70+ sessions and interactive panels with networking opportunities. Attention User Groups & User Group Leaders...Announcing the eNews Generator—a FREE HTML e-newsletter builder for user group leaders. Build your HTML and text e-newsletters in minutes. And add Windows IT Pro & SQL Server Mag articles alongside your own message!. Get Specialized SharePoint Training!SharePoint MVPs Dan Holme, Michael Noel, and Andrew Connell share their perspective and expertise in these exclusive eLearning seminars. One Event for developers and one for IT pros. Choose the one that fits your needs! Get SQL Server 2008 at SharePoint ConnectionsDon’t miss SharePoint Connections, the premier event for Microsoft IT Professionals, in Las Vegas, November 10-13. Every attendee will receive a copy of SQL Server 2008 Standard Edition with one CAL.