Matt Pinkston
asked on
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([Pursui t Health Override]="yellow","yellow ",IF([Purs uit Health Override]="red","red",IF(t tlrating3= 4,"blue",I F(ttlratin g3=3,"gree n",IF(ttlr ating3=2," yellow",IF (ttlrating 3=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...
Here is the calculation
=IF([Pursuit Health Override]="green","green",
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...
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.