Solved
Help in Calculated FIeld for Priority set up
Hi,
Looking for HELP in Calculated Field in project custom form, created a field name "Score", and conditions are;
If Calculated Score =600, Then Priority=Urgent
If Calculated Score <600, but more than 499, Then Priority=High
If Calculated Score <500 but More Than 249, Then Priority=Medium
If Calculated Score <250, Then Priority=Low
I tried this one, but not showing priority in the report/project;
IF({DE:Calculated Score}=600, "Urgent", IF({DE:Calculated Score}<600, "High", IF({DE:Calculated Score}<500, IF({DE:Calculated Score}<250,"Low"), "Medium")))
Am I missing in between, appreciate your immediate help in this regard.
Best regards,
Kundan.
