Skip to main content

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?

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.


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?


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.


Yep - that looks valid to me.


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


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


what key strokes are used for nesting spacebars or tab?


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.


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.


Reply