IF(
SEARCH(“1”, {Type of Workshop or Class Offered}),
DATEADD({Proposed Date of Workshop or Class}, 0, ‘days’),
IF(
SEARCH(“2”, {Type of Workshop or Class Offered}),
DATEADD({Proposed Date of Workshop or Class}, 1, ‘days’),
IF(
SEARCH(“3”, {Type of Workshop or Class Offered}),
DATEADD({Proposed Date of Workshop or Class}, 2, 'days’),
IF(
SEARCH(“4", {Type of Workshop or Class Offered}),
DATEADD({Proposed Date of Workshop or Class}, 3, ‘days’)
)
)
)
I added the last bit by copying the one before it and now the formula doesn’t work, what am I doing wrong?