[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 762
  • Last Modified:

SharePoint Calculated field help

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...
Matt Pinkston
Matt Pinkston
1 Solution
Rainer JeschorCommented:
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

Featured Post

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now