SharePoint Calculated field help

Posted on 2012-09-20
Last Modified: 2012-10-12
I have a sharepoint list that has a calculated field based on the values of other fields which is not operating exactly how I would like, I probably need to understand a couple questions about the field.

Here is the calculation
=IF([Pursuit Health Override]="green","green",IF([Pursuit Health Override]="yellow","yellow",IF([Pursuit Health Override]="red","red",IF(ttlrating3=4,"blue",IF(ttlrating3=3,"green",IF(ttlrating3=2,"yellow",IF(ttlrating3=1,"red",0)))))))

So basically the logic should be if Pursuit Health Override <> n/a then set this field to the value of Pursuit Health Override
If ttlrating3 = 4 then set value to blue
If ttlrating3 = 3 then set value to green
If ttlrating3 = 2 then set value to yellow
If ttlrating3 = 1 then set value to red

SO a couple things, I would like to change the first three IFs in the logic to one if possible saying in value is n/a set to Pursuit Health Override

The final part of the issue is that many times the value ends up as 0 which causes problems because I do some workflow work where I store this value into another text field called pursuit health previous and if the value is 0 the pursuit health value gets set to float;#0 which I don't know what is...
Question by:Matt Pinkston
    1 Comment
    LVL 44

    Accepted Solution

    perhaps you want to try this:
    =IF([Pursuit Health Override]="n/a",IF(ttlrating3=4,"blue",IF(ttlrating3=3,"green",IF(ttlrating3=2,"yellow",IF(ttlrating3=1,"red","0")))),[Pursuit Health Override])

    Open in new window

    Which SharePoint version are you using?
    What field type has the field [Pursuit Health Override]?

    Thanks and HTH

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Looking for New Ways to Advertise?

    Engage with tech pros in our community with native advertising, as a Vendor Expert, and more.

    If you create your solutions on SharePoint sooner or later you will come upon a request to set  permissions of the item depending on some of the item's meta-data - the author, people assigned as approvers, divisions, categories etc. The most natu…
    I thought I'd write this up for anyone who has a request to create an anonymous whistle-blower-type submission form created using SharePoint 2010 (this would probably work the same for 2013). It's not 100% fool-proof but it's as close as you can get…
    To add imagery to an HTML email signature, you have two options available to you. You can either add a logo/image by embedding it directly into the signature or hosting it externally and linking to it. The vast majority of email clients display l…
    This video gives you a great overview about bandwidth monitoring with SNMP and WMI with our network monitoring solution PRTG Network Monitor ( If you're looking for how to monitor bandwidth using netflow or packet s…

    761 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    7 Experts available now in Live!

    Get 1:1 Help Now