Calculated Field in Custom Form Looking for your expertise

[Kundanism]

Hei

Created Custom form title "Priority Setting of ECRs", but in the calculated field "Priority of Claim" tried to add condition on IF statement.

This calculated field is based upon above calculated field "CC1", and added to a project while testing. But the calculated field "Priority of Claim" does not shows the condition based upon the value coming from calculated field "CC1".

Please guide in this regard. Also refer the attachment.

Mvh

Kundan.

[AnthonyIm · Accepted solution]

Hi - so I've never seen <= in a calculated expression. I tend to stick to just equal, less than, or greater than. Based on your screenshot, this is the calculation I would use

IF(CC1=729,"Urgent",IF(CC1<500,IF(CC1<11,"Low","Medium"),"High"))

See if that works for you.

[Kundanism]

Many thanks @Anthony Imgrund‚

Really appreciate your help and attention for quick reply.

I confirm, it works exactly.

Have a nice day!

Best regards,

Kundan.