- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Sep 13, 2023 07:56 AM
I work where following up with my clients are essential.
Right now I have 3 columns in the table that. I'm trying to link together using IF Formula and it's not working so looking for some help here.
First column is "Last Contact Date" which is in "Date" format and next one is "Schedule follow up" which is in "multiple selection" format with 1 day, 3 days, 1 week, 2 weeks, 1 month, 2 months, 3 months 6 months, 1 year. Last column is "Next contact day" where I'm trying to use IF formula to calculate the new date for me and they give me the new date for me. So below is what I have and right now, it's keep saying N/A.
Not sure where I went wrong or how to fix it. Please advise how I could fix this.
Thank you so much in advance.

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Sep 13, 2023 07:16 PM
Very deep IF statements are confusing.
Let's use the SWITCH function.
Also, use the Dateadd function to add dates.
IF({Last Contact Date},
SWITCH({Schedule follow up},
"1 Day", DATEADD({Last Contact Date}, 1, "day"),
"1 Month", DATEADD({Last Contact Date}, 1, "Month"),
"1+ Year", DATEADD({Last Contact Date}, 1, "Year")
)
)
