Welcome to the community, @Rob_Edwards! :grinning_face_with_big_eyes: You’re correct: it’s an issue with the placement of your parentheses. In short, your version completely closes the first IF function before starting the second. What should happen is that the second should be nested inside the first as the third item in the function format. The basic format is this:
IF(logical, result_if_true, optional_result_if_false)
Your second IF should be in that optional third part, which you can get by moving that one parentheses from the middle to the end:
IF({Type}="Form 1", DATEADD({Notice Sent}, 7, "days"), IF({Type}="Form 2", DATEADD({Notice Sent}, 10, "days")))
There’s also a slightly easier way to do this using SWITCH, which is designed for just this type of situation where you’re looking at one thing—the contents of {Type} in this case—and switching the output based on what you find there. The basic way of restructuring this using SWITCH would be as follows:
SWITCH({Type}, "Form 1", DATEADD({Notice Sent}, 7, "days"), "Form 2", DATEADD({Notice Sent}, 10, "days"))
Even this can be optimized further, though. The only thing that’s really changing is the number of days added. With that in mind, you could nest SWITCH inside a single DATEADD function to change that number:
DATEADD({Notice Sent}, SWITCH({Type}, "Form 1", 7, "Form 2", 10), "days")
