- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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.
Accepted Solutions
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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')
)
)
)
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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()
)))
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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()
)))
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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()
)))
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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'),
)
)
)
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Apr 06, 2020 02:58 PM
That still did not work, what am I missing
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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?
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Apr 06, 2020 03:05 PM
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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')
)
)
)
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Apr 06, 2020 03:38 PM
You are a genius THANK YOU!!!