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