What is wrong with this?

[Leslie_Miller]

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?

[Jeremy_Oglesby · Accepted solution]

Looks like you are missing one closing parenthesis at the very end. You have 4 IF( statements, but only 3 of them are closed. That should be all – assuming your quotes are “straight” quotes in the Formula editor.

[Leslie_Miller]

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’)
)
)
)
)

So this should work?

[Jeremy_Oglesby]

Yep - that looks valid to me.

[Leslie_Miller]

would it matter if some is nested and some is not?

[Leslie_Miller]

what key strokes are used for nesting spacebars or tab?

[Jeremy_Oglesby]

Nesting should not matter - the formula editor ignores most whitespace.

[Jeremy_Oglesby]

Are you still getting errors? If so, the next thing to check would be the quotation marks. If you are copy-pasting what is here in your forum posts, you are going to end up pasting “smart” or “curly” quotes – they all need to be replaced with " and ' - “straight” quotes.

[Leslie_Miller]

It was the straight quotes! Good call!

[Jeremy_Oglesby]

For the benefit of future forum readers, could you mark my original reply as the “Solution” here – that was the primary issue with your formula at first.