Apr 06, 2020 11:55 AM
I want to formulate a date if:
under one column the answer is 3-day add 3 days to date
under one column the answer is 2- day add 2 days to date
under one column the answer is 1- day add 1 day to date
I think I begin like this, DATEADD({Proposed Date of W/C},3, ‘days’)
but how do I formulate the if this then that?
Solved! Go to Solution.
Apr 06, 2020 03:10 PM
Thanks, @Leslie_Miller - that was my bad. I left an erroneous comma in there. Try this:
IF(
SEARCH("1", {Type of Workshop or Class Offered}),
DATEADD({Proposed Date of Workshop or Class}, 1, 'days'),
IF(
SEARCH("2", {Type of Workshop or Class Offered}),
DATEADD({Proposed Date of Workshop or Class}, 2, 'days'),
IF(
SEARCH("3", {Type of Workshop or Class Offered}),
DATEADD({Proposed Date of Workshop or Class}, 3, 'days')
)
)
)
Apr 06, 2020 01:15 PM
IF(
SEARCH("1", {Day Course}),
DATEADD(Date, 1, 'days'),
IF(
SEARCH("2", {Day Course}),
DATEADD(Date, 2, 'days'),
IF(
SEARCH("3", {Day Course}),
DATEADD(Date, 3, 'days'),
BLANK()
)))
Apr 06, 2020 01:34 PM
Thanks so much for your response.
not quite right yet, trying different scenarios, I think this might be close
IF(
SEARCH(“1”, {Type of Workshop or Class Offered}}),
DATEADD(Date, 1, ‘days’),
IF(
SEARCH(“2”, {Type of Workshop or Class Offered}),
DATEADD(Date, 2, ‘days’),
IF(
SEARCH(“3”, {Type of Workshop or Class Offered}{Day Course}),
DATEADD(Date, 3, ‘days’),
BLANK()
)))
Apr 06, 2020 01:44 PM
Tried this, still no luck
IF(
SEARCH(“1”, {Type of Workshop or Class Offered}}),
DATEADD {Proposed Date of Workshop or Class} 1, ‘days’),
IF(
SEARCH(“2”, {Type of Workshop or Class Offered}),
DATEADD {Proposed Date of Workshop or Class} 2, ‘days’),
IF(
SEARCH(“3”, {Type of Workshop or Class Offered}),
DATEADD {Proposed Date of Workshop or Class} 3, ‘days’),
BLANK()
)))
Apr 06, 2020 02:34 PM
IF(
SEARCH("1", {Type of Workshop or Class Offered}),
DATEADD({Proposed Date of Workshop or Class}, 1, 'days'),
IF(
SEARCH("2", {Type of Workshop or Class Offered}),
DATEADD({Proposed Date of Workshop or Class}, 2, 'days'),
IF(
SEARCH("3", {Type of Workshop or Class Offered}),
DATEADD({Proposed Date of Workshop or Class}, 3, 'days'),
)
)
)
Apr 06, 2020 02:58 PM
That still did not work, what am I missing
Apr 06, 2020 03:02 PM
How did it fail? Are you getting an error message in the formula editor? Is it just not returning what you expected? What is the nature of the failure?
Apr 06, 2020 03:05 PM
Apr 06, 2020 03:10 PM
Thanks, @Leslie_Miller - that was my bad. I left an erroneous comma in there. Try this:
IF(
SEARCH("1", {Type of Workshop or Class Offered}),
DATEADD({Proposed Date of Workshop or Class}, 1, 'days'),
IF(
SEARCH("2", {Type of Workshop or Class Offered}),
DATEADD({Proposed Date of Workshop or Class}, 2, 'days'),
IF(
SEARCH("3", {Type of Workshop or Class Offered}),
DATEADD({Proposed Date of Workshop or Class}, 3, 'days')
)
)
)
Apr 06, 2020 03:38 PM
You are a genius THANK YOU!!!