Solved

# SharePoint Calculated field help

Posted on 2012-09-20
741 Views
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

Else
If ttlrating3 = 4 then set value to blue
Else
If ttlrating3 = 3 then set value to green
Else
If ttlrating3 = 2 then set value to yellow
Else
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...
0
Question by:Matt Pinkston
1 Comment

LVL 44

Accepted Solution

Hi,
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])
``````

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

Thanks and HTH
Rainer
0

## Featured Post

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 (https://www.paessler.com/prtg). If you're looking for how to monitor bandwidth using netflow or packet s…