Nested IF statement

Can someone help me with the syntax for a Nested IF Statement?

For the Nested IF, I would think it would be similar to below:

IF({BP Status})=“Start”,FORMAT_DATE(SUBTRACT_DAYS({Date1}, 21))),
IF({BP Status}=“Second”,FORMAT_DATE(ADD_DAYS(Date1,14))),
FORMAT_DATE(SUBTRACT_DAYS({Date1}, 7)))

It’s a simple:
If this then this
If this then this
else this

Hi @NBRunner73 :wave:

The below formatting should work :slight_smile:

IF({BP Status} = "Start", FORMAT_DATE(SUBTRACT_DAYS({Date1}, 21)), (IF({BP Status} = "Second", FORMAT_DATE(ADD_DAYS({Date1}, 14)), (FORMAT_DATE(SUBTRACT_DAYS({Date1}, 7))))))

Here’s a screenshot of the formula in action!

image

-Scott