Hello,

Been struggling for a while to get a formula working I think due to the restriction of the return data type only being one type at a time but hoping you can help.

In the Suppliers module, we have three fields.

Criticality Rating (can be 1, 2, 3 or N/A)

Last Review Date (manually entered)
Next Review Date (formula, to be 2 or 3 years after Last Review Date)

Right now the working formula I have is: 

Adddate(${Suppliers.Last Date of Review},2,'YEAR') 

What I want is a combination of IF and OR, I believe.

If Criticality Rating = 1 then Adddate(${Suppliers.Last Date of Review},2,'YEAR')

If Criticality Rating = 2 then Adddate(${Suppliers.Last Date of Review},3'YEAR')

If Criticality Rating = 3 then Adddate(${Suppliers.Last Date of Review},4,'YEAR')

I got as far as:

If(Contains(${Suppliers.Criticality Rating},1,Adddate(${Suppliers.Last Date of Review},2,'YEAR'))) but when I started to add in OR modifiers, constant syntax errors and it doesn't highlight WHERE the error is, and the given examples don't help at all.

Can you please help me construct this formula, so that the first value, dictates the second value which HAS to contain a formula to automate it otherwise there's no point using it.

Many thanks