Help

The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.

What is wrong with this?

Topic Labels: Formulas
Solved
Jump to Solution
3092 9
cancel
Showing results for 
Search instead for 
Did you mean: 
Leslie_Miller
6 - Interface Innovator
6 - Interface Innovator

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?

1 Solution

Accepted Solutions
Jeremy_Oglesby
14 - Jupiter
14 - Jupiter

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.

See Solution in Thread

9 Replies 9
Jeremy_Oglesby
14 - Jupiter
14 - Jupiter

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.

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?

Yep - that looks valid to me.

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

what key strokes are used for nesting spacebars or tab?

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

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.

It was the straight quotes! Good call!

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.